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 NYC75FNA18Accident · Minor injuriesClosedCessna 172 · Block Island, RISep 22, 1974 · N6206E · Destroyed NTSB CHI75FEM11Accident · Serious injuriesClosedCessna 172 · Harrison, MISep 19, 1974 · N4155F · Destroyed NTSB ANC75AA020Accident · 1 fatalClosedCessna 172 · Palmer, AKSep 2, 1974 · N12747 · Destroyed NTSB DEN75AD008Accident · 1 fatalClosedCessna 172 · Parowan, UTAug 31, 1974 · N5114A · Destroyed NTSB OAK75AP005Accident · 1 fatalClosedCessna 172 · Novato, CAAug 12, 1974 · N5570R · Destroyed NTSB CHI75DEA01Accident · No injuriesClosedCessna 172 · Anderson, INJul 8, 1974 · N7410A · Substantial damage NTSB UNK74X0114Accident · No injuriesClosedCessna 172F · Brandon, United KingdomJun 30, 1974 · N5162F · Substantial damage NTSB MKC74DCG44Accident · No injuriesClosedCessna 172 · Columbia, MOJun 23, 1974 · N8319B · Substantial damage NTSB SEA74DTI26Accident · No injuriesClosedCessna 172 · Swan Lake, MTJun 18, 1974 · N6282E · Substantial damage NTSB CHI74DEA46Accident · No injuriesClosedCessna 172 · Greentown, INJun 12, 1974 · N4104F · Substantial damage NTSB OAK74DXQ43Accident · No injuriesClosedCessna 172 · Minden, NVJun 7, 1974 · N5139A · Substantial damage NTSB IAD74DLJ42Accident · No injuriesClosedCessna 172 · Durants Neck, NCMay 17, 1974 · N5855A · Destroyed NTSB FTW74FQD23Accident · Serious injuriesClosedCessna 172 · Acala, TXMay 11, 1974 · N9125B · Destroyed NTSB FTW74AF082Accident · 1 fatalClosedCessna 172 · Jasper, ARMay 9, 1974 · N7299A · Destroyed NTSB UNK74X0105Accident · No injuriesClosedCessna 172 · S.J.Del Cabo, MexicoMay 7, 1974 · N6648A · Substantial damage NTSB IAD74DKM53Accident · No injuriesClosedCessna 172 · Jefferson, NCApr 30, 1974 · N279MD · Substantial damage NTSB IAD74FIA13Accident · No injuriesClosedCessna 172M · Luray, VAApr 28, 1974 · N12195 · Substantial damage NTSB OAK74AP060Accident · 1 fatalClosedCessna 172 · Santa Rosa, CAApr 27, 1974 · N7083T · Destroyed NTSB NYC75FHJ27Incident · No injuriesClosedCessna 172 · Ronkonkoma, NYApr 24, 1974 · N503E · Minor damage NTSB OAK74AP051Accident · 4 fatalClosedCessna 172F · Hollister, CAApr 8, 1974 · N5594R · Destroyed NTSB MKC74FER44Accident · No injuriesClosedCessna 172 · Willmar, MNMar 23, 1974 · N6126E · Substantial damage NTSB DEN74AD042Accident · 1 fatalClosedCessna 172A · Silver City, NMMar 14, 1974 · N7284T · Destroyed NTSB NYC74DFA20Accident · No injuriesClosedCessna 172 · Hamilton, NYFeb 9, 1974 · N8921B · Substantial damage NTSB MIA74OKT55Accident · Minor injuriesClosedCessna 172 · P.Obauldia, St. Pierre & MiquelonFeb 6, 1974 · N2877Q · Substantial damage NTSB CHI74DEP30Accident · No injuriesClosedCessna 172 · Stevens Point, WIFeb 3, 1974 · N79409 · Substantial damage NTSB IAD74DKM37Accident · No injuriesClosedCessna 172 · Maiden, NCJan 22, 1974 · N8282B · Substantial damage NTSB MKC74DCJ21Accident · No injuriesClosedCessna 172 · Omaha, NEDec 29, 1973 · N8213B · Substantial damage NTSB MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damage NTSB MKC74DTG11Accident · No injuriesClosedCessna 172 · Bowman, NDDec 8, 1973 · N5076A · Substantial damage NTSB NYC74DHM11Accident · No injuriesClosedCessna 172 · Colts Neck, NJNov 11, 1973 · N6023A · Substantial damage NTSB IAD74AI021Accident · 1 fatalClosedCessna 172 · Lewisburg, TNOct 13, 1973 · N7108T · Destroyed NTSB IAD74DKM21Accident · No injuriesClosedCessna 172 · Asheville, NCOct 7, 1973 · N5970A · Substantial damage NTSB CHI74FEK06Accident · Serious injuriesClosedCessna 172 · Caledonia, OHOct 6, 1973 · N7121T · Substantial damage NTSB NYC74DHM09Accident · Minor injuriesClosedCessna 172 · East Hanover, NJOct 5, 1973 · N1861Y · Substantial damage NTSB IAD74FLJ18Accident · Minor injuriesClosedCessna 172 · Sanford, NCSep 22, 1973 · N7077A · Substantial damage NTSB NYC74AN028Accident · No injuriesClosedCessna 172 · Ronkonkoma, NYSep 21, 1973 · N6115E · Substantial damage NTSB IAD74DIJ05Accident · No injuriesClosedCessna 172 · Austinville, VASep 10, 1973 · N7405A · Substantial damage NTSB CHI74FEG07Accident · No injuriesClosedCessna 172 · Forest Park, OHSep 1, 1973 · N7110A · Substantial damage NTSB DEN74DTM07Accident · No injuriesClosedCessna 172 · Green River, UTAug 25, 1973 · N5934A · Substantial damage NTSB IAD74AI008Accident · 1 fatalClosedCessna 172 · Loretto, KYAug 1, 1973 · N6853A · Destroyed NTSB CHI74AC011Accident · 2 fatalClosedCessna 172L · Seneca, ILJul 31, 1973 · N7863G · Destroyed NTSB IAD74FLJ05Accident · Minor injuriesClosedCessna 172 · Raleigh, NCJul 28, 1973 · N5644A · Substantial damage NTSB FTW74FPD03Accident · No injuriesClosedCessna 172 · Iowa Park, TXJul 25, 1973 · N7117T · Substantial damage NTSB LAX74DUQ01Accident · No injuriesClosedCessna 172 · Goleta, CAJul 5, 1973 · N4190F · Substantial damage NTSB IAD74FKM02Accident · Serious injuriesClosedCessna 172H · Hickory, NCJul 4, 1973 · N8242L · Substantial damage NTSB MIA73FKU10Accident · Minor injuriesClosedCessna 172 · Boca Raton, FLJun 29, 1973 · N5141A · Substantial damage NTSB LAX73AL064Accident · 3 fatalClosedCessna 172 · Cottonwood, AZJun 29, 1973 · N8291B · Destroyed NTSB MKC73DTG13Accident · No injuriesClosedCessna 172 · Grace City, NDMay 21, 1973 · N7423A · Substantial damage NTSB LAX73DUG57Accident · No injuriesClosedCessna 172 · Banning, CAMay 13, 1973 · N8162B · Substantial damage NTSB CHI73DEC33Accident · No injuriesClosedCessna 172 · Utica, MIMay 10, 1973 · N8511B · Substantial damage

Back to Cessna 172