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 CHI75FEE54Accident · No injuriesClosedCessna 140 · Monee, ILMar 21, 1975 · N2036N · Substantial damage NTSB MKC75FER59Accident · No injuriesClosedCessna 140 · Eden Prairie, MNMar 19, 1975 · N76865 · Substantial damage NTSB CHI75FEC41Accident · Serious injuriesClosedCessna 140 · Mason, MIMar 19, 1975 · N76264 · Substantial damage NTSB MIA75DLG25Accident · Minor injuriesClosedCessna 140 · Manning, SCMar 2, 1975 · N76371 · Substantial damage NTSB FTW75FRG58Accident · No injuriesClosedCessna 140 · Crystal City, TXFeb 28, 1975 · N76110 · Substantial damage NTSB MKC75DER52Accident · Minor injuriesClosedCessna 140 · Maple Lake, MNFeb 17, 1975 · N76111 · Substantial damage NTSB MIA75FLD38Accident · No injuriesClosedCessna 140 · Merritt Isl, FLNov 29, 1974 · N77010 · Substantial damage NTSB OAK75DVD22Accident · No injuriesClosedCessna 140 · Concord, CANov 8, 1974 · N90112 · Substantial damage NTSB FTW75DRA11Accident · No injuriesClosedCessna 140 · Conroe, TXNov 4, 1974 · N1998V · Substantial damage NTSB NYC75FFJ16Incident · No injuriesClosedCessna 140 · Orchard Park, NYNov 3, 1974 · N89624 · Minor damage NTSB LAX75DUG16Accident · No injuriesClosedCessna 140 · Chino, CAOct 6, 1974 · N76098 · Substantial damage NTSB IAD75AI017Accident · 1 fatalClosedCessna 140 · Greensboro, NCSep 28, 1974 · N77339 · Destroyed NTSB NYC75FNC09Accident · No injuriesClosedCessna 140 · Nashua, NHSep 22, 1974 · N4006N · Substantial damage NTSB LAX75DUG12Accident · No injuriesClosedCessna 140 · Rubidoux, CASep 21, 1974 · N2528N · Substantial damage NTSB MKC75FCQ16Accident · Serious injuriesClosedCessna 140 · Moline, KSSep 19, 1974 · N76254 · Destroyed NTSB DEN75AD012Accident · 1 fatalClosedCessna 140 · Virginia Dle, COSep 12, 1974 · N72537 · Destroyed NTSB IAD75FLJ09Accident · Minor injuriesClosedCessna 140 · Angier, NCAug 23, 1974 · N2685N · Substantial damage NTSB MIA75DLA12Accident · No injuriesClosedCessna 140 · Panama City, FLAug 22, 1974 · N81063 · Substantial damage NTSB MKC75DCQ11Accident · No injuriesClosedCessna 140 · Argonia, KSAug 16, 1974 · N76520 · Substantial damage NTSB CHI75DEP14Accident · No injuriesClosedCessna 140 · Shawano, WIAug 2, 1974 · N77253 · Substantial damage NTSB MKC75DER03Accident · Minor injuriesClosedCessna 140 · Albert Lea, MNJul 15, 1974 · N2314V · Substantial damage NTSB OAK74DVD01Accident · No injuriesClosedCessna 140 · Tracy, CAJul 7, 1974 · N89779 · Substantial damage NTSB IAD75FLQ01Accident · No injuriesClosedCessna 140 · Symsonia, KYJul 6, 1974 · N73052 · Destroyed NTSB MKC74DCG45Accident · Minor injuriesClosedCessna 140 · Paola, KSJun 29, 1974 · N72597 · Substantial damage NTSB OAK75DVD38Accident · No injuriesClosedCessna 140 · Hayward, CAJun 23, 1974 · N76138 · Substantial damage NTSB MKC74DCJ47Accident · No injuriesClosedCessna 140 · Papillion, NEJun 17, 1974 · N76601 · Substantial damage NTSB SEA74DTI27Accident · No injuriesClosedCessna 140 · Townsend, MTJun 9, 1974 · N76001 · Substantial damage NTSB LAX74DUM34Accident · No injuriesClosedCessna 140 · Borrego Spg, CAMay 30, 1974 · N2286V · Substantial damage NTSB MIA74FLD91Accident · No injuriesClosedCessna 140 · Orlando, FLMay 29, 1974 · N1976N · Substantial damage NTSB MKC74FCD36Accident · Minor injuriesClosedCessna 140 · Logan, IAMay 28, 1974 · N89184 · Destroyed NTSB LAX74DUM35Accident · Minor injuriesClosedCessna 140 · Borrego Spg, CAMay 28, 1974 · N4016N · Destroyed NTSB FTW74AF087Accident · 2 fatalClosedCessna 140 · Sand Springs, OKMay 27, 1974 · N76819 · Destroyed NTSB IAD74DIJ17Accident · No injuriesClosedCessna 140 · Gary, WVMay 24, 1974 · N72829 · Destroyed NTSB FTW74DQG56Accident · No injuriesClosedCessna 140 · Amarillo, TXMay 22, 1974 · N2020N · Substantial damage NTSB CHI74DEI47Accident · No injuriesClosedCessna 140 · Wellington, OHMay 20, 1974 · N1932V · Substantial damage NTSB OAK74DVA64Accident · No injuriesClosedCessna 140 · Five Points, CAMay 11, 1974 · N89291 · Destroyed NTSB MKC74DCD30Accident · No injuriesClosedCessna 140 · Chariton, IAMay 5, 1974 · N76973 · Destroyed NTSB NYC74FNE17Accident · No injuriesClosedCessna 140 · Harwinton, CTApr 17, 1974 · N76131 · Substantial damage NTSB NYC74FHJ24Accident · No injuriesClosedCessna 140 · White Plains, NYApr 11, 1974 · N89352 · Substantial damage NTSB MIA74FLD81Accident · No injuriesClosedCessna 140 · St.Cloud, FLApr 7, 1974 · N2582N · Substantial damage NTSB OAK74DXQ29Accident · Minor injuriesClosedCessna 140 · Susanville, CAMar 31, 1974 · N2018N · Substantial damage NTSB MKC74DCJ33Accident · No injuriesClosedCessna 140 · Gordon, NEMar 30, 1974 · N89640 · Substantial damage NTSB LAX74FUA20Accident · Serious injuriesClosedCessna 140 · Hntngtn Bch, CAMar 30, 1974 · N89425 · Destroyed NTSB CHI74FEG20Accident · No injuriesClosedCessna 140 · Dayton, OHMar 28, 1974 · N72331 · Substantial damage NTSB LAX74FUG44Accident · No injuriesClosedCessna 140 · Upland, CAMar 24, 1974 · N76417 · Substantial damage NTSB ANC74FAA32Accident · Serious injuriesClosedCessna 140 · Delta Jnctn, AKMar 24, 1974 · N2934N · Substantial damage NTSB IAD74DHD30Accident · No injuriesClosedCessna 140 · Dover, DEMar 7, 1974 · N72757 · Substantial damage NTSB FTW74FPG47Accident · No injuriesClosedCessna 140 · Dalark, ARFeb 19, 1974 · N89792 · Substantial damage NTSB NYC74DNC38Accident · No injuriesClosedCessna 140 · Wolfeboro, NHFeb 13, 1974 · N3648V · Substantial damage NTSB OAK74AP038Accident · 2 fatalClosedCessna 140 · Calistoga, CAFeb 5, 1974 · N72299 · Destroyed

Back to Cessna 140