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 LAX77FUG28Accident · No injuriesClosedCessna 140 · Redlands, CAJan 30, 1977 · N2430N · Substantial damage NTSB LAX77FA023Accident · 1 fatalClosedCessna 140 · Riverside, CAJan 12, 1977 · N2155V · 2 aircraft · Destroyed NTSB CHI77DEP05Accident · Minor injuriesClosedCessna 140 · Brookfield, WINov 20, 1976 · N2168V · Substantial damage NTSB CHI77FEV02Accident · No injuriesClosedCessna 140 · Peoria, ILOct 17, 1976 · N72498 · Substantial damage NTSB MKC76FCA46Accident · No injuriesClosedCessna 140 · Vandalia, MOSep 25, 1976 · N72343 · Substantial damage NTSB MKC76DCG96Accident · No injuriesClosedCessna 140 · Salisbury, MOAug 23, 1976 · N72780 · Substantial damage NTSB MKC76FCJ45Accident · Serious injuriesClosedCessna 140 · Elgin, NEJul 26, 1976 · N76664 · Substantial damage NTSB NYC76DNA44Accident · Minor injuriesClosedCessna 140 · Norfolk, MAJul 20, 1976 · N72708 · Substantial damage NTSB MKC76DCD57Accident · No injuriesClosedCessna 170B · Salix, IAJul 18, 1976 · N1856C · Substantial damage NTSB DEN76FTE81Accident · Serious injuriesClosedCessna 140 · Englewood, COJul 14, 1976 · N89070 · Substantial damage NTSB MKC76AK066Accident · 1 fatalClosedCessna 140 · Lake Mills, IAJul 10, 1976 · N89103 · Destroyed NTSB MKC76DCJ44Accident · No injuriesClosedCessna 140 · York, NEJun 27, 1976 · N89202 · Substantial damage NTSB DEN76FTE67Accident · No injuriesClosedCessna 140 · Byers, COJun 8, 1976 · N2335V · Substantial damage NTSB OAK76FXQ49Accident · No injuriesClosedCessna 140 · Silver Springs, NVJun 6, 1976 · N4094N · Substantial damage NTSB IAD76DKW32Accident · Minor injuriesClosedCessna 140 · Jasper, TNMay 21, 1976 · N89178 · Substantial damage NTSB LAX76FUA27Accident · Minor injuriesClosedCessna 140 · Dana Point, CAApr 27, 1976 · N2031N · Substantial damage NTSB CHI76FEA32Accident · No injuriesClosedCessna 140 · Cambridge City, INApr 27, 1976 · N4020N · Substantial damage NTSB DEN76FTE60Accident · No injuriesClosedCessna 140 · Peyton, COApr 10, 1976 · N4224N · Substantial damage NTSB DEN76FTC28Accident · Serious injuriesClosedCessna 140 · Green River, WYApr 4, 1976 · N2378V · Substantial damage NTSB MIA76FLA40Accident · No injuriesClosedCessna 140 · Pensacola, FLApr 3, 1976 · N76405 · Substantial damage NTSB IAD76FLQ16Accident · Minor injuriesClosedCessna 140 · Bardstown, KYMar 18, 1976 · N2216N · Substantial damage NTSB MIA76AM065Accident · No injuriesClosedCessna 172 · Ormond Beach, FLFeb 20, 1976 · N20846 · 2 aircraft · Substantial damage NTSB CHI76DEP21Accident · No injuriesClosedCessna 140 · Kenosha, WIJan 18, 1976 · N701F · Substantial damage NTSB DEN76DTM13Accident · No injuriesClosedCessna 140 · Price, UTJan 7, 1976 · N73083 · Substantial damage NTSB CHI76FEV24Accident · No injuriesClosedCessna 140 · Minonk, ILJan 4, 1976 · N3618V · Substantial damage NTSB OAK76DVA33Accident · No injuriesClosedCessna 140 · Shaver Lake, CADec 27, 1975 · N2703N · Destroyed NTSB SEA76DYG26Accident · No injuriesClosedCessna 140 · Quincy, WADec 22, 1975 · N89908 · Substantial damage NTSB MKC76FCD22Accident · No injuriesClosedCessna 140 · Des Moines, IADec 6, 1975 · N2465V · Substantial damage NTSB FTW76FPD21Accident · No injuriesClosedCessna 140 · Mineral Wells, TXNov 28, 1975 · N4204N · Substantial damage NTSB CHI76FET21Accident · No injuriesClosedCessna 140 · Peru, INNov 23, 1975 · N2300N · Substantial damage NTSB CHI76DEA15Accident · No injuriesClosedCessna 140 · Reynolds, INNov 15, 1975 · N4000N · Substantial damage NTSB SEA76FTA07Accident · No injuriesClosedCessna 140 · Miles City, MTNov 2, 1975 · N2611N · Destroyed NTSB MIA76FKQ22Accident · Minor injuriesClosedCessna 140 · Philip, MSOct 21, 1975 · N76515 · Destroyed NTSB MKC76DER33Accident · No injuriesClosedCessna 140 · Blaine, MNOct 6, 1975 · N89884 · Substantial damage NTSB NYC76DHA14Accident · Minor injuriesClosedCessna 140 · New Milford, PAOct 1, 1975 · N2187V · Substantial damage NTSB MKC76FCG22Accident · No injuriesClosedCessna 140 · Mission, KSSep 3, 1975 · N2185N · Substantial damage NTSB NYC76AN029Accident · No injuriesClosedCessna 140 · Fitchburg, MAAug 28, 1975 · N72854 · 2 aircraft · Substantial damage NTSB CHI76DEV10Accident · No injuriesClosedCessna 140 · Quincy, ILAug 21, 1975 · N1627V · Substantial damage NTSB FTW76DPA07Accident · No injuriesClosedCessna 140 · Desoto, TXAug 18, 1975 · N77153 · Destroyed NTSB IAD76FID05Accident · Minor injuriesClosedCessna 140 · Bassett, VAAug 17, 1975 · N2522N · Substantial damage NTSB CHI75FEC60Accident · No injuriesClosedCessna 140 · Grosse Isle, MIJun 23, 1975 · N1970V · Substantial damage NTSB CHI75FEI58Accident · No injuriesClosedCessna 140 · Youngstown, OHJun 19, 1975 · N4229N · Substantial damage NTSB NYC75FFJ25Accident · No injuriesClosedCessna 140 · Corfu, NYJun 17, 1975 · N2671N · Substantial damage NTSB MKC75DTK19Accident · No injuriesClosedCessna 140 · Wall, SDJun 4, 1975 · N2335V · Substantial damage NTSB CHI75FEC49Accident · Serious injuriesClosedCessna 140 · Tecumseh, MIMay 25, 1975 · N2459V · Destroyed NTSB CHI75DEP56Accident · No injuriesClosedCessna 140 · Reedsville, WIMay 21, 1975 · N1893V · Destroyed NTSB SEA75DTI26Accident · No injuriesClosedCessna 140 · Deer Lodge, MTApr 28, 1975 · N76295 · Substantial damage NTSB FTW75FQG49Accident · No injuriesClosedCessna 140 · Midland, TXApr 4, 1975 · N2787N · Substantial damage NTSB IAD75DKW11Accident · No injuriesClosedCessna 140 · Knoxville, TNApr 1, 1975 · N89687 · Substantial damage NTSB DEN75DQA38Accident · No injuriesClosedCessna 140 · Los Alamos, NMMar 24, 1975 · N72894 · Substantial damage

Back to Cessna 140