Skip to content

NTSB investigations · 884

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 ('2071820') 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 ('2071820')
  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 ('2071820')
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 MKC74DER51Accident · No injuriesClosedCessna 150J · Esko, MNJun 1, 1974 · N50793 · Substantial damage NTSB LAX74DUJ65Accident · No injuriesClosedCessna 150J · Tucson, AZMay 30, 1974 · N60640 · Substantial damage NTSB IAD74DLQ41Accident · No injuriesClosedCessna 150 · Richmond, KYMay 30, 1974 · N51218 · Substantial damage NTSB MIA74DLD88Accident · No injuriesClosedCessna 150 · Brandon, FLMay 19, 1974 · N60921 · Substantial damage NTSB OAK74DXQ39Accident · No injuriesClosedCessna 150 · Reno, NVMay 14, 1974 · N50512 · Substantial damage NTSB FTW74FRA40Accident · No injuriesClosedCessna 150J · La Porte, TXMay 8, 1974 · N5599G · Substantial damage NTSB FTW74FPA22Accident · No injuriesClosedCessna 150J · Dallas, TXMay 8, 1974 · N5544G · Substantial damage NTSB MIA74FKJ55Accident · No injuriesClosedCessna 150 · Brewton, ALMay 7, 1974 · N5612G · Substantial damage NTSB OAK74FVM26Accident · Minor injuriesClosedCessna 150J · Gonzales, CAMay 5, 1974 · N61057 · Destroyed NTSB OAK74DVG48Accident · No injuriesClosedCessna 150 · Sloughhouse, CAApr 22, 1974 · N61175 · Substantial damage NTSB NYC74AN090Accident · 1 fatalClosedCessna 150 · Boothbay Harbr, MEApr 22, 1974 · N50819 · Substantial damage NTSB NYC74DHA26Accident · No injuriesClosedCessna 150J · Stillwater, NJApr 13, 1974 · N61208 · Substantial damage NTSB FTW74FPD41Accident · No injuriesClosedCessna 150 · Fort Worth, TXApr 9, 1974 · N51023 · 2 aircraft · Destroyed NTSB SEA74DYC42Accident · No injuriesClosedCessna 150J · Molalla, ORApr 6, 1974 · N61365 · Destroyed NTSB CHI74FEI35Accident · Minor injuriesClosedCessna 150J · Ravenna, OHApr 2, 1974 · N51247 · Substantial damage NTSB CHI74DEM47Accident · No injuriesClosedCessna 150 · Mt Pleasant, MIMar 25, 1974 · N5506G · Substantial damage NTSB FTW74DRG69Accident · No injuriesClosedCessna 150J · Seguin, TXMar 20, 1974 · N5580G · Substantial damage NTSB MIA74DKT57Accident · Minor injuriesClosedCessna 150 · Gamboa, St. Pierre & MiquelonMar 9, 1974 · N60106 · Destroyed NTSB FTW74DPD35Accident · No injuriesClosedCessna 150J · Fort Worth, TXFeb 17, 1974 · N60926 · Substantial damage NTSB MKC74FTG13Accident · No injuriesClosedCessna 150J · Grand Forks, NDFeb 9, 1974 · N60667 · Substantial damage NTSB MKC74DER40Accident · No injuriesClosedCessna 150 · Motley, MNFeb 9, 1974 · N60030 · Substantial damage NTSB OAK74DVA45Accident · No injuriesClosedCessna 150 · Modesto, CAFeb 7, 1974 · N61253 · Substantial damage NTSB OAK74DVA41Accident · No injuriesClosedCessna 150 · Fresno, CAJan 28, 1974 · N3803J · Substantial damage NTSB MKC74AK040Accident · 2 fatalClosedCessna 150J · Pittsburg, KSJan 25, 1974 · N60544 · Destroyed NTSB LAX74AL054Accident · 2 fatalClosedCessna 150J · Holbrook, AZJan 25, 1974 · N50620 · Destroyed NTSB CHI74FEK10Accident · No injuriesClosedCessna 150J · Vanwert, OHDec 28, 1973 · N50675 · Substantial damage NTSB DEN74AD052Accident · 1 fatalClosedCessna 150J · Sargents, CODec 25, 1973 · N5543G · Destroyed NTSB OAK74DXQ18Accident · No injuriesClosedCessna 150 · Chester, CADec 18, 1973 · N51135 · Substantial damage NTSB LAX74FUA08Accident · No injuriesClosedCessna 150J · El Toro, CAOct 20, 1973 · N51290 · Substantial damage NTSB FTW74AF023Accident · 1 fatalClosedCessna 150J · Britton, TXOct 20, 1973 · N51388 · Destroyed NTSB FTW74FRG28Accident · No injuriesClosedCessna 150J · San Antonio, TXOct 19, 1973 · N5580G · Substantial damage NTSB MIA74DLA19Accident · No injuriesClosedCessna 150J · Pensacola, FLOct 10, 1973 · N50446 · Substantial damage NTSB MKC74DTG09Accident · No injuriesClosedCessna 150H · Angus, MNOct 5, 1973 · N50989 · Substantial damage NTSB FTW74DPD18Accident · No injuriesClosedCessna 150J · Mineral Wells, TXSep 16, 1973 · N60687 · Substantial damage NTSB CHI74DEM21Accident · No injuriesClosedCessna 150 · Muskegon, MISep 16, 1973 · N51094 · Substantial damage NTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYSep 9, 1973 · N60616 · 2 aircraft · Substantial damage NTSB MKC74AK008Accident · 1 fatalClosedCessna 150J · Emporia, KSAug 28, 1973 · N60410 · Substantial damage NTSB MIA74DKJ74Accident · No injuriesClosedCessna 150 · Ider, ALAug 13, 1973 · N60318 · Substantial damage NTSB DEN74FTE12Accident · Minor injuriesClosedCessna 150 · Eldorado Spg, COAug 9, 1973 · N60027 · Destroyed NTSB CHI74FEP06Accident · Minor injuriesClosedCessna 150J · Milwaukee, WIAug 7, 1973 · N60422 · 2 aircraft · Substantial damage NTSB FTW74DRG09Accident · No injuriesClosedCessna 150J · San Marcos, TXAug 6, 1973 · N60655 · Substantial damage NTSB MKC74DCJ05Accident · No injuriesClosedCessna 150J · North Platte, NEAug 2, 1973 · N50576 · Substantial damage NTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSAug 1, 1973 · N60051 · Substantial damage NTSB CHI74DEV07Accident · No injuriesClosedCessna 150 · Peoria, ILJul 31, 1973 · N61198 · Substantial damage NTSB NYC74FHA04Accident · No injuriesClosedCessna 150J · Honesdale, PAJul 25, 1973 · N50476 · Substantial damage NTSB SEA74DYI02Accident · No injuriesClosedCessna 150J · Rogue River, ORJul 20, 1973 · N50566 · Substantial damage NTSB CHI74FEI02Accident · No injuriesClosedCessna 150 · Doylestown, OHJul 18, 1973 · N5585G · Substantial damage NTSB MIA73DKU11Accident · No injuriesClosedCessna 150 · Belle Glade, FLJun 30, 1973 · N60177 · Substantial damage NTSB LAX73DUQ42Accident · No injuriesClosedCessna 150 · Vandnbg Afb, CAJun 28, 1973 · N60605 · Substantial damage NTSB CHI73FEK23Accident · No injuriesClosedCessna 150J · Somerset, OHJun 9, 1973 · N50500 · Substantial damage

Back to Cessna 150J