Skip to content

NTSB investigations · 1,097

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 ('2072402') 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 ('2072402')
  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 ('2072402')
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 UNK64X2915Accident · No injuriesClosedCessna 172 · Waterford, CTJul 19, 1964 · N6434B · Destroyed NTSB UNK64X2896Accident · No injuriesClosedCessna 172 · Fresno, CAJul 18, 1964 · N6268E · Substantial damage NTSB UNK64X2759Accident · No injuriesClosedCessna 170B · Mahopac, NYJul 11, 1964 · N8804B · Substantial damage NTSB UNK64X2648Accident · 2 fatalClosedCessna 172 · Tulsa, OKJul 4, 1964 · N6496E · Substantial damage NTSB UNK64X2590Accident · No injuriesClosedCessna 172 · Rehobeth, DEJul 1, 1964 · N3949F · Substantial damage NTSB UNK64X2531Accident · No injuriesClosedCessna 172 · Clinton, ILJun 28, 1964 · N8841B · Substantial damage NTSB UNK64X2521Accident · No injuriesClosedCessna 172 · Gadsen, ALJun 27, 1964 · N7300A · Substantial damage NTSB UNK64X2516Accident · Minor injuriesClosedCessna 172 · Little York, NJJun 27, 1964 · N8653B · Destroyed NTSB UNK64X2447Accident · No injuriesClosedCessna 172A · Farmersburg, INJun 23, 1964 · N6982A · Destroyed NTSB UNK64X2418Accident · Minor injuriesClosedCessna 172 · Ansonia, OHJun 21, 1964 · N5776A · Destroyed NTSB UNK64X2406Accident · 1 fatalClosedCessna 172 · Hampton, NHJun 20, 1964 · N4213F · Destroyed NTSB UNK64X2316Accident · Minor injuriesClosedCessna 172 · Van Buren, INJun 16, 1964 · N6498E · Substantial damage NTSB UNK64X2288Accident · No injuriesClosedCessna 172 · Cairo, GAJun 14, 1964 · N6886A · Substantial damage NTSB UNK64X2238Accident · No injuriesClosedCessna 172 · Detroit, MIJun 11, 1964 · N7496A · 2 aircraft · Substantial damage NTSB UNK64X2223Accident · No injuriesClosedCessna 172 · Foremost, CanadaJun 11, 1964 · N7304A · Substantial damage NTSB UNK64X2170Accident · No injuriesClosedCessna 172 · Lathrop Wells, NVJun 7, 1964 · N7954B · Substantial damage NTSB UNK64X2168Accident · No injuriesClosedCessna 172 · Page, AZJun 7, 1964 · N6221E · Substantial damage NTSB UNK64X2087Accident · Minor injuriesClosedCessna 172 · Braintree, MAJun 3, 1964 · N4151F · Destroyed NTSB UNK64X1970Accident · Serious injuriesClosedCessna 172 · Lewiston, IDMay 27, 1964 · N4067F · Substantial damage NTSB UNK64X1925Accident · Minor injuriesClosedBensen · Smithfield, RIMay 23, 1964 · N8756B · Substantial damage NTSB UNK64X1910Accident · No injuriesClosedCessna 172 · Armonk, NYMay 23, 1964 · N4250F · Substantial damage NTSB UNK64X1879Accident · No injuriesClosedCessna 172 · Alachua, FLMay 22, 1964 · N4245F · Substantial damage NTSB UNK64X1860Accident · No injuriesClosedCessna 172 · Clovis, NMMay 20, 1964 · N6657A · Substantial damage NTSB UNK64X1859Accident · Minor injuriesClosedCessna 172 · Wink, TXMay 20, 1964 · N5945A · Destroyed NTSB UNK64X1755Accident · No injuriesClosedCessna 172 · El Dorado, KSMay 13, 1964 · N6938A · Substantial damage NTSB UNK64X1702Accident · No injuriesClosedCessna 172 · Pe Ell, WAMay 10, 1964 · N8724B · Substantial damage NTSB UNK64X1453Accident · No injuriesClosedCessna 172 · Circle Pines, MNApr 25, 1964 · N9146B · Substantial damage NTSB UNK64X1396Accident · 1 fatalClosedCessna 172 · Dubois, WYApr 20, 1964 · N5831A · Substantial damage NTSB UNK64X1357Accident · Minor injuriesClosedCessna 172 · Munday, TXApr 18, 1964 · N8280B · Destroyed NTSB UNK64X1323Accident · No injuriesClosedCessna 172 · Quitaque, TXApr 15, 1964 · N6479E · Substantial damage NTSB UNK64X1248Accident · No injuriesClosedCessna 172 · Parker, AZApr 10, 1964 · N3932F · Substantial damage NTSB UNK64X1144Accident · No injuriesClosedCessna 172 · Ilmington, DEApr 3, 1964 · N7046A · Substantial damage NTSB UNK64X1072Accident · No injuriesClosedCessna 172 · Elizabethville, PAMar 28, 1964 · N8750B · Substantial damage NTSB UNK64X1024Accident · No injuriesClosedCessna 172 · Boulder City, NVMar 23, 1964 · N8118B · Substantial damage NTSB UNK64X1018Accident · Serious injuriesClosedCessna 172 · Wrigtwood, CAMar 22, 1964 · N5994A · Destroyed NTSB UNK64X0949Accident · No injuriesClosedCessna 172 · Moorehead, KYMar 16, 1964 · N8342B · Destroyed NTSB UNK64X0938Accident · No injuriesClosedCessna 172 · Murrieta, CAMar 15, 1964 · N7149T · Substantial damage NTSB UNK64X0909Accident · No injuriesClosedCessna 172 · St Petersburg, FLMar 14, 1964 · N6102E · Substantial damage NTSB UNK64X0868Accident · No injuriesClosedCessna 172 · Uncertain, TXMar 10, 1964 · N7058A · Substantial damage NTSB UNK64X0843Accident · No injuriesClosedCessna 172 · Le Sueur, MNMar 8, 1964 · N6314E · Substantial damage NTSB UNK64X0551Accident · 1 fatalClosedCessna 172A · Newcastle, WYFeb 13, 1964 · N6480E · Destroyed NTSB UNK64X0517Accident · No injuriesClosedCessna 172 · Avenal, CAFeb 9, 1964 · N6745A · Substantial damage NTSB UNK64X0501Accident · No injuriesClosedCessna 172 · Anaconda, MTFeb 8, 1964 · N7109A · Substantial damage NTSB UNK64X0483Accident · No injuriesClosedCessna 172 · Davenport, WAFeb 7, 1964 · N4264F · Substantial damage NTSB UNK64X0430Accident · No injuriesClosedCessna 172 · Sandy, UTFeb 2, 1964 · N7079T · Substantial damage NTSB UNK64X0252Accident · 2 fatalClosedCessna 172 · Columbus, OHJan 15, 1964 · N8390B · Destroyed NTSB UNK64X0111Accident · No injuriesClosedCessna 172 · Rawlings, WYJan 1, 1964 · N4182F · Substantial damage

Back to Cessna 172