Skip to content

NTSB investigations · 1,653

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 ('2071814') 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 ('2071814')
  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 ('2071814')
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 NYC67A0048Accident · 1 fatalClosedCessna 150 · Westford, MASep 17, 1966 · N8427G · Destroyed NTSB ANC67D0081Accident · No injuriesClosedCessna 150F · Paxson, AKSep 16, 1966 · N8078S · Substantial damage NTSB OAK67D0120Accident · No injuriesClosedCessna 150 · Livermore, CASep 14, 1966 · N6635F · Substantial damage NTSB CHI67F0193Accident · No injuriesClosedCessna 150 · Adrian, MISep 13, 1966 · N6840F · Substantial damage NTSB MKC67D0223Accident · No injuriesClosedCessna 150 · Sedalia, MOSep 5, 1966 · N7927F · Substantial damage NTSB MKC67F0214Accident · No injuriesClosedCessna 150 · Cross Lake, MNSep 3, 1966 · N8834G · Substantial damage NTSB FTW67F0193Accident · No injuriesClosedCessna 150 · Friendswood, TXSep 1, 1966 · N8173S · Substantial damage NTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LASep 1, 1966 · N6585F · Substantial damage NTSB FTW67F0208Accident · No injuriesClosedCessna 150 · Austin, TXAug 31, 1966 · N6626F · Substantial damage NTSB ANC67F0044Accident · No injuriesClosedCessna 150F · Anchorage, AKAug 30, 1966 · N8805S · Substantial damage NTSB OAK67F0258Accident · No injuriesClosedCessna 150 · San Jose, CAAug 28, 1966 · N8259F · 2 aircraft · Substantial damage NTSB MIA67D0204Accident · No injuriesClosedCessna 150 · Plains, GAAug 28, 1966 · N6924F · Substantial damage NTSB CHI67D0220Accident · No injuriesClosedCessna 150 · Joliet, ILAug 27, 1966 · N6630F · Substantial damage NTSB SEA67F0115Accident · No injuriesClosedCessna 150 · Roseburg, ORAug 25, 1966 · N6533F · Substantial damage NTSB NYC67D0231Accident · No injuriesClosedCessna 150 · Monticello, NYAug 25, 1966 · N8266F · Substantial damage NTSB MKC67D0227Accident · No injuriesClosedCessna 150 · Wellington, KSAug 24, 1966 · N6721F · Substantial damage NTSB OAK67D0075Accident · No injuriesClosedCessna 150 · Minden, NVAug 23, 1966 · N8286S · Substantial damage NTSB MKC67D0164Accident · No injuriesClosedCessna 150F · Boone, IAAug 23, 1966 · N6999F · Substantial damage NTSB NYC67F0224Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYAug 21, 1966 · N6991F · Substantial damage NTSB ANC67D0019Accident · No injuriesClosedCessna 150 · Fairbanks, AKAug 18, 1966 · N7097F · Substantial damage NTSB SEA67D0110Accident · No injuriesClosedCessna 150F · Belgrade, MTAug 16, 1966 · N8024S · Substantial damage NTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LAAug 16, 1966 · N8459G · Substantial damage NTSB NYC67F0178Accident · Minor injuriesClosedCessna 150F · Dillwyn, VAAug 14, 1966 · N8147S · Substantial damage NTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDAug 13, 1966 · N8946S · Substantial damage NTSB OAK67D0069Accident · No injuriesClosedCessna 150 · S.Luis Obispo, CAAug 11, 1966 · N8805G · Substantial damage NTSB OAK67D0066Accident · No injuriesClosedCessna 150 · Fresno, CAAug 8, 1966 · N8688S · Substantial damage NTSB MIA67F0132Accident · No injuriesClosedCessna 150F · Orlando, FLAug 7, 1966 · N8455G · Substantial damage NTSB FTW67D0172Accident · Minor injuriesClosedCessna 150 · Corsicana, TXAug 6, 1966 · N6802F · Substantial damage NTSB CHI67D0346Accident · No injuriesClosedCessna 150 · Chicago, ILAug 6, 1966 · N3047X · Substantial damage NTSB DEN67D0072Accident · No injuriesClosedCessna 150 · Jal, NMAug 5, 1966 · N8208S · Substantial damage NTSB FTW67D0129Accident · No injuriesClosedCessna 150 · Navasota, TXAug 3, 1966 · N3568L · Substantial damage NTSB MKC67F0141Accident · No injuriesClosedCessna 150F · Columbus, NEAug 2, 1966 · N6813F · Substantial damage NTSB MKC67D0163Accident · No injuriesClosedCessna 150 · El Dorado, KSAug 2, 1966 · N8101F · Substantial damage NTSB CHI67D0385Accident · No injuriesClosedCessna 150 · Fremont, OHJul 31, 1966 · N3594L · Destroyed NTSB ANC67F0039Accident · No injuriesClosedCessna 150F · Anchorage, AKJul 31, 1966 · N8805S · Substantial damage NTSB MKC67D0107Accident · No injuriesClosedCessna 150 · Norwood, MNJul 30, 1966 · N6988F · Substantial damage NTSB FTW67D0119Accident · No injuriesClosedCessna 150 · Erick, OKJul 30, 1966 · N8417G · Substantial damage NTSB DEN67D0089Accident · No injuriesClosedCessna 150 · Las Cruces, NMJul 30, 1966 · N8006F · Substantial damage NTSB CHI67D0153Accident · No injuriesClosedCessna 150 · Bloomington, INJul 30, 1966 · N8289F · Substantial damage NTSB CHI67D0124Accident · No injuriesClosedCessna 150 · Rockford, ILJul 30, 1966 · N8021S · Substantial damage NTSB OAK67F0070Accident · No injuriesClosedCessna 150 · Minden, NVJul 29, 1966 · N3054X · 2 aircraft · Substantial damage NTSB NYC67F0293Accident · No injuriesClosedCessna 150 · Endicott, NYJul 25, 1966 · N8152S · 2 aircraft · Substantial damage NTSB DEN67D0079Accident · No injuriesClosedCessna 150 · Denver, COJul 25, 1966 · N8023S · Substantial damage NTSB CHI67F0323Accident · Serious injuriesClosedCessna 150F · Chicago, ILJul 24, 1966 · N8846S · Destroyed NTSB LAX67F0099Accident · No injuriesClosedCessna 150 · San Diego, CAJul 23, 1966 · N8862S · Substantial damage NTSB FTW67F0099Accident · Minor injuriesClosedCessna 150 · Sierra Blanca, TXJul 19, 1966 · N8996S · Substantial damage NTSB MKC67D0121Accident · No injuriesClosedCessna 150 · Red Oak, IAJul 18, 1966 · N8106S · Substantial damage NTSB LAX67F0025Accident · No injuriesClosedCessna 150 · Carpinteria, CAJul 17, 1966 · N8099S · Substantial damage NTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LAJul 16, 1966 · N8457G · Substantial damage NTSB OAK67A0006Accident · 2 fatalClosedCessna 150 · Minden, NVJul 15, 1966 · N8702S · Destroyed

Back to Cessna 150F