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 MIA79FKG05Accident · No injuriesClosedCessna 140 · Sugar Valley, GAOct 12, 1978 · N2511N · Substantial damage NTSB LAX79FUJ03Accident · No injuriesClosedCessna 140 · Mesa, AZOct 7, 1978 · N72930 · Substantial damage NTSB MKC78DTK36Accident · Minor injuriesClosedCessna 140 · Webster, SDSep 3, 1978 · N76114 · Substantial damage NTSB OAK78DVA76Accident · No injuriesClosedCessna 140 · Columbia, CAAug 20, 1978 · N76170 · Substantial damage NTSB LAX78DUJ91Accident · No injuriesClosedCessna 140 · Mesa, AZAug 13, 1978 · N89262 · Substantial damage NTSB CHI78FET34Accident · No injuriesClosedCessna 140 · Hamlet, INAug 3, 1978 · N3717V · Substantial damage NTSB DEN78DTC32Accident · No injuriesClosedCessna 140 · Evanston, WYJul 23, 1978 · N76495 · Substantial damage NTSB NYC78FNE25Accident · Serious injuriesClosedCessna 140 · Oxford, MAJul 8, 1978 · N90136 · Substantial damage NTSB OAK78DVG54Accident · Minor injuriesClosedCessna 140 · Winters, CAJun 24, 1978 · N1608V · Substantial damage NTSB MIA78DLD56Accident · No injuriesClosedCessna 140 · Silver Springs, FLJun 24, 1978 · N89454 · Substantial damage NTSB MKC78FA043Accident · 2 fatalClosedCessna 140 · Wolbach, NEMay 31, 1978 · N76011 · Destroyed NTSB FTW78DRA23Accident · Serious injuriesClosedCessna 140 · Manvel, TXMay 27, 1978 · N73073 · Substantial damage NTSB CHI78FET20Accident · Minor injuriesClosedCessna 140 · Michigan City, INMay 1, 1978 · N89458 · Substantial damage NTSB CHI78DEV26Accident · Minor injuriesClosedCessna 140 · Trivoli, ILApr 9, 1978 · N4158N · Substantial damage NTSB MKC78DER37Accident · No injuriesClosedCessna 140 · Windom, MNMar 31, 1978 · N3587V · Substantial damage NTSB SEA78DYP20Accident · No injuriesClosedCessna 140 · La Crosse, WAMar 29, 1978 · N89636 · Substantial damage NTSB LAX78FA038Accident · 1 fatalClosedCessna 140 · Buckeye, AZMar 27, 1978 · N90119 · Destroyed NTSB CHI78FEM11Accident · No injuriesClosedCessna 140 · Atwood, MIMar 1, 1978 · N2102N · Substantial damage NTSB MKC78DCD15Accident · No injuriesClosedCessna 140 · Shenandoah, IAJan 28, 1978 · N72750 · Substantial damage NTSB LAX78FUQ09Accident · No injuriesClosedCessna 140 · Santa Barbara, CAJan 7, 1978 · N77417 · Substantial damage NTSB NYC78DNC07Accident · No injuriesClosedCessna 140 · Jaffey, NHDec 24, 1977 · N90019 · Substantial damage NTSB CHI78FEC05Accident · No injuriesClosedCessna 140 · W.Bloomfield, MINov 3, 1977 · N2229N · Substantial damage NTSB LAX78FUJ06Accident · No injuriesClosedCessna 140 · Tonopah, AZOct 22, 1977 · N90075 · Substantial damage NTSB MIA78FKG03Accident · Serious injuriesClosedCessna 140 · Calhoun, GAOct 21, 1977 · N2222V · Substantial damage NTSB MKC78FCD06Accident · No injuriesClosedCessna 140 · Ankeny, IAOct 19, 1977 · N2419V · Substantial damage NTSB MIA78DKG02Accident · No injuriesClosedCessna 140 · Tifton, GAOct 9, 1977 · N76817 · Destroyed NTSB CHI77BEX52Accident · No injuriesClosedCessna 140 · Anderson, INSep 25, 1977 · N76168 · Substantial damage NTSB MIA77DKG80Accident · No injuriesClosedCessna 140 · Blairsville, GASep 12, 1977 · N2458N · Substantial damage NTSB DEN77DTC29Accident · Minor injuriesClosedCessna 140 · Cody, WYSep 12, 1977 · N89879 · Substantial damage NTSB ANC77DAH34Accident · Serious injuriesClosedCessna 140 · Kenai, AKAug 18, 1977 · N81047 · Substantial damage NTSB DEN77DTE72Accident · No injuriesClosedCessna 140 · Platner, COAug 16, 1977 · N2259N · Substantial damage NTSB MKC77DCJ39Accident · No injuriesClosedCessna 140 · Kimball, NEAug 14, 1977 · N72720 · Substantial damage NTSB SEA77DYM50Accident · No injuriesClosedCessna 140 · Rufus, ORJul 28, 1977 · N89388 · Destroyed NTSB MIA77FKG20Accident · Minor injuriesClosedCessna 140 · Whitesburg, GAJul 24, 1977 · N3119N · Substantial damage NTSB MIA77FLG23Accident · Serious injuriesClosedCessna 140 · Isle Of Palms, SCJul 17, 1977 · N2418N · Destroyed NTSB MKC77DER54Accident · Minor injuriesClosedCessna 140 · Monticello, MNJul 1, 1977 · N1867V · Substantial damage NTSB IAD77DID22Accident · No injuriesClosedCessna 140 · Leedsville, VAJun 24, 1977 · N72595 · Substantial damage NTSB SEA77FTA24Accident · No injuriesClosedCessna 140 · Jordan, MTJun 23, 1977 · N2040N · Substantial damage NTSB SEA77FTI14Accident · Minor injuriesClosedCessna 140 · Stevensville, MTJun 1, 1977 · N76330 · Destroyed NTSB NYC77FHJ20Accident · No injuriesClosedCessna 140 · Farmingdale, NYMay 20, 1977 · N72112 · Substantial damage NTSB NYC77FFA23Accident · No injuriesClosedCessna 140 · Potsdam, NYMay 11, 1977 · N89759 · Substantial damage NTSB MIA77FLT03Accident · Minor injuriesClosedCessna 140 · Walls, MSMay 6, 1977 · N2301V · Destroyed NTSB FTW77DPG29Accident · No injuriesClosedCessna 140 · Marion, ARApr 28, 1977 · N76713 · Substantial damage NTSB SEA77FYM29Accident · Minor injuriesClosedCessna 140 · Vancouver, WAApr 21, 1977 · N89672 · Substantial damage NTSB NYC77DFA19Accident · No injuriesClosedCessna 140 · Monticello, NYApr 9, 1977 · N2752N · Substantial damage NTSB MKC77DCQ28Accident · No injuriesClosedCessna 140 · Kirwin, KSApr 7, 1977 · N89560 · Substantial damage NTSB LAX77FVA07Accident · Minor injuriesClosedCessna 140 · Long Beach, CAMar 22, 1977 · N2292N · Substantial damage NTSB MKC77DTK09Accident · No injuriesClosedCessna 140 · Philip, SDMar 6, 1977 · N1962N · Substantial damage NTSB CHI77FEX14Accident · No injuriesClosedCessna 140 · Crawfordsville, INFeb 18, 1977 · N89420 · Substantial damage NTSB SEA77FTA12Accident · No injuriesClosedCessna 140 · Hinsdale, MTFeb 14, 1977 · N2628N · Substantial damage

Back to Cessna 140