Skip to content

NTSB investigations · 1,320

Matched to the registry by N-number and event date, newest first.

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2071602', '2071603') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2071602', '2071603')
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2071602', '2071603')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB UNK64X3425Accident · No injuriesClosedCessna 140 · Farmington, NMAug 16, 1964 · N2787N · Destroyed NTSB UNK64X3423Accident · Minor injuriesClosedCessna 140 · Waukesea, WIAug 16, 1964 · N89345 · Destroyed NTSB UNK64X3363AccidentClosedCessna 140 · Sterling, COAug 13, 1964 · N72394 · Substantial damage NTSB UNK64X3298Accident · No injuriesClosedCessna 140 · Denver, COAug 9, 1964 · N76147 · Substantial damage NTSB UNK64X3196Accident · No injuriesClosedCessna 140 · Medicine Lke, MTAug 3, 1964 · N2362V · Substantial damage NTSB UNK64X3195Accident · No injuriesClosedCessna 140 · Janesville, WIAug 3, 1964 · N2084V · Substantial damage NTSB UNK64X3194Accident · No injuriesClosedCessna 140 · Minneapolis, MNAug 3, 1964 · N76346 · Destroyed NTSB UNK64X3152Accident · No injuriesClosedCessna 140 · Van Nuys, CAAug 1, 1964 · N3747V · Substantial damage NTSB UNK64X3145Accident · No injuriesClosedCessna 140 · Parrish, FLAug 1, 1964 · N89196 · Substantial damage NTSB UNK64X3084Accident · No injuriesClosedCessna 140 · Weiser, IDJul 28, 1964 · N2370V · Substantial damage NTSB UNK64X3033Accident · No injuriesClosedCessna 140 · Barre, VTJul 25, 1964 · N89746 · Substantial damage NTSB UNK64X3029Accident · Minor injuriesClosedCessna 140 · Schoolcraft, MIJul 25, 1964 · N3626V · Destroyed NTSB UNK64X2920Accident · No injuriesClosedCessna 140 · Selma, CAJul 19, 1964 · N77265 · Substantial damage NTSB UNK64X2842Accident · No injuriesClosedCessna 140 · Daytona Beach, FLJul 15, 1964 · N90174 · Substantial damage NTSB UNK64X2830Accident · Minor injuriesClosedCessna 140 · Compton, CAJul 14, 1964 · N89236 · Destroyed NTSB UNK64X2823Accident · No injuriesClosedCessna 140 · Lagrange, TXJul 14, 1964 · N89257 · Destroyed NTSB UNK64X2767Accident · No injuriesClosedCessna 140 · Kinston, NCJul 11, 1964 · N72223 · Destroyed NTSB UNK64X2701Accident · No injuriesClosedCessna 140 · Bowling Green, KYJul 7, 1964 · N2403V · Substantial damage NTSB UNK64X2652Accident · No injuriesClosedCessna 140 · Marissa, ILJul 5, 1964 · N89838 · Substantial damage NTSB UNK64X2622Accident · No injuriesClosedCessna 140 · Uhrichsville, OHJul 3, 1964 · N77002 · Substantial damage NTSB UNK64X2580Accident · No injuriesClosedCessna 140 · Akron, OHJun 30, 1964 · N76919 · Substantial damage NTSB UNK64X2537Accident · No injuriesClosedCessna 140 · Collegeville, PAJun 28, 1964 · N72347 · Destroyed NTSB UNK64X2371Accident · No injuriesClosedCessna 140 · Santanta, KSJun 19, 1964 · N2367V · Destroyed NTSB UNK64X2346Accident · Serious injuriesClosedCessna 140 · Ft Lauderdale, FLJun 17, 1964 · N90198 · Destroyed NTSB UNK64X2128Accident · No injuriesClosedCessna 140 · Boise, IDJun 5, 1964 · N76680 · Substantial damage NTSB UNK64X2103Accident · No injuriesClosedCessna 140 · Hillsboro, VAJun 4, 1964 · N2298V · Substantial damage NTSB UNK64X2088Accident · No injuriesClosedCessna 140 · Decatur, INJun 3, 1964 · N76537 · Substantial damage NTSB UNK64X1987Accident · No injuriesClosedCessna 140 · Libertyville, INMay 28, 1964 · N2919N · Substantial damage NTSB UNK64X1955Accident · No injuriesClosedCessna 140 · Clare, MIMay 25, 1964 · N72856 · Substantial damage NTSB UNK64X1933Accident · No injuriesClosedCessna 140 · W Milford, NJMay 24, 1964 · N1931N · Substantial damage NTSB UNK64X1905Accident · No injuriesClosedCessna 140 · Marion, IAMay 23, 1964 · N81030 · Substantial damage NTSB UNK64X1789Accident · No injuriesClosedCessna 140 · Ellensburg, WAMay 16, 1964 · N2432N · Substantial damage NTSB UNK64X1787Accident · No injuriesClosedCessna 140 · Belgrade, MTMay 16, 1964 · N76850 · Substantial damage NTSB UNK64X1709Accident · No injuriesClosedCessna 140 · Atwood, ILMay 10, 1964 · N76501 · Substantial damage NTSB UNK64X1699Accident · Minor injuriesClosedCessna 140 · Glenwood, ILMay 10, 1964 · N89671 · Substantial damage NTSB UNK64X1687Accident · No injuriesClosedCessna 140 · Hamilton, ILMay 9, 1964 · N1621V · Substantial damage NTSB UNK64X1686Accident · No injuriesClosedCessna 140 · Pensacola, FLMay 9, 1964 · N89175 · Substantial damage NTSB UNK64X1684Accident · No injuriesClosedCessna 140 · Moab, UTMay 9, 1964 · N2634N · Destroyed NTSB UNK64X1625Accident · 2 fatalClosedCessna 140 · Winslow, AZMay 5, 1964 · N72621 · Destroyed NTSB UNK64X1616Accident · No injuriesClosedCessna 140 · Boulder, COMay 4, 1964 · N72542 · Substantial damage NTSB UNK64X1603Accident · No injuriesClosedCessna 140A · Frederick, OKMay 3, 1964 · N72385 · Substantial damage NTSB UNK64X1597Accident · No injuriesClosedCessna 140 · Fullerton, CAMay 3, 1964 · N72202 · Substantial damage NTSB UNK64X1558Accident · No injuriesClosedCessna 140 · Watervliet, MIMay 2, 1964 · N76276 · Substantial damage NTSB UNK64X1503Accident · 2 fatalClosedCessna 140 · Elko, NVApr 28, 1964 · N2287V · Destroyed NTSB UNK64X1468Accident · No injuriesClosedCessna 140 · San Diego, CAApr 26, 1964 · N2790N · Substantial damage NTSB UNK64X1279Accident · No injuriesClosedCessna 140A · Burns, ORApr 12, 1964 · N5309C · Substantial damage NTSB UNK64X1264Accident · No injuriesClosedCessna 140 · Bakersfield, CAApr 11, 1964 · N73026 · Substantial damage NTSB UNK64X1258Accident · No injuriesClosedCessna 140A · Marlboro, MAApr 11, 1964 · N89489 · Substantial damage NTSB UNK64X1147Accident · No injuriesClosedCessna 140 · Palestine, TXApr 3, 1964 · N89348 · Substantial damage NTSB UNK64X1139Accident · No injuriesClosedCessna 140 · Ord, NEApr 3, 1964 · N76748 · Substantial damage

Back to Cessna 140