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 FTW66D0650Accident · Minor injuriesClosedCessna 150 · Hammod, LAMay 1, 1966 · N6595F · Destroyed NTSB DEN66D0347Accident · No injuriesClosedCessna 150 · Trinidad, COMay 1, 1966 · N7729F · Substantial damage NTSB CHI66F0708Accident · No injuriesClosedCessna 150 · Rockford, ILMay 1, 1966 · N6630F · Substantial damage NTSB CAN66F0420Accident · 1 fatalClosedCessna 150F · Aishihik, CanadaApr 28, 1966 · N6934F · Substantial damage NTSB LAX66F0334Accident · 1 fatalClosedCessna 150 · Julian, CAApr 25, 1966 · N8044S · Destroyed NTSB LAX66D0346Accident · No injuriesClosedCessna 150 · Temecula, CAApr 25, 1966 · N8840S · Substantial damage NTSB SEA66F0245Accident · No injuriesClosedCessna 150 · Moses Lake, WAApr 21, 1966 · N8652G · Substantial damage NTSB OAK66F0279Accident · No injuriesClosedCessna 150 · Oakland, CAApr 21, 1966 · N8510G · Substantial damage NTSB FTW66F0634Accident · No injuriesClosedCessna 150F · San Antonio, TXApr 19, 1966 · N8925S · Substantial damage NTSB OAK66F0231Accident · Minor injuriesClosedCessna 150 · Richvale, CAApr 18, 1966 · N8340G · Substantial damage NTSB MKC66D0541Accident · No injuriesClosedCessna 150 · Atlantic, IAApr 18, 1966 · N8807S · Substantial damage NTSB MIA66F0524Accident · No injuriesClosedCessna 150 · San Juan, PRApr 18, 1966 · N8831S · Destroyed NTSB FTW66F0636Accident · No injuriesClosedCessna 150 · Arlington, TXApr 18, 1966 · N8726G · Substantial damage NTSB NYC66F0636Accident · No injuriesClosedCessna 150 · Bedford, MAApr 17, 1966 · N8171S · Substantial damage NTSB MIA66F0547Accident · No injuriesClosedCessna 150 · Homestead, FLApr 17, 1966 · N8539G · Substantial damage NTSB NYC66F0630Accident · No injuriesClosedCessna 150 · Richmond, VAApr 15, 1966 · N8046S · Substantial damage NTSB FTW66F0613Accident · No injuriesClosedCessna 150; · Pearland, TXApr 14, 1966 · N8635G · Substantial damage NTSB DEN66F0312Accident · No injuriesClosedCessna 150F · Cortez, COApr 13, 1966 · N7083F · Substantial damage NTSB OAK66D0247Accident · No injuriesClosedCessna 150 · Palo Alto, CAApr 11, 1966 · N8496G · Substantial damage NTSB SEA66F0274Accident · No injuriesClosedCessna 150 · Albany, ORApr 9, 1966 · N6767F · Substantial damage NTSB SEA66F0258Accident · No injuriesClosedCessna 150 · Mount Vernon, WAApr 4, 1966 · N8004S · Substantial damage NTSB FTW66F0590Accident · No injuriesClosedCessna 150F · Lubbock, TXApr 2, 1966 · N8596G · Substantial damage NTSB LAX66D0286Accident · No injuriesClosedCessna 150 · San Diego, CAMar 31, 1966 · N8322G · Substantial damage NTSB FTW66D0603Accident · No injuriesClosedCessna 150 · Tulsa, OKMar 28, 1966 · N8872G · Substantial damage NTSB OAK66D0244Accident · No injuriesClosedCessna 150 · San Jose, CAMar 27, 1966 · N8345G · Substantial damage NTSB NYC66F0527Accident · No injuriesClosedCessna 150F · White Plains, NYMar 27, 1966 · N8426G · Substantial damage NTSB LAX66D0287Accident · No injuriesClosedCessna 150F · Santa Monica, CAMar 26, 1966 · N8560G · Substantial damage NTSB LAX66F0285Accident · No injuriesClosedCessna 150 · Sna Pedro, CAMar 21, 1966 · N6260R · Substantial damage NTSB SEA66F0233Accident · No injuriesClosedCessna 150 · Boise, IDMar 16, 1966 · N8324G · Substantial damage NTSB NYC66D0559Accident · Minor injuriesClosedCessna 150 · Deer Park, NYMar 15, 1966 · N6495F · Substantial damage NTSB MIA66F0450Accident · No injuriesClosedCessna 150F · Titusville, FLMar 15, 1966 · N8861G · Substantial damage NTSB MIA66F0447Accident · No injuriesClosedCessna 150 · New Smyrna Bc, FLMar 15, 1966 · N8379G · Substantial damage NTSB FTW66F0556Accident · No injuriesClosedCessna 150 · New Orleans, LAMar 15, 1966 · N8504G · Destroyed NTSB FTW66D0593Accident · No injuriesClosedCessna 150 · Houston, TXMar 15, 1966 · N8758S · Substantial damage NTSB MIA66D0464Accident · No injuriesClosedCessna 150F · Davie, FLMar 14, 1966 · N8267S · Substantial damage NTSB NYC66D0540Accident · No injuriesClosedCessna 150 · Islip, NYMar 13, 1966 · N8120S · Substantial damage NTSB MIA66F0457Accident · No injuriesClosedCessna 150 · Opa Locka, FLMar 11, 1966 · N8568G · Substantial damage NTSB NYC66F0582Accident · No injuriesClosedCessna 150 · Montgomery, NYMar 9, 1966 · N8507G · Substantial damage NTSB DEN66D0270Accident · No injuriesClosedCessna 150 · Phoenix, AZMar 9, 1966 · N8087S · Substantial damage NTSB CHI66F0598Accident · No injuriesClosedCessna 150 · Pontiac, MIMar 5, 1966 · N6471F · Substantial damage NTSB CHI66A0072Accident · 2 fatalClosedCessna 150 · Utica, MIMar 3, 1966 · N8147S · Destroyed NTSB FTW66D0549Accident · No injuriesClosedCessna 150 · Slidell, LAMar 1, 1966 · N3521L · Substantial damage NTSB LAX66F0258Accident · No injuriesClosedCessna 150 · Reno, NVFeb 28, 1966 · N6624F · Substantial damage NTSB NYC66D0572Accident · No injuriesClosedCessna 150 · Totowa, NJFeb 27, 1966 · N8160S · Substantial damage NTSB CHI66D0648Accident · No injuriesClosedCessna 150 · Terre Haute, INFeb 26, 1966 · N6427F · Substantial damage NTSB NYC66F0644Accident · No injuriesClosedCessna 150 · Bedford, MAFeb 22, 1966 · N8366G · Substantial damage NTSB FTW66D0542Accident · No injuriesClosedCessna 150 · Corpus Christ, TXFeb 19, 1966 · N8979S · Substantial damage NTSB CHI66F0589Accident · No injuriesClosedCessna 150 · Winnebago, ILFeb 19, 1966 · N8783S · Substantial damage NTSB MIA66F0420Accident · No injuriesClosedCessna 150 · Lake Murray, SCFeb 17, 1966 · N8617G · Substantial damage NTSB FTW66D0521Accident · No injuriesClosedCessna 150 · Hot Springs, ARFeb 17, 1966 · N8818S · Substantial damage

Back to Cessna 150F