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 MKC67F0580Accident · Minor injuriesClosedCessna 140 · Lakin, KSApr 27, 1967 · N2326V · Substantial damage NTSB LAX67F0432Accident · Serious injuriesClosedCessna 140 · Compton, CAApr 26, 1967 · N77268 · Destroyed NTSB MKC68D0061Accident · No injuriesClosedCessna 140 · Harvey, NDApr 25, 1967 · N2063V · Substantial damage NTSB MKC67D0578Accident · No injuriesClosedCessna 140 · Thief R Flls, MNMar 27, 1967 · N3612V · Substantial damage NTSB MIA67F0478Accident · Serious injuriesClosedCessna 140 · Lake Wales, FLMar 26, 1967 · N2317N · Substantial damage NTSB DEN67D0266Accident · No injuriesClosedCessna 140 · Milford, UTMar 26, 1967 · N6321D · Substantial damage NTSB LAX67A0087Accident · 2 fatalClosedCessna 140 · Parker, AZMar 25, 1967 · N76881 · Destroyed NTSB NYC67D0580Accident · No injuriesClosedCessna 140 · Asbury Park, NJMar 14, 1967 · N77167 · Substantial damage NTSB FTW67F0498Accident · Serious injuriesClosedCessna 140 · San Marcos, TXMar 12, 1967 · N76851 · Substantial damage NTSB OAK67D0254Accident · No injuriesClosedCessna 140 · Coalinga, CAMar 9, 1967 · N2371V · Substantial damage NTSB MIA68D0106Accident · No injuriesClosedCessna 140 · Ormond Beach, FLMar 5, 1967 · N72962 · Substantial damage NTSB MIA67F0452Accident · No injuriesClosedCessna 140 · Amory, MSMar 5, 1967 · N2194N · Substantial damage NTSB FTW67F0481Accident · Serious injuriesClosedCessna 140 · Marlow, OKMar 3, 1967 · N90045 · Substantial damage NTSB NYC67D0538Accident · No injuriesClosedCessna 140 · Nashua, NHMar 2, 1967 · N73096 · Substantial damage NTSB NYC67D0553Accident · No injuriesClosedCessna 140 · West Chester, PAFeb 26, 1967 · N72995 · Substantial damage NTSB MKC67D0483Accident · No injuriesClosedCessna 140 · Cohasset, MNFeb 25, 1967 · N3709V · Substantial damage NTSB DEN67D0228Accident · No injuriesClosedCessna 140 · Glenwood Spg, COFeb 23, 1967 · N2167V · Substantial damage NTSB CHI67F0542Accident · Serious injuriesClosedCessna 140 · Pine Top, KYFeb 22, 1967 · N89499 · Destroyed NTSB SEA67D0241Accident · No injuriesClosedCessna 140 · Starbuck, WAFeb 8, 1967 · N77018 · Substantial damage NTSB DIA67F0061Accident · No injuriesClosedCessna 140 · Wilmington, DEFeb 8, 1967 · N89328 · Substantial damage NTSB CHI67F0467Accident · No injuriesClosedCessna 140 · Elkhart, INFeb 5, 1967 · N2264V · Substantial damage NTSB SEA67D0284Accident · No injuriesClosedCessna 140 · Bothell, WAJan 30, 1967 · N2199N · Substantial damage NTSB SEA67D0283Accident · No injuriesClosedCessna 140 · Redmond, WAJan 30, 1967 · N89528 · Substantial damage NTSB FTW67D0425Accident · No injuriesClosedCessna 140 · Baton Rouge, LAJan 30, 1967 · N72844 · Substantial damage NTSB OAK67D0217Accident · No injuriesClosedCessna 140 · Newman, CAJan 13, 1967 · N72777 · Substantial damage NTSB NYC67D0485Accident · No injuriesClosedCessna 140 · Red Bank, NJJan 2, 1967 · N72427 · Substantial damage NTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NEDec 30, 1966 · N2397V · Substantial damage NTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CADec 29, 1966 · N89981 · Destroyed NTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INDec 25, 1966 · N2919N · Substantial damage NTSB LAX67A0061Accident · 1 fatalClosedCessna 140 · Chatsworth, CADec 23, 1966 · N77213 · 2 aircraft · Destroyed NTSB CHI67D0427Accident · No injuriesClosedCessna 140 · Cleveland, OHDec 17, 1966 · N2424V · Substantial damage NTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MIDec 11, 1966 · N89673 · Substantial damage NTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONov 26, 1966 · N3532V · Substantial damage NTSB MKC67D0297Accident · No injuriesClosedCessna 140 · Moorhead, IANov 12, 1966 · N76487 · Substantial damage NTSB FTW67F0285Accident · No injuriesClosedCessna 140 · Arlington, TXNov 5, 1966 · N1710V · Substantial damage NTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PAOct 30, 1966 · N1992V · Substantial damage NTSB MKC67D0301Accident · No injuriesClosedCessna 140 · Winona, MNOct 27, 1966 · N2181N · Substantial damage NTSB LAX67D0196Accident · No injuriesClosedCessna 140 · Chino, CAOct 25, 1966 · N2133N · Substantial damage NTSB LAX67D0206Accident · No injuriesClosedCessna 140 · Blythe, CAOct 2, 1966 · N89923 · Substantial damage NTSB NYC67D0295Accident · No injuriesClosedCessna 140 · Lindenhurst, NYSep 28, 1966 · N89262 · Substantial damage NTSB CHI67D0202Accident · No injuriesClosedCessna 140 · Napoleon, MISep 18, 1966 · N89822 · Substantial damage NTSB OAK67D0128Accident · No injuriesClosedCessna 140 · Columbia, CASep 17, 1966 · N77083 · Substantial damage NTSB MKC67F0238Accident · Minor injuriesClosedCessna 140 · Franklin, MNSep 17, 1966 · N2237V · Substantial damage NTSB SEA67D0120Accident · No injuriesClosedCessna 140 · Great Falls, MTSep 15, 1966 · N72308 · Substantial damage NTSB FTW67D0270Accident · No injuriesClosedCessna 140 · Grapevine, TXSep 13, 1966 · N1710V · Substantial damage NTSB LAX67D0141Accident · No injuriesClosedCessna 140 · San Diego, CASep 12, 1966 · N2351V · Substantial damage NTSB LAX67D0144Accident · No injuriesClosedCessna 140 · Santa Susana, CASep 7, 1966 · N72677 · Substantial damage NTSB SEA67F0109Accident · Minor injuriesClosedCessna 140 · Walla Walla, WASep 4, 1966 · N2222N · Substantial damage NTSB OAK67D0121Accident · No injuriesClosedCessna 140 · Las Vegas, NVSep 3, 1966 · N72685 · Substantial damage NTSB FTW67F0191Accident · No injuriesClosedCessna 140 · Brinkley, ARAug 30, 1966 · N1408U · Substantial damage

Back to Cessna 140