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 CHI68D0313Accident · No injuriesClosedCessna 140 · Dekalb, ILSep 16, 1967 · N2905N · Substantial damage NTSB MKC68D0223Accident · Minor injuriesClosedCessna 140 · Clay Center, KSSep 13, 1967 · N89378 · Substantial damage NTSB FTW68F0234Accident · Serious injuriesClosedCessna 140A · Dayton, TXSep 9, 1967 · N4210N · Substantial damage NTSB CHI68D0348Accident · No injuriesClosedCessna 140 · Brownsburg, INSep 3, 1967 · N2848N · Substantial damage NTSB DIA68F0075Accident · No injuriesClosedCessna 140 · Wilmington, DEAug 29, 1967 · N89842 · Substantial damage NTSB MKC68D0214Accident · Minor injuriesClosedCessna 140 · Independence, MOAug 24, 1967 · N76939 · Substantial damage NTSB FTW68D0208Accident · No injuriesClosedCessna 140 · Tyler, TXAug 22, 1967 · N89245 · Substantial damage NTSB LAX68D0110Accident · No injuriesClosedCessna 140 · Hawthorne, CAAug 21, 1967 · N2299N · Substantial damage NTSB MKC68F0175Accident · Serious injuriesClosedCessna 140 · Two Harbors, MNAug 20, 1967 · N1824V · Substantial damage NTSB FTW68D0186Accident · No injuriesClosedCessna 140 · Menard, TXAug 17, 1967 · N2020V · Substantial damage NTSB MIA68F0136Accident · No injuriesClosedCessna 140 · Dawson, GAAug 14, 1967 · N76110 · Substantial damage NTSB CHI68F0233Accident · Minor injuriesClosedCessna 140 · Bunker Hill, ILAug 13, 1967 · N89480 · Substantial damage NTSB CHI68F0187Accident · No injuriesClosedCessna 140 · Columbus, OHAug 12, 1967 · N4116N · Substantial damage NTSB DIA68F0059Accident · Minor injuriesClosedCessna 140 · Davidsonville, MDAug 11, 1967 · N76539 · Substantial damage NTSB SEA68D0180Accident · No injuriesClosedCessna 140A · Worden, MTAug 10, 1967 · N3785V · Substantial damage NTSB LAX68D0106Accident · No injuriesClosedCessna 140 · Hesperia, CAAug 10, 1967 · N2276N · Substantial damage NTSB MIA68F0117Accident · No injuriesClosedCessna 140 · State Coll., MSAug 3, 1967 · N76151 · Substantial damage NTSB ANC68F0029Accident · No injuriesClosedCessna 140 · Fairbanks, AKJul 31, 1967 · N2210N · Substantial damage NTSB NYC68D0101Accident · No injuriesClosedCessna 140 · Hopewell Jctn, NYJul 29, 1967 · N72319 · Substantial damage NTSB DIA68A0004Accident · Serious injuriesClosedCessna 140 · Baileys Crsrds, VAJul 27, 1967 · N76124 · Substantial damage NTSB LAX68F0080Accident · No injuriesClosedCessna 140 · Tucson, AZJul 24, 1967 · N1634V · Substantial damage NTSB CHI68F0152Accident · No injuriesClosedCessna 140 · Bartonville, ILJul 20, 1967 · N89912 · Substantial damage NTSB LAX68A0007Accident · 3 fatalClosedCessna 140 · Florence, AZJul 16, 1967 · N89482 · Destroyed NTSB MKC68D0123Accident · No injuriesClosedCessna 140 · Springfield, MOJul 15, 1967 · N72938 · Substantial damage NTSB FTW68D0093Accident · No injuriesClosedCessna 140 · Carrier, OKJul 13, 1967 · N72510 · Substantial damage NTSB MIA68D0090Accident · No injuriesClosedCessna 140 · Dunedin, FLJul 12, 1967 · N90175 · Substantial damage NTSB CHI68D0153Accident · No injuriesClosedCessna 140 · Lake Orion, MIJul 12, 1967 · N89252 · Substantial damage NTSB FTW68D0091Accident · No injuriesClosedCessna 140 · Blackwell, OKJul 11, 1967 · N72750 · Substantial damage NTSB MKC68D0116Accident · No injuriesClosedCessna 140 · Rutland, NDJul 10, 1967 · N81065 · Substantial damage NTSB OAK68F0074Accident · Serious injuriesClosedCessna 140 · San Carlos, CAJul 8, 1967 · N81043 · Substantial damage NTSB NYC68D0040Accident · No injuriesClosedCessna 140 · Corry, PAJul 4, 1967 · N89338 · Substantial damage NTSB FTW68D0065Accident · No injuriesClosedCessna 140 · Burleson, TXJul 3, 1967 · N2205V · Substantial damage NTSB CHI68D0075Accident · No injuriesClosedCessna 140 · Rockland, WIJun 25, 1967 · N89943 · Substantial damage NTSB CHI68F0126Accident · Minor injuriesClosedCessna 140 · Roselle, ILJun 6, 1967 · N241V · Destroyed NTSB FTW67F0645Accident · No injuriesClosedCessna 140 · Okla.City, OKJun 3, 1967 · N77053 · Substantial damage NTSB NYC68D0158Accident · No injuriesClosedCessna 140 · No-Kingstown, RIMay 30, 1967 · N72708 · Substantial damage NTSB MIA68F0005Accident · Minor injuriesClosedCessna 140 · Orlando, FLMay 30, 1967 · N2445V · Substantial damage NTSB ANC68F0014Accident · No injuriesClosedCessna 140 · Anchorage, AKMay 30, 1967 · N76309 · Substantial damage NTSB MKC67D0614Accident · No injuriesClosedCessna 140 · Bonner Sprgs, KSMay 28, 1967 · N76989 · Substantial damage NTSB MIA67D0526Accident · No injuriesClosedCessna 140 · Pisgah, ALMay 23, 1967 · N76885 · Substantial damage NTSB SEA67D0352Accident · No injuriesClosedCessna 140 · Blackfoot, IDMay 21, 1967 · N76775 · Substantial damage NTSB MIA67A0122Accident · 1 fatalClosedCessna 140 · Miami, FLMay 18, 1967 · N2725N · Destroyed NTSB FTW67F0571Accident · No injuriesClosedCessna 140 · Tulsa, OKMay 8, 1967 · N4274N · Substantial damage NTSB MKC67D0610Accident · No injuriesClosedCessna 140 · Norfolk, NEMay 6, 1967 · N2267V · Substantial damage NTSB ANC67D0100Accident · No injuriesClosedCessna 140 · Mcgrath, AKMay 2, 1967 · N76136 · Substantial damage NTSB OAK67D0329Accident · Serious injuriesClosedCessna 140 · Vacaville, CAApr 29, 1967 · N74U · Substantial damage NTSB NYC67D0651Accident · No injuriesClosedCessna 140 · Poughkeepsie, NYApr 29, 1967 · N76833 · Substantial damage NTSB LAX67F0412Accident · Minor injuriesClosedCessna 140 · Tucson, AZApr 29, 1967 · N89923 · Substantial damage NTSB LAX67D0395Accident · No injuriesClosedCessna 140 · Goleta, CAApr 28, 1967 · N1855V · Substantial damage NTSB OAK67F0289Accident · Minor injuriesClosedCessna 140 · Las Vegas, NVApr 27, 1967 · N76409 · Substantial damage

Back to Cessna 140