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 DEN74DTE51Accident · No injuriesClosedCessna 140 · Otis, COFeb 3, 1974 · N72611 · Substantial damage NTSB FTW74FRG54Accident · Minor injuriesClosedCessna 140 · Portland, TXJan 20, 1974 · N2851N · Substantial damage NTSB MIA74FKG46Accident · Minor injuriesClosedCessna 140 · Savannah, GADec 3, 1973 · N2220N · Substantial damage NTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORDec 1, 1973 · N76006 · Substantial damage NTSB CHI74AEV27Accident · Serious injuriesClosedCessna 140 · Hull, ILNov 5, 1973 · N72391 · Substantial damage NTSB NYC74DNC29Accident · No injuriesClosedCessna 140 · Gilmanton, NHNov 4, 1973 · N353T · Substantial damage NTSB LAX74DUJ29Accident · No injuriesClosedCessna 140 · Willcox, AZNov 3, 1973 · N2256N · Substantial damage NTSB NYC74FNE10Accident · No injuriesClosedCessna 140 · Simsbury, CTNov 2, 1973 · N4220N · Substantial damage NTSB LAX74FUG23Accident · Serious injuriesClosedCessna 140 · Simi Valley, CAOct 29, 1973 · N89259 · Substantial damage NTSB SEA74DYC21Accident · No injuriesClosedCessna 140 · Astoria, OROct 8, 1973 · N3086N · Substantial damage NTSB DEN74AD013Accident · 1 fatalClosedCessna 140 · Divide, COOct 2, 1973 · N89304 · Substantial damage NTSB MIA74FKG26Accident · Minor injuriesClosedCessna 140 · Stockbridge, GASep 8, 1973 · N76217 · Destroyed NTSB IAD74DKM18Accident · No injuriesClosedCessna 140 · Greensboro, NCSep 3, 1973 · N2652N · Substantial damage NTSB SEA74DYA10Accident · No injuriesClosedCessna 140 · Preston, IDAug 30, 1973 · N76057 · Substantial damage NTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSAug 26, 1973 · N4190N · Substantial damage NTSB SEA74FTA06Accident · Serious injuriesClosedCessna 140 · Ekalaka, MTAug 13, 1973 · N77002 · Substantial damage NTSB MIA74DKG11Accident · No injuriesClosedCessna 140 · Thomaston, GAAug 12, 1973 · N77166 · Substantial damage NTSB MKC74FCG07Accident · No injuriesClosedCessna 140 · Kansas City, MOAug 10, 1973 · N2314N · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB OAK74DVG04Accident · No injuriesClosedCessna 140 · Georgetown, CAJul 14, 1973 · N2168N · Substantial damage NTSB IAD74DLT01Accident · No injuriesClosedCessna 140 · Arlington, TNJul 8, 1973 · N89330 · Substantial damage NTSB CHI74AEV01Accident · No injuriesClosedCessna 140 · Metamora, ILJul 7, 1973 · N2123N · Substantial damage NTSB CHI74DEI01Accident · No injuriesClosedCessna 140 · Canton, OHJul 3, 1973 · N89784 · Substantial damage NTSB OAK74FVG01Accident · Serious injuriesClosedCessna 140 · Grass Vally, CAJul 1, 1973 · N2392V · Substantial damage NTSB FTW73DRA39Accident · No injuriesClosedCessna 140 · Normangee, TXJun 29, 1973 · N2119N · Substantial damage NTSB MIA73DLA47Accident · No injuriesClosedCessna 140 · Cross City, FLJun 26, 1973 · N72737 · Substantial damage NTSB NYC73FGT14Accident · No injuriesClosedCessna 140 · Thomasville, PAJun 19, 1973 · N89171 · Substantial damage NTSB CHI73FEG28Accident · Serious injuriesClosedCessna 140 · Union, OHJun 10, 1973 · N76126 · Destroyed NTSB CHI73DEK27Accident · No injuriesClosedCessna 140 · Spring Mtn, OHJun 9, 1973 · N89205 · Substantial damage NTSB CHI73DEM69Accident · Minor injuriesClosedCessna 140 · Sanford, MIMay 30, 1973 · N76013 · Substantial damage NTSB SEA73FYC30Accident · Serious injuriesClosedCessna 140 · Sisters, ORMay 28, 1973 · N2051N · Destroyed NTSB MKC73FCA27Accident · Minor injuriesClosedCessna 140 · Valley Park, MOMay 24, 1973 · N2835N · Destroyed NTSB MIA73DKG80Accident · No injuriesClosedCessna 140 · Marietta, GAMay 23, 1973 · N89180 · Substantial damage NTSB MKC73FER58Accident · Minor injuriesClosedCessna 140 · Grand Rapids, MNMay 14, 1973 · N2917N · Substantial damage NTSB MKC73FER57Accident · No injuriesClosedCessna 140 · Anoka, MNMay 9, 1973 · N77095 · Substantial damage NTSB MKC73FTG11Accident · Serious injuriesClosedCessna 140 · Hillsboro, NDApr 22, 1973 · N1971N · Destroyed NTSB FTW73FPJ13Accident · No injuriesClosedCessna 140 · Goldsby, OKMar 28, 1973 · N3548V · Substantial damage NTSB ANC73DAA20Accident · No injuriesClosedCessna 140 · Rampart, AKMar 18, 1973 · N2934N · Substantial damage NTSB LAX73FUQ22Accident · Minor injuriesClosedCessna 140 · Van Nuys, CAMar 4, 1973 · N234YD · Substantial damage NTSB NYC73FNC50Accident · No injuriesClosedCessna 140 · Manchester, NHJan 24, 1973 · N1995N · Substantial damage NTSB CHI73DEM42Accident · Minor injuriesClosedCessna 140 · Levering, MIJan 20, 1973 · N76836 · Substantial damage NTSB CHI73FEC21Accident · Serious injuriesClosedCessna 140 · Plymouth, MIJan 7, 1973 · N2177V · Destroyed NTSB MIA73DLG30Accident · No injuriesClosedCessna 140 · N Myrtle Beach, SCDec 27, 1972 · N72137 · Substantial damage NTSB LAX73DUM10Accident · No injuriesClosedCessna 140 · Borrego Sgs, CANov 25, 1972 · N3113N · Substantial damage NTSB OAK73DVM17Accident · No injuriesClosedCessna 140 · Lahonda, CANov 9, 1972 · N725X · Substantial damage NTSB CHI73AC042Accident · 1 fatalClosedCessna 140 · Gilmore, OHOct 18, 1972 · N89593 · Destroyed NTSB NYC73FFJ11Accident · No injuriesClosedCessna 140 · Etna, NYOct 11, 1972 · N89814 · Substantial damage NTSB OAK73DVM14Accident · No injuriesClosedCessna 140 · Palo Alto, CAOct 7, 1972 · N3092N · Substantial damage NTSB LAX72FUG18Accident · Serious injuriesClosedCessna 140 · Adelanto, CASep 29, 1972 · N72525 · Substantial damage NTSB FTW73FPA14Accident · No injuriesClosedCessna 140 · Terrell, TXSep 26, 1972 · N77153 · Substantial damage

Back to Cessna 140