Skip to content

NTSB investigations · 1,193

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 ('2071816') 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 ('2071816')
  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 ('2071816')
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 DEN74DTM17Accident · No injuriesClosedCessna 150G · Cedar City, UTApr 25, 1974 · N8333J · Substantial damage NTSB NYC74DFA27Accident · Minor injuriesClosedCessna 150G · Oneonta, NYApr 21, 1974 · N3455J · Substantial damage NTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNApr 21, 1974 · N3176X · Substantial damage NTSB NYC74DHA27Accident · No injuriesClosedCessna 150G · Pittstown, NJApr 20, 1974 · N2899S · Substantial damage NTSB MIA74AM086Accident · Serious injuriesClosedCessna 150G · Stone Mountain, GAApr 10, 1974 · N2748S · 2 aircraft · Destroyed NTSB LAX74DYI11Accident · No injuriesClosedCessna 150 · Medford, ORApr 7, 1974 · N2800S · 2 aircraft · Substantial damage NTSB MKC74DCD24Accident · No injuriesClosedCessna 150 · Matthews, MOMar 8, 1974 · N3133X · Substantial damage NTSB IAD74AI048Accident · 1 fatalClosedCessna 150G · Jewell Ridge, VAFeb 28, 1974 · N3230X · Destroyed NTSB MIA74FLD63Accident · No injuriesClosedCessna 150 · Candler, FLFeb 5, 1974 · N8532J · Substantial damage NTSB SEA74DTI16Accident · No injuriesClosedCessna 150 · Hamilton, MTJan 11, 1974 · N4621X · Substantial damage NTSB NYC74FNC32Accident · Minor injuriesClosedCessna 150G · Belfast, MEJan 4, 1974 · N3402J · Substantial damage NTSB SEA74FTA15Accident · No injuriesClosedCessna 150 · Belle Creek, MTDec 29, 1973 · N2295J · Substantial damage NTSB OAK74DVM15Accident · Minor injuriesClosedCessna 150G · San Jose, CADec 24, 1973 · N2249J · Substantial damage NTSB FTW74AF046Accident · 1 fatalClosedCessna 150G · De Soto, TXDec 22, 1973 · N2227J · Destroyed NTSB LAX74FUG27Accident · No injuriesClosedCessna 150 · Rialto, CANov 23, 1973 · N2978J · Substantial damage NTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNov 3, 1973 · N8561J · Substantial damage NTSB OAK74FVA32Accident · No injuriesClosedCessna 150G · Madera, CANov 1, 1973 · N8618J · Substantial damage NTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INOct 27, 1973 · N4027J · Substantial damage NTSB MIA74OKT35Accident · No injuriesClosedCessna 150G · Mores Is, Burkina FasoOct 26, 1973 · N3234X · Substantial damage NTSB MIA74AM035Accident · 1 fatalClosedCessna 150G · Titusville, FLOct 17, 1973 · N1642M · Destroyed NTSB FTW74FPD19Accident · Minor injuriesClosedCessna 150 · Bridgeport, TXOct 14, 1973 · N3657J · Substantial damage NTSB MIA74FKG29Accident · Serious injuriesClosedCessna 150G · Jonesboro, GASep 17, 1973 · N2218J · Substantial damage NTSB NYC74AN022Accident · 1 fatalClosedCessna 150G · Wheeling, ILSep 13, 1973 · N3076S · 2 aircraft · Destroyed NTSB MIA74DLA13Accident · No injuriesClosedCessna 150 · Marianna, FLAug 31, 1973 · N2944J · Substantial damage NTSB OAK74AP009Accident · 2 fatalClosedCessna 150G · S.Francisco, CAAug 27, 1973 · N3705J · Destroyed NTSB NYC74DHM04Accident · No injuriesClosedCessna 150 · Bloomingburg, NYAug 26, 1973 · N2978S · Substantial damage NTSB CHI74FEE11Accident · No injuriesClosedCessna 150 · Wheeling, ILAug 20, 1973 · N3135J · Substantial damage NTSB NYC74DNC17Accident · No injuriesClosedCessna 150G · Wiscasset, MEAug 17, 1973 · N8556J · Substantial damage NTSB OAK74DXQ08Accident · No injuriesClosedCessna 150 · Winnemucca, NVAug 13, 1973 · N6202S · Substantial damage NTSB SEA74FYC09Accident · No injuriesClosedCessna 150 · Baker, ORAug 12, 1973 · N4827X · Substantial damage NTSB NYC74DNA03Accident · No injuriesClosedCessna 150 · N Atlantic Ocean (Atlantic Ocean)Jul 16, 1973 · N8398J · Destroyed NTSB IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNJul 14, 1973 · N4733X · Substantial damage NTSB MIA74FKG04Accident · No injuriesClosedCessna 150 · Dalton, GAJul 12, 1973 · N3796J · Substantial damage NTSB IAD74DLQ05Accident · Minor injuriesClosedCessna 150 · Campbellsville, KYJul 7, 1973 · N4746X · Substantial damage NTSB SEA74DYE16Accident · No injuriesClosedCessna 150 · Aldrwood Mnr, WAJun 30, 1973 · N8606J · Minor damage NTSB MIA73DLG52Accident · No injuriesClosedCessna 150 · New Ellenton, SCJun 29, 1973 · N3269J · Substantial damage NTSB DEN73FTE89Accident · Minor injuriesClosedCessna 150 · Holly, COJun 24, 1973 · N2983J · Substantial damage NTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNJun 18, 1973 · N3918J · Substantial damage NTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PAJun 2, 1973 · N3203J · Substantial damage NTSB MIA73FLA39Accident · No injuriesClosedOwl-Stol 150 · Palatka, FLMay 27, 1973 · N6358S · Substantial damage NTSB FTW73DRG85Accident · No injuriesClosedCessna 150 · Harlingen, TXMay 22, 1973 · N5116G · 2 aircraft · Destroyed NTSB FTW73DRD31Accident · No injuriesClosedCessna 150G · Lockport, LAMay 22, 1973 · N4092J · Substantial damage NTSB CHI73FCA05Accident · Minor injuriesClosedCessna 150 · Cahokia, ILMay 18, 1973 · N6272S · Substantial damage NTSB MIA73AM102Accident · 2 fatalClosedCessna 150G · Hiram, GAMay 13, 1973 · N2457J · Destroyed NTSB FTW73FRA27Accident · Serious injuriesClosedCessna 150G · Brenham, TXMay 2, 1973 · N3830J · Substantial damage NTSB NYC73FHD32Accident · Minor injuriesClosedCessna 150G · Rancocas, NJApr 21, 1973 · N3480J · Destroyed NTSB MIA73FLG44Accident · Serious injuriesClosedCessna 150B · Columbia, SCApr 18, 1973 · N2860S · Destroyed NTSB CHI73FEP43Accident · Serious injuriesClosedCessna 150G · Monroe, WIMar 29, 1973 · N2418J · Destroyed NTSB MIA73DLD67Accident · Serious injuriesClosedCessna 150 · Silver Spring, FLMar 28, 1973 · N1641M · Substantial damage NTSB LAX73DUM73Accident · No injuriesClosedCessna 150 · Santee, CAMar 14, 1973 · N3331J · Substantial damage

Back to Cessna 150G