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 NYC72FIJ33Accident · Minor injuriesClosedCessna 140 · Summersville, WVNov 24, 1971 · N76540 · Destroyed NTSB MKC72DCD46Accident · No injuriesClosedCessna 140 · Chillicothe, IANov 7, 1971 · N1621V · Substantial damage NTSB MKC72DCD43Accident · Minor injuriesClosedCessna 140 · Mapleton, IANov 6, 1971 · N89093 · Substantial damage NTSB FTW72FPD19Accident · No injuriesClosedCessna 140 · Denton, TXOct 27, 1971 · N72623 · Substantial damage NTSB MKC72DCG25Accident · No injuriesClosedCessna 140 · Independence, MOOct 4, 1971 · N76567 · Substantial damage NTSB MKC72FCQ29Accident · No injuriesClosedCessna 140 · Mcdonald, KSSep 27, 1971 · N4283N · Substantial damage NTSB ANC72DAA15Accident · No injuriesClosedCessna 140 · Fairbanks, AKSep 18, 1971 · N77011 · Substantial damage NTSB MKC72DER23Accident · No injuriesClosedCessna 140 · Delavan, MNSep 17, 1971 · N2748N · Substantial damage NTSB CHI72FEG10Accident · No injuriesClosedCessna 140 · Greenville, OHAug 30, 1971 · N89163 · Substantial damage NTSB MIA72DLD09Accident · No injuriesClosedCessna 140 · Tampa, FLAug 25, 1971 · N89454 · Substantial damage NTSB CHI72FEC03Accident · No injuriesClosedCessna 140 · Pontiac, MIAug 21, 1971 · N76130 · Substantial damage NTSB NYC72FNE04Accident · No injuriesClosedCessna 140 · Meriden, CTAug 8, 1971 · N2913N · Substantial damage NTSB FTW72FPG19Accident · No injuriesClosedCessna 140 · N Little Rock, ARAug 6, 1971 · N2025V · Substantial damage NTSB DEN72DTE13Accident · No injuriesClosedCessna 140 · Loveland, COJul 24, 1971 · N89792 · Substantial damage NTSB MKC72FCG04Accident · No injuriesClosedCessna 140 · Lee'S Summit, MOJul 10, 1971 · N89384 · Substantial damage NTSB CHI72DEA08Accident · No injuriesClosedCessna 140 · Lebanon, INJul 6, 1971 · N77201 · Substantial damage NTSB NYC72FHA02Accident · Minor injuriesClosedCessna 140 · Line Lexington, PAJul 5, 1971 · N1903V · Substantial damage NTSB ANC72DAG07Accident · Serious injuriesClosedCessna 140 · Mckinley Prk, AKJul 5, 1971 · N2182V · Substantial damage NTSB LAX72FUG04Accident · Serious injuriesClosedCessna 140 · Parker Dam, CAJul 4, 1971 · N89423 · Destroyed NTSB LAX72DXM02Accident · No injuriesClosedCessna 140 · Paso Robles, CAJul 4, 1971 · N89201 · Substantial damage NTSB FTW71FRJ38Accident · Serious injuriesClosedCessna 140 · Alexandria, LAJun 16, 1971 · N76143 · Destroyed NTSB OAK71DVA85Accident · No injuriesClosedCessna 140 · Columbia, CAJun 15, 1971 · N3738V · Substantial damage NTSB CHI71DEE86Accident · No injuriesClosedCessna 140 · Earlville, ILJun 11, 1971 · N76644 · Substantial damage NTSB SEA71FTI33Accident · Minor injuriesClosedCessna 140 · Butte, MTMay 29, 1971 · N3079N · Substantial damage NTSB NYC71DGM49Accident · No injuriesClosedCessna 140 · Clarion, PAMay 29, 1971 · N2003N · Substantial damage NTSB DEN71FTC02Accident · Serious injuriesClosedCessna 140 · Cheyenne, WYMay 20, 1971 · N2287N · Destroyed NTSB DEN71DXA24Accident · No injuriesClosedCessna 140 · Cody, WYMay 8, 1971 · N72426 · Substantial damage NTSB LAX71AL065Accident · 2 fatalClosedCessna 140 · Phoenix, AZMay 4, 1971 · N89482 · Destroyed NTSB FTW71DQG76Accident · No injuriesClosedCessna 140 · Friona, TXMay 2, 1971 · N72919 · Substantial damage NTSB MKC71DCD78Accident · Serious injuriesClosedCessna 140 · Lamoni, IAApr 26, 1971 · N89355 · Destroyed NTSB CHI71FBJ70Accident · No injuriesClosedCessna 140 · Fulton, MIApr 22, 1971 · N77073 · Substantial damage NTSB SEA71DXM29Accident · No injuriesClosedCessna 140 · Atomic City, IDApr 12, 1971 · N90124 · Substantial damage NTSB SEA71DWA33Accident · No injuriesClosedCessna 140 · Tigard, ORApr 1, 1971 · N76294 · Substantial damage NTSB MKC71FDM52Accident · No injuriesClosedCessna 140 · Lake Elmo, MNMar 28, 1971 · N89459 · Substantial damage NTSB LAX71DUG66Accident · No injuriesClosedCessna 140 · Helendale, CAMar 14, 1971 · N89410 · Substantial damage NTSB MKC71DCJ50Accident · No injuriesClosedCessna 140 · Omaha, NEMar 8, 1971 · N89184 · Substantial damage NTSB NYC71FFD39Accident · Minor injuriesClosedCessna 140 · Mrstns Mills, MAMar 2, 1971 · N76354 · Substantial damage NTSB MIA71DKG68Accident · No injuriesClosedCessna 140 · Jonesboro, GAFeb 23, 1971 · N2869N · Substantial damage NTSB MKC71FDD20Accident · Minor injuriesClosedCessna 140 · Elbow Lake, MNFeb 18, 1971 · N76346 · Substantial damage NTSB DEN71DQA48Accident · No injuriesClosedCessna 140 · Santa Fe, NMFeb 13, 1971 · N72894 · Substantial damage NTSB NYC71DFG10Accident · No injuriesClosedCessna 140 · Pelham, NHJan 27, 1971 · N2434N · Substantial damage NTSB MKC71DCA23Accident · No injuriesClosedCessna 140 · Steffenville, MODec 31, 1970 · N89035 · Substantial damage NTSB FTW71AF034Accident · No injuriesClosedCessna 140 · Mineral Wells, TXDec 22, 1970 · N2499V · 2 aircraft · Substantial damage NTSB CHI71AC045Accident · 1 fatalClosedCessna 140 · Vergennes, ILDec 19, 1970 · N2035N · Substantial damage NTSB MKC71DCG36Accident · No injuriesClosedCessna 140 · Versailles, MODec 13, 1970 · N90060 · Substantial damage NTSB LAX71FUA40Accident · No injuriesClosedCessna 140 · Long Beach, CADec 11, 1970 · N2031N · Substantial damage NTSB FTW71FPA16Accident · No injuriesClosedCessna 140 · Garland, TXDec 1, 1970 · N1850V · Substantial damage NTSB MIA71DLA20Accident · No injuriesClosedCessna 140 · Pensacola, FLNov 21, 1970 · N72853 · Substantial damage NTSB CHI71DDW24Accident · No injuriesClosedCessna 140 · Fraser, MINov 14, 1970 · N2893N · Substantial damage NTSB MKC71DCG29Accident · No injuriesClosedCessna 140 · Moberly, MONov 1, 1970 · N4052N · Substantial damage

Back to Cessna 140