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 SEA81DYK15Accident · Minor injuriesClosedCessna 140 · Ashland, ORAug 24, 1981 · N2626N · Destroyed NTSB FTW81DPA16Accident · No injuriesClosedCessna 140 · Waco, TXAug 14, 1981 · N89691 · Substantial damage NTSB FTW81FQA37Accident · No injuriesClosedCessna 140 · Albuquerque, NMJul 22, 1981 · N76082 · Substantial damage NTSB LAX81FVD33Accident · No injuriesClosedCessna 140 · San Rafael, CAJul 19, 1981 · N110V · Substantial damage NTSB ATL81DKG34Accident · Minor injuriesClosedCessna 140 · Dahlonega, GAJul 17, 1981 · N72966 · Destroyed NTSB LAX81FUJ75Accident · No injuriesClosedCessna 140 · Glendale, AZJun 28, 1981 · N3530V · Substantial damage NTSB FTW81DRG38Accident · No injuriesClosedCessna 140 · Freer, TXMay 17, 1981 · N89062 · Substantial damage NTSB SEA81DYM23Accident · No injuriesClosedCessna 140 · Pendleton, ORApr 30, 1981 · N2143V · Substantial damage NTSB MIA81DLA22Accident · Serious injuriesClosedCessna 140 · Quiney, FLApr 30, 1981 · N72586 · Substantial damage NTSB FTW81DA060Accident · No injuriesClosedCessna 140 · Kilgore, TXMar 29, 1981 · N72699 · 2 aircraft · Substantial damage NTSB NYC81FNC09Accident · No injuriesClosedCessna 140 · Enfield, NHMar 15, 1981 · N72UL · Substantial damage NTSB DEN81FTC11Accident · Minor injuriesClosedCessna 140 · Wapiti, WYMar 14, 1981 · N72917 · Substantial damage NTSB FTW81FQG19Accident · No injuriesClosedCessna 140 · Ozona, TXMar 7, 1981 · N77079 · Substantial damage NTSB FTW81FQG10Accident · No injuriesClosedCessna 140 · Canyon, TXJan 30, 1981 · N71U · Substantial damage NTSB NYC81FKG02Accident · Minor injuriesClosedCessna 140 · Stockbridge, GANov 15, 1980 · N76151 · Substantial damage NTSB CHI81FEK02Accident · No injuriesClosedCessna 140 · Sunbury, OHOct 20, 1980 · N76731 · Substantial damage NTSB SEA81DYM08Accident · No injuriesClosedCessna 140 · Vancouver, WAOct 6, 1980 · N72778 · Substantial damage NTSB SEA80FYK11Accident · No injuriesClosedCessna 140 · Creswell, ORAug 3, 1980 · N3691V · Substantial damage NTSB MKC80DCQ27Accident · No injuriesClosedCessna 140 · El Dorado, KSAug 3, 1980 · N76448 · Substantial damage NTSB CHI80DEX22Accident · Minor injuriesClosedCessna 140A · E Enterprise, INJul 7, 1980 · N3547V · Substantial damage NTSB LAX80DUG43Accident · No injuriesClosedCessna 140 · Aguanga, CAJun 24, 1980 · N76258 · Substantial damage NTSB DEN80DTI11Accident · No injuriesClosedCessna 140 · Lost Prairie, MTJun 8, 1980 · N76657 · Substantial damage NTSB ATL80FLA01Accident · No injuriesClosedCessna 140 · St Marys, GAMay 6, 1980 · N76366 · Substantial damage NTSB NYC80FHA09Accident · Minor injuriesClosedCessna 140 · Slatington, PAMay 4, 1980 · N72581 · Substantial damage NTSB IAD80DID16Accident · No injuriesClosedCessna 140 · Chesapeake, VAApr 19, 1980 · N1885V · Substantial damage NTSB MIA80FKQ04Accident · No injuriesClosedCessna 140 · Drew, MSMar 23, 1980 · N76653 · Substantial damage NTSB MIA80DKJ25Accident · No injuriesClosedCessna 140 · Ft.Walton Bch, FLMar 4, 1980 · N89831 · Substantial damage NTSB MIA80FA038Accident · 2 fatalClosedCessna 140 · Homestead, FLFeb 25, 1980 · N76663 · Destroyed NTSB NYC80FGM09Accident · No injuriesClosedCessna 140 · Butler, PADec 15, 1979 · N90035 · Substantial damage NTSB CHI80DEC05Accident · No injuriesClosedCessna 140 · Romeo, MIDec 3, 1979 · N1788N · Substantial damage NTSB SEA80FTA04Accident · No injuriesClosedCessna 140 · Malta, MTDec 1, 1979 · N2197N · Substantial damage NTSB MKC79FER73Accident · No injuriesClosedCessna 140 · Thief Riv Fls, MNSep 24, 1979 · N3073N · Substantial damage NTSB IAD79FA087Accident · No injuriesClosedCessna 140 · Luray, VASep 20, 1979 · N89327 · Substantial damage NTSB FTW79FPD37Accident · No injuriesClosedCessna 140 · Wichita Falls, TXAug 22, 1979 · N89445 · Substantial damage NTSB FTW79DA093Accident · 1 fatalClosedCessna 140 · Basile, LAJul 6, 1979 · N1607V · Destroyed NTSB CHI79FA054Accident · 2 fatalClosedCessna 140 · Springbrook, WIJul 1, 1979 · N1972J · Destroyed NTSB ANC79DAA17Accident · Serious injuriesClosedCessna 140 · Tok, AKJun 18, 1979 · N2163V · Destroyed NTSB NYC79FNC30Accident · Minor injuriesClosedCessna 140 · Burlington, VTJun 14, 1979 · N2570N · Substantial damage NTSB SEA79FTI17Accident · No injuriesClosedCessna 140 · Brady, MTJun 8, 1979 · N77318 · Substantial damage NTSB SEA79DYE25Accident · No injuriesClosedCessna 140 · Port Angeles, WAJun 3, 1979 · N2356V · Substantial damage NTSB MKC79DTG07Accident · No injuriesClosedCessna 140 · Bowman, NDMay 26, 1979 · N1677V · Substantial damage NTSB LAX79DUJ79Accident · No injuriesClosedCessna 140 · Poston, AZMay 13, 1979 · N72963 · Substantial damage NTSB MKC79FTK11Accident · No injuriesClosedCessna 140 · Redowl, SDApr 22, 1979 · N77191 · Substantial damage NTSB MKC79DCD11Accident · No injuriesClosedCessna 140 · Lamotte, IAFeb 11, 1979 · N89902 · Substantial damage NTSB SEA79DYE13Accident · No injuriesClosedCessna 140 · Mt.Rainier, WAJan 29, 1979 · N4108N · Substantial damage NTSB OAK79DVA16Accident · No injuriesClosedCessna 140 · Tulare, CAJan 26, 1979 · N89057 · Substantial damage NTSB MIA79DKJ13Accident · No injuriesClosedCessna 140 · Careyville, FLNov 22, 1978 · N72244 · Substantial damage NTSB IAD79DLQ06Accident · No injuriesClosedCessna 140 · Shelbyville, KYNov 22, 1978 · N90143 · Substantial damage NTSB CHI79FEE09Accident · Minor injuriesClosedCessna 140 · Waukegan, ILNov 11, 1978 · N701F · Substantial damage NTSB MIA79FLD08Accident · Minor injuriesClosedCessna 140 · Groveland, FLOct 22, 1978 · N4042N · Substantial damage

Back to Cessna 140