Skip to content

NTSB investigations · 1,286

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 ('2071830') 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 ('2071830')
  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 ('2071830')
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 OAK77DXQ05Accident · No injuriesClosedCessna 150 · Jackpot, NVFeb 2, 1977 · N714KM · Substantial damage NTSB CHI77FEV09Accident · No injuriesClosedCessna 150 · Peoria, ILJan 29, 1977 · N9336U · Substantial damage NTSB CHI77FEG08Accident · No injuriesClosedCessna 150 · Harrison, OHJan 22, 1977 · N8878U · Substantial damage NTSB MKC77FCA10Accident · No injuriesClosedCessna 150M · Marthasville, MOJan 21, 1977 · N45559 · Substantial damage NTSB SEA77FYE08Accident · Minor injuriesClosedCessna 150 · Langley, WAJan 20, 1977 · N66043 · Substantial damage NTSB DEN77FTE16Accident · Serious injuriesClosedCessna 150M · Fort Collins, COJan 19, 1977 · N66100 · Destroyed NTSB IAD77DID11Accident · No injuriesClosedCessna 150M · Moneta, VAJan 13, 1977 · N9202U · Substantial damage NTSB CHI77FEP16Accident · No injuriesClosedCessna 150 · Mosinee, WIJan 9, 1977 · N63346 · Substantial damage NTSB MIA77FLG06Accident · No injuriesClosedCessna 150M · Isle Of Palms, SCJan 8, 1977 · N8805U · Substantial damage NTSB MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSDec 25, 1976 · N6306K · Substantial damage NTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damage NTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILDec 18, 1976 · N63406 · Substantial damage NTSB CHI77DEE06Accident · No injuriesClosedCessna 150M · Belvidere, ILDec 4, 1976 · N9172U · Substantial damage NTSB CHI77FEI05Accident · No injuriesClosedCessna 150 · Vienna, OHDec 3, 1976 · N8632U · Substantial damage NTSB CHI77DEV05Accident · No injuriesClosedCessna 150 · Decatur, ILNov 24, 1976 · N8778U · Substantial damage NTSB NYC77DNC10Accident · Minor injuriesClosedCessna 150 · Hampton, NHNov 13, 1976 · N45160 · Substantial damage NTSB FTW77FRA04Accident · Serious injuriesClosedCessna 150M · Chester, TXNov 10, 1976 · N10EB · Destroyed NTSB IAD77FLJ05Accident · Minor injuriesClosedCessna 150 · Woodland, NCNov 5, 1976 · N63283 · Substantial damage NTSB NYC77FNC06Accident · Minor injuriesClosedCessna 150M · Cherryfield, MENov 2, 1976 · N760CA · Substantial damage NTSB LAX77FUG04Accident · No injuriesClosedCessna 150 · Ettiwanda, CAOct 29, 1976 · N45394 · Substantial damage NTSB IAD77DKM06Accident · No injuriesClosedCessna 150 · Banner Elk, NCOct 29, 1976 · N88656 · Substantial damage NTSB MIA77FKJ03Accident · Serious injuriesClosedCessna 150 · New Brockton, ALOct 25, 1976 · N802AA · Substantial damage NTSB NYC77FHD03Accident · No injuriesClosedCessna 150M · Waterford, NJOct 22, 1976 · N7986U · Substantial damage NTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WIOct 20, 1976 · N704PN · Destroyed NTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMOct 19, 1976 · N66113 · Destroyed NTSB MKC77FCG03Accident · Minor injuriesClosedCessna 150M · Waldron, MOOct 17, 1976 · N45078 · 2 aircraft · Substantial damage NTSB NYC77FHD01Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1976 · N63150 · Substantial damage NTSB IAD77DIG03Accident · No injuriesClosedCessna 150 · Easton, MDOct 16, 1976 · N7574U · Substantial damage NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 30, 1976 · N45230 · Substantial damage NTSB MIA76DKT99Accident · No injuriesClosedCessna 150 · Opalocka, FLSep 27, 1976 · N66374 · Substantial damage NTSB FTW76AF121Accident · 1 fatalClosedCessna 150M · Kiefer, OKSep 13, 1976 · N45690 · Destroyed NTSB ANC76AA129Accident · 1 fatalClosedCessna 150 · Sterling, AKSep 11, 1976 · N63215 · Substantial damage NTSB CHI76AC090Accident · 2 fatalClosedCessna 150M · Salem, ILSep 7, 1976 · N6244K · Destroyed NTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GASep 6, 1976 · N45256 · Substantial damage NTSB LAX76DVQ51Accident · No injuriesClosedCessna 150 · Lancaster, CASep 5, 1976 · N66046 · Substantial damage NTSB LAX76FUQ49Accident · Minor injuriesClosedCessna 150 · Lancaster, CAAug 25, 1976 · N6135K · Destroyed NTSB CHI76FEE74Accident · 1 fatalClosedCessna 150M · Lockport, ILAug 24, 1976 · N7TZ · Substantial damage NTSB OAK76FVH05Accident · No injuriesClosedCessna 150 · Elk Grove, CAAug 21, 1976 · N9289U · Substantial damage NTSB NYC76FFJ28Accident · No injuriesClosedCessna 150M · Brockport, NYAug 2, 1976 · N8440U · Substantial damage NTSB ANC76AA117Accident · 1 fatalClosedCessna 150 · Nome, AKAug 1, 1976 · N7672U · Destroyed NTSB CHI76FEI38Accident · No injuriesClosedCessna 150 · Cleveland, OHJul 28, 1976 · N9451U · Substantial damage NTSB IAD76DKM42Accident · Minor injuriesClosedCessna 150 · Bessemer City, NCJul 25, 1976 · N9194U · Substantial damage NTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LAJul 24, 1976 · N66127 · Substantial damage NTSB MKC76DCA37Accident · No injuriesClosedCessna 150 · Cuba, MOJul 22, 1976 · N63199 · Substantial damage NTSB MIA76DLD71Accident · No injuriesClosedCessna 150 · Arcadia, FLJul 21, 1976 · N8360U · Destroyed NTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILJul 17, 1976 · N66375 · 2 aircraft · Destroyed NTSB IAD76AI081Accident · 3 fatalClosedCessna 150 · Elkhorn City, KYJul 4, 1976 · N9238U · Substantial damage NTSB FTW76FRA50Accident · Minor injuriesClosedCessna 150 · Huffman, TXJul 4, 1976 · N3801V · Substantial damage NTSB MKC76DTG19Accident · Minor injuriesClosedCessna 150M · Rolette, NDJun 28, 1976 · N3749V · Substantial damage

Back to Cessna 150M