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 NYC73DIJ06Accident · No injuriesClosedCessna 140 · Buckhannon, WVSep 18, 1972 · N76919 · Substantial damage NTSB NYC73ANO61Accident · 1 fatalClosedCessna 140 · Gaffney, SCSep 17, 1972 · N2218N · Destroyed NTSB MKC73DCQ15Accident · No injuriesClosedCessna 140 · Abilene, KSSep 17, 1972 · N89378 · Substantial damage NTSB NYC73FFA17Accident · Minor injuriesClosedCessna 140 · Postenkill, NYSep 16, 1972 · N2897N · Substantial damage NTSB NYC73FFA13Accident · Serious injuriesClosedCessna 140 · Knox, NYSep 10, 1972 · N3054N · Substantial damage NTSB NYC73FHA05Accident · No injuriesClosedCessna 140 · Montgmeryville, PASep 3, 1972 · N2192V · Substantial damage NTSB MIA73FLD11Accident · No injuriesClosedCessna 140 · Tampa, FLAug 20, 1972 · N2652N · Substantial damage NTSB NYC73FGM05Accident · Minor injuriesClosedCessna 140 · Slippery Rock, PAAug 19, 1972 · N72765 · Destroyed NTSB LAX73DUG12Accident · No injuriesClosedCessna 140 · Hemet, CAAug 19, 1972 · N4164N · Substantial damage NTSB FTW73FRA07Accident · No injuriesClosedCessna 140 · Houston, TXAug 6, 1972 · N1778V · Substantial damage NTSB ANC73DAG13Accident · No injuriesClosedCessna 140 · Willow, AKJul 30, 1972 · N2204N · Substantial damage NTSB NYC73FNE04Accident · No injuriesClosedCessna 140 · Waterford, CTJul 27, 1972 · N3572V · Substantial damage NTSB MKC73DCD06Accident · No injuriesClosedCessna 140 · Toledo, IAJul 23, 1972 · N1859V · Substantial damage NTSB CHI73FLQ07Accident · No injuriesClosedCessna 140 · Monticello, KYJul 21, 1972 · N2466V · Substantial damage NTSB MIA73DKG13Accident · No injuriesClosedCessna 140 · Claxton, GAJul 14, 1972 · N2220N · Substantial damage NTSB OAK72DVD04Accident · No injuriesClosedCessna 140 · Livermore, ALJul 12, 1972 · N2046N · Substantial damage NTSB FTW73FPA04Accident · No injuriesClosedCessna 140 · Baylor, TXJul 11, 1972 · N89691 · Substantial damage NTSB MKC73FCJ02Accident · Minor injuriesClosedCessna 140 · North Platte, NEJul 6, 1972 · N89183 · Substantial damage NTSB DEN72DQA01Accident · No injuriesClosedCessna 120 · Raton, NMJul 5, 1972 · N77476 · Substantial damage NTSB CHI73FEE01Accident · No injuriesClosedCessna 140 · Harvard, ILJul 4, 1972 · N89325 · Substantial damage NTSB FTW72DPJ45Accident · No injuriesClosedCessna 140 · Woodward, OKJun 25, 1972 · N76568 · Substantial damage NTSB MIA72DLD75Accident · No injuriesClosedCessna 140 · N.Smyrna Bch, FLJun 20, 1972 · N76162 · Substantial damage NTSB OAK72DVD56Accident · No injuriesClosedCessna 140 · Livermore, CAJun 19, 1972 · N90112 · Substantial damage NTSB MKC73DER05Accident · No injuriesClosedCessna 140 · Princeton, MNJun 8, 1972 · N3577V · Substantial damage NTSB SEA72DYG46Accident · No injuriesClosedCessna 140 · Wapato, WAJun 5, 1972 · N2215N · Substantial damage NTSB LAX72FUG77Accident · No injuriesClosedCessna 140 · Upland, CAJun 5, 1972 · N89512 · Substantial damage NTSB MKC72DCG69Accident · No injuriesClosedCessna 140 · Topeka, KSMay 31, 1972 · N1878V · Substantial damage NTSB NYC72DNC51Accident · Serious injuriesClosedCessna 140 · Rochester, NHMay 27, 1972 · N1980N · Destroyed NTSB MIA72OKA16Accident · No injuriesClosedCessna 140 · Trinidad, WNMay 27, 1972 · N1850V · Substantial damage NTSB CHI72DEA44Accident · No injuriesClosedCessna 140 · W.Lafayette, INMay 24, 1972 · N77130 · Substantial damage NTSB MKC72FER60Accident · Minor injuriesClosedCessna 140 · Albert Lea, MNMay 19, 1972 · N2085N · Substantial damage NTSB FTW72DPJ39Accident · No injuriesClosedCessna 140 · Yukon, OKMay 2, 1972 · N2875N · Substantial damage NTSB SEA72DYI20Accident · Minor injuriesClosedCessna 140 · Bend, ORApr 29, 1972 · N73079 · Substantial damage NTSB MIA72FLA39Accident · Serious injuriesClosedCessna 140 · Milton, FLApr 10, 1972 · N72699 · Substantial damage NTSB NYC72FLJ27Accident · Minor injuriesClosedCessna 140 · Southern Pines, NCApr 1, 1972 · N76476 · Substantial damage NTSB MIA72DLG32Accident · Minor injuriesClosedCessna 140 · Laurens, SCMar 25, 1972 · N81081 · Substantial damage NTSB CHI72FEE60Accident · No injuriesClosedCessna 140 · Wheeling, ILMar 10, 1972 · N3552V · Substantial damage NTSB LAX72DVA51Accident · No injuriesClosedCessna 140 · Bakersfield, CAFeb 27, 1972 · N1718V · Substantial damage NTSB SEA72DTA12Accident · No injuriesClosedCessna 140 · Glendive, MTFeb 20, 1972 · N2040N · Substantial damage NTSB MKC72DCJ48Accident · No injuriesClosedCessna 140 · Lincoln, NEFeb 17, 1972 · N76809 · Substantial damage NTSB SEA72FTA11Accident · No injuriesClosedCessna 140 · Hardin, MTFeb 15, 1972 · N72261 · Substantial damage NTSB SEA72DYG28Accident · No injuriesClosedCessna 140 · Ephrata, WAFeb 4, 1972 · N2803N · Substantial damage NTSB MIA72DLD45Accident · No injuriesClosedCessna 140 · Ocoee, FLJan 29, 1972 · N89454 · Substantial damage NTSB FTW72AF047Accident · 2 fatalClosedCessna 140 · Freeport, TXJan 23, 1972 · N75J · Destroyed NTSB LAX72DUJ65Accident · No injuriesClosedCessna 140 · Phoenix, AZJan 21, 1972 · N2328N · Substantial damage NTSB SEA72DYG25Accident · No injuriesClosedCessna 140 · Lewiston, IDJan 15, 1972 · N89336 · Destroyed NTSB FTW72DPJ28Accident · No injuriesClosedCessna 140 · Boise City, OKJan 7, 1972 · N2397V · Substantial damage NTSB MIA72FKW12Accident · Serious injuriesClosedCessna 140 · Knoxville, TNDec 31, 1971 · N76180 · Destroyed NTSB LAX72DUQ53Accident · No injuriesClosedCessna 140 · Van Nuys, CADec 26, 1971 · N3585V · Substantial damage NTSB NYC72DIG15Accident · No injuriesClosedCessna 140 · Ocean City, MDDec 4, 1971 · N72619 · Substantial damage

Back to Cessna 140