NTSB Aviation Accident Scraper avatar

NTSB Aviation Accident Scraper

Pricing

from $3.00 / 1,000 results

Go to Apify Store
NTSB Aviation Accident Scraper

NTSB Aviation Accident Scraper

Scrape NTSB's public CAROL database of U.S. aviation accidents and incidents. Search by NTSB number, registration, operator, airport, date range, aircraft category, injury severity, and more, or browse aviation safety recommendations.

Pricing

from $3.00 / 1,000 results

Rating

0.0

(0)

Developer

Crawler Bros

Crawler Bros

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

4 days ago

Last modified

Share

Scrape the National Transportation Safety Board (NTSB) public CAROL database of U.S. aviation accidents and incidents. Search over 180,000 aviation cases by NTSB number, registration number, operator, airport, location, date range, aircraft category, injury severity, damage, FAR part, phase of flight, and more — or browse aviation safety recommendations issued to the FAA and other agencies. HTTP-only via NTSB's public query API. No auth, no cookies, no proxy required.

What this actor does

  • Two modes: accidents (aviation accident/incident case search) and safetyRecommendations (safety recommendations to the FAA and other addressees)
  • 30+ filters covering the full NTSB CAROL query-builder surface — location, aircraft (make/model/serial/engines/amateur-built), operation type (GA/air medical/sightseeing/second pilot), weather, event category, phase of flight, lead investigating agency, detailed recommendation status/addressee category, and more
  • Date range filters for event date (accidents) and date issued (recommendations)
  • Sortable by event date, NTSB number, city, state, country, highest injury level, aircraft registration, aircraft category, or date issued
  • Direct links to the NTSB CAROL case detail page for every record
  • Empty fields are omitted — every record only contains fields NTSB actually reported

Output: per-accident (mode = accidents)

  • ntsbNumber — NTSB case number, e.g. ERA24LA084
  • caseKey — internal NTSB case key (Mkey)
  • eventId — NTSB event ID
  • completionStatusCompleted or In-work
  • eventTypeAccident, Incident, or Occurrence
  • isStudy — whether the case is a special study
  • eventDate — ISO date/time of the event
  • city, state, country
  • reportNumber
  • registrationNumber — aircraft tail number (N-number)
  • aircraftMake, aircraftModel
  • additionalAircraft — for cases involving more than one aircraft (e.g. midair collisions), an array of {registrationNumber, aircraftMake, aircraftModel} for every aircraft beyond the first
  • highestInjuryLevelFatal, Serious, Minor, or None
  • injuryOnGroundCount, injuryOnboardCount
  • hasSafetyRecommendation — whether a safety recommendation resulted from this case
  • investigationMode — always Aviation
  • reportType, mostRecentReportType
  • docketPublishDate, originalPublishedDate, reportDate
  • sourceUrl — link to the NTSB CAROL case detail page
  • recordType: "aviationAccident", scrapedAt

Output: per-recommendation (mode = safetyRecommendations)

  • recommendationId — safety recommendation ID, e.g. A-70-037
  • status — detailed status, e.g. Closed - Acceptable Action
  • investigationMode — always Aviation
  • recommendationText — full recommendation text
  • codingMode, codingTier1, codingTier2 — NTSB safety-issue coding taxonomy
  • relatedNtsbNumber — the accident case this recommendation stems from
  • caseKey
  • addresseeName — agency/organization the recommendation was sent to
  • dateClosed
  • eventDate, city, state, country
  • reportNumber, reportNumberCleaned
  • sourceUrl — link to the NTSB CAROL case detail page
  • recordType: "safetyRecommendation", scrapedAt

Input

