NTSB investigations: Cessna 172, VA

9 cases on aircraft the registry lists as Cessna 172. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Cessna 172, VA per year, 1965–2026: 9 cases
1965	1
1969	1
1970	1
1973	2
1974	1
1976	1
1981	1
2003	1

Where

Open the map

Latest cases

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'VA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 IAD03LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesapeake, VAThe pilot's failure to adequately remove snow and ice from the airplane's wings prior to takeoff.Jan 18, 2003 · N6312E · Substantial damage NTSB ATL81FID11Accident · Serious injuriesClosedCessna 172 · Chesapeake, VAFeb 15, 1981 · N9133B · Destroyed NTSB IAD76FID27Accident · Serious injuriesClosedCessna 172 · Suffolk, VAMay 31, 1976 · N5917A · Substantial damage NTSB IAD74FIA13Accident · No injuriesClosedCessna 172M · Luray, VAApr 28, 1974 · N12195 · Substantial damage NTSB IAD74DIJ05Accident · No injuriesClosedCessna 172 · Austinville, VASep 10, 1973 · N7405A · Substantial damage NTSB NYC73FIA12Accident · No injuriesClosedCessna 172 · Richardsville, VAFeb 21, 1973 · N5149A · Destroyed NTSB IAD70FID13Accident · No injuriesClosedCessna 172 · Gordonsville, VAMar 8, 1970 · N8342B · Substantial damage NTSB IAD70F0112Accident · Serious injuriesClosedCessna 172 · Surry, VANov 1, 1969 · N6325E · Destroyed NTSB NYC65F0172Accident · No injuriesClosedCessna 172 · New London, VAApr 23, 1965 · N7114A · Substantial damage