Skip to content

NTSB investigations · 330

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 ('2072410') 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 ('2072410')
  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 ('2072410')
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 UNK65X0392Accident · 4 fatalClosedCessna 172 · Houston, TXOct 23, 1964 · N2142Y · Destroyed NTSB UNK64X3951Accident · No injuriesClosedCessna 172 · La Verne, CASep 13, 1964 · N2454U · 2 aircraft · Substantial damage NTSB UNK64X3919Accident · No injuriesClosedCessna 172 · Wilcox, AZSep 11, 1964 · N2598U · Substantial damage NTSB UNK64X3030Accident · No injuriesClosedCessna 172 · Rushville, INJul 25, 1964 · N2390U · Substantial damage NTSB UNK64X2929Accident · No injuriesClosedCessna 172D · Washington, INJul 19, 1964 · N2723U · Substantial damage NTSB UNK64X2913Accident · No injuriesClosedCessna 172 · Beltsville, MDJul 19, 1964 · N2434U · Substantial damage NTSB UNK64X2852Accident · No injuriesClosedCessna 172 · Salt Lake City, UTJul 16, 1964 · N2590Y · Substantial damage NTSB UNK64X2669Accident · No injuriesClosedCessna 172 · Lake Tahoe, CAJul 5, 1964 · N2341U · Substantial damage NTSB UNK64X2478Accident · No injuriesClosedCessna 172 · Cloudland, GAJun 25, 1964 · N2492U · Substantial damage NTSB UNK64X2366Accident · No injuriesClosedCessna 172D · Los Angeles, CAJun 19, 1964 · N2754U · Substantial damage NTSB UNK64X2333Accident · No injuriesClosedCessna 172D · Westerlo, NYJun 17, 1964 · N2898U · Destroyed NTSB UNK64X2009Accident · No injuriesClosedCessna 172D · Koehn Dry Lke, CAMay 29, 1964 · N2331U · Substantial damage NTSB UNK64X1954Accident · No injuriesClosedCessna 172D · St James, MNMay 25, 1964 · N2447U · Substantial damage NTSB UNK64X1941Accident · No injuriesClosedCessna 172 · Edgartown, MAMay 24, 1964 · N2484U · Substantial damage NTSB UNK64X1923Accident · No injuriesClosedCessna 172D · Pratt, KSMay 23, 1964 · N2420U · Substantial damage NTSB UNK64X1804Accident · No injuriesClosedCessna 172D · Livingston, MTMay 17, 1964 · N2800U · Substantial damage NTSB UNK64X1639Accident · No injuriesClosedCessna 172 · Muskegon, MIMay 6, 1964 · N2890U · Substantial damage NTSB UNK64X1401Accident · No injuriesClosedCessna 172 · Strongsville, OHApr 21, 1964 · N2419Y · Substantial damage NTSB UNK64X1325Accident · No injuriesClosedCessna 172 · El Campo, TXApr 15, 1964 · N2630U · Substantial damage NTSB UNK64X1259Accident · Minor injuriesClosedCessna 172 · Cairo, NYApr 11, 1964 · N2414U · Substantial damage NTSB UNK64X1122Accident · No injuriesClosedCessna 172D · Tallulah, LAApr 1, 1964 · N2501Y · Substantial damage NTSB UNK64X0997Accident · Minor injuriesClosedCessna 172D · El Rosario, MexicoMar 21, 1964 · N2757U · Substantial damage NTSB UNK64X0907Accident · No injuriesClosedCessna 172D · Greenwood, ILMar 14, 1964 · N2506Y · Substantial damage NTSB UNK64X0611Accident · No injuriesClosedCessna 172 · Cleveland, OHFeb 19, 1964 · N2130Y · Substantial damage NTSB UNK64X0586Accident · No injuriesClosedCessna 172 · Janesville, WIFeb 16, 1964 · N2772U · 2 aircraft · Substantial damage NTSB UNK64X0553Accident · 2 fatalClosedCessna 172D · Provo, UTFeb 13, 1964 · N2970U · Destroyed NTSB UNK64X0336Accident · 1 fatalClosedCessna 172 · Lochiel, INJan 23, 1964 · N2753U · Destroyed NTSB UNK64X0287Accident · No injuriesClosedCessna 172D · Dallas, TXJan 19, 1964 · N2485Y · Substantial damage NTSB UNK64X0272Accident · No injuriesClosedCessna 172 · Mitchell Bay, CanadaJan 18, 1964 · N2576Y · Substantial damage NTSB UNK64X0104Accident · Minor injuriesClosedCessna 172 · Jamaica, NYJan 1, 1964 · N2732U · Substantial damage

Back to Cessna 172D