FieldTypeDefaultDescription
modestringaccidentsaccidents / safetyRecommendations
ntsbNumberstringNTSB number contains (mode=accidents)
registrationNumberstringAircraft N-number contains (mode=accidents)
operatorNamestringOperator/airline name contains (mode=accidents)
airportNamestringAirport name contains (mode=accidents)
citystringCity contains (mode=accidents)
statestringU.S. state/region select (mode=accidents)
countrystringCountry name, e.g. United States (mode=accidents)
eventDateFrom / eventDateTostringEvent date range (mode=accidents)
highestInjurystringFatal / Serious / Minor / None
eventTypestringAccident / Incident / Occurrence
aircraftCategorystringAirplane, Helicopter, Glider, etc.
engineTypestringReciprocating, Turbo fan, Electric, etc.
damagestringDestroyed / Substantial / Minor / None
farPartstringFAA regulation part (Part 91, 121, 135, …)
flightOperationTypestringPersonal, Business, Instructional, etc.
flightServiceTypestringPassenger / Cargo / Mail
flightScheduledTypestringScheduled / Non-scheduled
weatherConditionstringVMC / IMC
eventCategorystringCICTT event category (Loss of Control, CFIT, …)
phaseOfFlightstringTakeoff, Landing, Enroute, etc.
openClosedStatusstringInvestigation Completed / In-work
minOnboardInjuriesintMinimum onboard injury/fatality count
aircraftMakestringAircraft manufacturer contains, e.g. Cessna
aircraftModelstringAircraft model contains, e.g. 172
registeredOwnerstringAircraft registered owner name contains
airportIdstringNearest airport identifier/code contains, e.g. ORD
serialNumberstringAircraft manufacturer serial number contains
numberOfEnginesintExact number of engines (1–8)
amateurBuiltstringHomebuilt/amateur-built aircraft only, or exclude
generalAviationFlightstringGeneral aviation flights only, or exclude
airMedicalFlightstringAir medical (air ambulance) flights only, or exclude
commercialSightseeingstringCommercial sightseeing flights only, or exclude
secondPilotPresentstringWhether a second pilot was onboard
leadAgencystringLead investigating agency: NTSB, Other, US Coast Guard
recKeywordstringRecommendation text contains (mode=safetyRecommendations)
addresseeNamestringAddressee agency contains (mode=safetyRecommendations)
recStatusstringOpen / Closed
recPrioritystringUrgent / Non-urgent
recDetailedStatusstringDetailed 15-value recommendation status (e.g. Open - Await Response, Closed - Superseded)
addresseeCategorystringType of organization addressed (Federal Government, Private Industry, Airport, etc.)
isReiteratedstringRecommendations NTSB has reiterated to the addressee, or exclude
recDateIssuedFrom / recDateIssuedTostringDate issued range (mode=safetyRecommendations)
sortBystringevent dateSort column: event date, NTSB number, city, state, country, highest injury, aircraft registration, aircraft category, or date issued (recommendations)
sortDescendingbooleantrueSort newest first
maxItemsint50Hard cap on emitted records (1–5000)
proxyConfigurationobjectApify proxyNot required for normal use since NTSB CAROL is publicly accessible; only engaged automatically if the upstream API returns a block response

Example: recent fatal accidents in California

{
"mode": "accidents",
"state": "CA",
"highestInjury": "Fatal",
"eventDateFrom": "2023-01-01",
"maxItems": 100
}

Example: helicopter accidents under Part 135

{
"mode": "accidents",
"aircraftCategory": "HELI",
"farPart": "135",
"maxItems": 50
}

Example: open safety recommendations to the FAA

{
"mode": "safetyRecommendations",
"addresseeName": "FAA",
"recStatus": "open",
"maxItems": 100
}

Example: search by aircraft registration

{
"mode": "accidents",
"registrationNumber": "N12345",
"maxItems": 10
}

Example: amateur-built Cessna accidents

{
"mode": "accidents",
"aircraftMake": "Cessna",
"amateurBuilt": "true",
"maxItems": 50
}

Example: open safety recommendations awaiting response from federal agencies

{
"mode": "safetyRecommendations",
"recDetailedStatus": "11",
"addresseeCategory": "3",
"maxItems": 100
}

Use cases

  • Aviation safety research — analyze accident trends by aircraft category, phase of flight, or event type
  • Insurance & risk assessment — pull accident history for specific aircraft registrations or operators
  • Journalism — investigate accidents at specific airports or by specific operators
  • Regulatory compliance — track open safety recommendations affecting your organization
  • Academic studies — bulk-export aviation accident data for statistical analysis
  • Aircraft due-diligence — check an N-number's accident/incident history before purchase

FAQ

What is the data source? NTSB's public CAROL (Case Analysis Reporting Online) database at data.ntsb.gov — the same system that powers the public search UI at ntsb.gov. This actor calls the same public JSON query API the website itself uses.

Is this affiliated with the NTSB? No. This is an independent, third-party actor built on NTSB's publicly accessible query API.

How far back does the data go? NTSB's aviation accident database goes back to the 1960s for older, briefer records, with full detail from the 1980s onward.

How fresh is the data? Data reflects NTSB's live CAROL database, updated continuously as investigations progress.

Why are some fields missing on a record? NTSB doesn't populate every field for every case (e.g., older or still-open investigations may lack some details). Empty fields are omitted rather than returned as null.

What does mode=accidents vs mode=safetyRecommendations return? accidents returns individual aviation accident/incident case records. safetyRecommendations returns the formal safety recommendations NTSB issues to agencies like the FAA as a result of investigations — a distinct, smaller dataset.

Can I filter by both state and country? Yes — filters combine with AND logic. Combining a narrow location filter with a narrow date range may return 0 results if no matching cases exist; that's expected NTSB data, not an actor error.

Is a proxy required? No. NTSB CAROL's API is publicly accessible without a proxy. The actor only engages the free Apify AUTO proxy automatically if the upstream API ever returns a block response.