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 NYC66F0513Accident · Minor injuriesClosedCessna 140 · Bellefonte, PAFeb 12, 1966 · N72921 · Substantial damage NTSB CHI66D0612Accident · No injuriesClosedCessna 140 · Flora, INFeb 5, 1966 · N89361 · Substantial damage NTSB CHI66D0537Accident · No injuriesClosedCessna 140 · Petersburg, MIFeb 5, 1966 · N2473V · Substantial damage NTSB CHI66F0580Accident · No injuriesClosedCessna 140 · Sycamore, ILFeb 4, 1966 · N81093 · Substantial damage NTSB MKC66F0464Accident · No injuriesClosedCessna 140 · Indeoendence, MOJan 23, 1966 · N2296V · Substantial damage NTSB FTW66D0496Accident · No injuriesClosedCessna 140 · Arlington, TXJan 23, 1966 · N90110 · Substantial damage NTSB MKC66F0342Accident · No injuriesClosedCessna 140 · Monticello, MNDec 27, 1965 · N3587V · Substantial damage NTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MADec 19, 1965 · N3083N · Substantial damage NTSB LAX66D0199Accident · No injuriesClosedCessna 140 · San Diego, CADec 19, 1965 · N76403 · Substantial damage NTSB SEA66D0169Accident · No injuriesClosedCessna 140 · Wenatchee, WADec 5, 1965 · N89528 · Substantial damage NTSB SEA66D0186Accident · No injuriesClosedCessna 140 · Beaverton, ORDec 4, 1965 · N3701V · Substantial damage NTSB LAX66D0158Accident · No injuriesClosedCessna 140 · Hawthorne, CANov 24, 1965 · N77268 · Substantial damage NTSB SEA66D0162Accident · No injuriesClosedCessna 140A · Seattle, WANov 13, 1965 · N358TA · Substantial damage NTSB CHI66D0403Accident · No injuriesClosedCessna 140 · Cleveland, OHNov 7, 1965 · N1998V · Substantial damage NTSB CHI66F0408Accident · No injuriesClosedCessna 140 · Houghton, MIOct 29, 1965 · N72856 · Substantial damage NTSB SEA66A0027Accident · 1 fatalClosedCessna 140 · Ryegate, MTOct 28, 1965 · N77103 · Destroyed NTSB MIA66F0280Accident · Minor injuriesClosedCessna 140 · Shelby, NCOct 27, 1965 · N76477 · Substantial damage NTSB CHI66A0042Accident · 2 fatalClosedCessna 140 · Ralph, MIOct 24, 1965 · N72146 · Destroyed NTSB ANC66A0019Accident · 1 fatalClosedCessna 140 · Napakiah, AKOct 24, 1965 · N2853N · Destroyed NTSB DEN66D0158Accident · No injuriesClosedCessna 140 · Yuma, AZOct 23, 1965 · N2321V · Substantial damage NTSB FTW66D0369Accident · No injuriesClosedCessna 140 · Merkel, TXOct 21, 1965 · N2851N · Substantial damage NTSB NYC66F0306Accident · No injuriesClosedCessna 140 · Gaithersburg, MDOct 10, 1965 · N2318N · Substantial damage NTSB MIA66F0258Accident · No injuriesClosedCessna 140 · Fayetteville, TNOct 10, 1965 · N72849 · Substantial damage NTSB MKC66D0281Accident · Minor injuriesClosedCessna 140 · Holton, KSOct 9, 1965 · N76939 · Substantial damage NTSB MIA66A0038Accident · 1 fatalClosedCessba 140 · Trenton, ALOct 1, 1965 · N77409 · Destroyed NTSB LAX66D0133Accident · No injuriesClosedCessna 140 · Burbank, CAOct 1, 1965 · N76258 · Substantial damage NTSB SEA66D0139Accident · No injuriesClosedCessna 140 · Everett, WASep 24, 1965 · N89983 · Substantial damage NTSB MKC66F0255Accident · No injuriesClosedCessna 140 · Michigan, NDSep 19, 1965 · N89525 · Substantial damage NTSB MKC66D0266Accident · No injuriesClosedCessna 140 · Melrose, MNSep 19, 1965 · N76280 · Substantial damage NTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSSep 11, 1965 · N3604V · Substantial damage NTSB FTW66D0308Accident · Minor injuriesClosedCessna 140 · Bartonville, TXSep 6, 1965 · N2221N · Substantial damage NTSB MIA66F0218Accident · No injuriesClosedCessna 140 · Meridian, MSSep 4, 1965 · N2020V · Substantial damage NTSB FTW66F0307Accident · Minor injuriesClosedCessna 140 · Tulsa, OKSep 4, 1965 · N76029 · Substantial damage NTSB DEN66F0094Accident · No injuriesClosedCessna 140 · Aurora, COAug 29, 1965 · N77045 · Substantial damage NTSB NYC66F0249Accident · Minor injuriesClosedCessna 140 · Victoria, VAAug 28, 1965 · N89491 · Substantial damage NTSB OAK66D0059Accident · No injuriesClosedCessna 140 · Modesto, CAAug 26, 1965 · N72507 · Substantial damage NTSB MKC66F0218Accident · No injuriesClosedCessna 140 · Grand Forks, NDAug 21, 1965 · N2302N · Substantial damage NTSB CHI66F0209Accident · No injuriesClosedCessna 140 · Trivoli, ILAug 17, 1965 · N4158N · Substantial damage NTSB NYC66F0230Accident · No injuriesClosedCessna 140 · Keating, PAAug 16, 1965 · N76066 · Substantial damage NTSB CHI66F0202Accident · No injuriesClosedCessna 140 · Mooresville, INAug 14, 1965 · N3627V · Substantial damage NTSB FTW66F0193Accident · Minor injuriesClosedCessna 140 · Orange, TXAug 8, 1965 · N2196V · Destroyed NTSB CHI66D0136Accident · Minor injuriesClosedCessna 140 · Plymouth, MIAug 5, 1965 · N72873 · Destroyed NTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARAug 3, 1965 · N89234 · Substantial damage NTSB UNK65X1522Accident · No injuriesClosedCessna 140 · Alpine, TXAug 2, 1965 · N72499 · Substantial damage NTSB MKC66F0117Accident · No injuriesClosedCessna 140 · Omaha, NEAug 1, 1965 · N4279N · Substantial damage NTSB MKC66F0201Accident · No injuriesClosedCessna 140 · Robbinsdale, MNJul 29, 1965 · N77095 · Substantial damage NTSB OAK66F0082Accident · Minor injuriesClosedCessna 140 · Dunsmuir, CAJul 24, 1965 · N76963 · Substantial damage NTSB MIA66F0112Accident · Minor injuriesClosedCessna 140 · Williston, FLJul 19, 1965 · N72663 · Substantial damage NTSB FTW66D0149Accident · Minor injuriesClosedCessna 140 · Cashion, OKJul 15, 1965 · N72688 · Substantial damage NTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WIJul 10, 1965 · N89657 · Substantial damage

Back to Cessna 140