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 CHI70D0294Accident · No injuriesClosedCessna 140 · St Ignace, MIOct 10, 1969 · N3591V · Substantial damage NTSB MKC70A0014Accident · 2 fatalClosedCessna 140 · Hartley, IAOct 1, 1969 · N1984V · Destroyed NTSB FTW70F0278Accident · Minor injuriesClosedCessna 140 · Pineville, ARSep 30, 1969 · N90017 · Substantial damage NTSB NYC70F0132Accident · No injuriesClosedCessna 140 · Hellertown, PASep 14, 1969 · N2196N · Substantial damage NTSB NYC70D0159Accident · No injuriesClosedCessna 140 · Westboro, MASep 14, 1969 · N72366 · Substantial damage NTSB CHI70F0248Accident · No injuriesClosedCessna 140 · Columbus, OHSep 14, 1969 · N4255N · Substantial damage NTSB OAK70D0178Accident · No injuriesClosedCessna 140 · Searchlight, NVSep 13, 1969 · N2629N · Destroyed NTSB CHI70F0232Accident · Minor injuriesClosedCessna 140 · Traverse Cty, MISep 13, 1969 · N2727N · Substantial damage NTSB SEA70D0123Accident · No injuriesClosedCessna 140 · Roseburg, ORSep 2, 1969 · N76445 · Substantial damage NTSB FTW70D0190Accident · No injuriesClosedCessna 140 · Enid, OKAug 31, 1969 · N2020N · Substantial damage NTSB SEA70F0054Accident · No injuriesClosedCessna 140 · Everett, WAAug 30, 1969 · N89183 · Substantial damage NTSB MIA70D0249Accident · Serious injuriesClosedCessna 140 · Cleveland, GAAug 30, 1969 · N77142 · Substantial damage NTSB CHI70D0298Accident · No injuriesClosedCessna 140 · Chilton, WIAug 24, 1969 · N1999V · Substantial damage NTSB LAX70F0116Accident · No injuriesClosedCessna 140 · Chino, CAAug 23, 1969 · N77119 · Substantial damage NTSB SEA70A0010Accident · 1 fatalClosedCessna 140 · Newport, ORAug 14, 1969 · N2225N · Destroyed NTSB NYC70D0084Accident · No injuriesClosedCessna 140 · Austerlitz, NYAug 9, 1969 · N76833 · Substantial damage NTSB CHI70F0205Accident · No injuriesClosedCessna 140 · Mt.Vernon, ILAug 5, 1969 · N2010N · Substantial damage NTSB FTW70D0150Accident · No injuriesClosedCessna 140 · San Antonio, TXJul 21, 1969 · N4060N · Substantial damage NTSB CHI70F0128Accident · Minor injuriesClosedCessna 140 · Findlay, OHJul 19, 1969 · N4064N · Destroyed NTSB DEN70F0035Accident · Serious injuriesClosedCessna 140 · Gallup, NMJul 11, 1969 · N2393V · Destroyed NTSB CHI70F0112Accident · No injuriesClosedCessna 140 · Breman, INJul 8, 1969 · N4209N · Substantial damage NTSB LAX70F0035Accident · Minor injuriesClosedCessna 140 · La Verne, CAJul 4, 1969 · N89951 · Destroyed NTSB MIA70D0106Accident · Minor injuriesClosedCessna 140 · Walterboro, SCJun 26, 1969 · N76115 · Substantial damage NTSB CHI70F0127Accident · No injuriesClosedCessna 140 · Romeo, MIJun 25, 1969 · N72631 · Substantial damage NTSB OAK70D0020Accident · Minor injuriesClosedCessna 140 · Hana, HIJun 14, 1969 · N72838 · Substantial damage NTSB MKC70D0024Accident · No injuriesClosedCessna 140 · Buffalo, MNJun 14, 1969 · N4280N · Substantial damage NTSB SEA70D0016Accident · Minor injuriesClosedCessna 140 · Alderwood M, WAJun 13, 1969 · N76756 · Substantial damage NTSB ANC70D0052Accident · No injuriesClosedCessna 140 · Pedro Bay, AKJun 11, 1969 · N1826V · Substantial damage NTSB CHI70F0078Accident · Minor injuriesClosedCessna 140 · Jacksonville, ILJun 2, 1969 · N274 · Destroyed NTSB MIA69F0491Accident · Minor injuriesClosedCessna 140 · Temple, GAMay 28, 1969 · N76146 · Substantial damage NTSB CHI70D0073Accident · Minor injuriesClosedCessna 140 · Paris, ILMay 23, 1969 · N2293N · Substantial damage NTSB MIA70D0055Accident · No injuriesClosedCessna 140 · Okeechobee, FLMay 14, 1969 · N76035 · Substantial damage NTSB DIA69D0189Accident · No injuriesClosedCessna 140 · Baileys Xroads, VAMay 14, 1969 · N89711 · Substantial damage NTSB LAX69A0067Accident · 1 fatalClosedCessna 140 · Temecula, CAMay 13, 1969 · N1950N · Destroyed NTSB LAX70F0002Accident · No injuriesClosedCessna 140 · Agua Dulce, CAMay 4, 1969 · N2190V · Substantial damage NTSB CHI70D0001Accident · No injuriesClosedCessna 140 · Shepherdsville, KYMay 4, 1969 · N3598V · Substantial damage NTSB NYC69F0386Accident · No injuriesClosedCessna 140 · Biddeford, MEApr 30, 1969 · N76527 · Substantial damage NTSB NYC69D0449Accident · No injuriesClosedCessna 140 · Agawam, MAApr 26, 1969 · N3572V · Substantial damage NTSB DEN69D0252Accident · No injuriesClosedCessna 140 · Shiprock, NMApr 24, 1969 · N89194 · Substantial damage NTSB SEA69D0222Accident · No injuriesClosedCessna 140 · Idaho Falls, IDApr 22, 1969 · N1926V · Substantial damage NTSB MKC69D0422Accident · No injuriesClosedCessna 140 · Willmar, MNApr 19, 1969 · N3577V · Substantial damage NTSB SEA69D0224Accident · No injuriesClosedCessna 140 · Kellogg, IDApr 14, 1969 · N76978 · Substantial damage NTSB SEA69D0266Accident · No injuriesClosedCessna 140 · Yale, WAApr 12, 1969 · N90021 · Substantial damage NTSB CHI69F0583Accident · Minor injuriesClosedCessna 140 · West Paducah, KYApr 12, 1969 · N72616 · Destroyed NTSB SEA69D0205Accident · No injuriesClosedCessna 140 · Midvale, IDApr 10, 1969 · N72758 · Substantial damage NTSB OAK69D0275Accident · No injuriesClosedCessna 140 · Morgan Hill, CAApr 8, 1969 · N2278N · Substantial damage NTSB NYC69F0376Accident · No injuriesClosedCessna 140 · Biddeford, MEApr 6, 1969 · N2140N · Substantial damage NTSB FTW69D0442Accident · No injuriesClosedCessna 140 · Burleson, TXApr 6, 1969 · N72949 · Substantial damage NTSB FTW69D0422Accident · No injuriesClosedCessna 140 · Weatherford, OKApr 3, 1969 · N77053 · Substantial damage NTSB MIA69D0433Accident · No injuriesClosedCessna 140 · Jefferson, GAMar 31, 1969 · N2869N · Substantial damage

Back to Cessna 140