NTSB investigations: Cessna 172E, VA
13 cases on aircraft the registry lists as Cessna 172E. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1969 | 1 |
| 1973 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1979 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2007 | 1 |
| 2019 | 1 |
| 2024 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072412'))
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 ('2072412'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA24LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Ridgeway, VAThe pilot's failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA19TA098Accident · Minor injuriesClass 3Final reportCessna 172 · Lignum, VAA total loss of engine power for undetermined reasons.NTSB NYC07LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leesburg, VAThe loss of engine power that resulted from the failure of an exhaust valve rocker arm during cruise.NTSB NYC98FA020Accident · 1 fatalField investigationFinal reportCessna 172E · Elkton, VAThe pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..NTSB IAD96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Roanoke, VAthe pilot's misjudged estimation of the airplane's fuel supply for the flight. Related factors are the inadequate preflight inspection, the pilot's expectation that the airplane had been topped off, and the soft terrain encountered during the forced landing.NTSB BFO93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Manassas, VAThe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB IAD79FIA07Accident · No injuriesClosedCessna 172 · Front Royal, VANTSB IAD77FID27Accident · No injuriesClosedCessna R172E · Powhatan, VANTSB IAD76FIJ14Accident · No injuriesClosedCessna 172F · Elk Creek, VANTSB IAD76FID21Accident · No injuriesClosedCessna 172 · Chesterfield, VANTSB IAD74DID11Accident · No injuriesClosedCessna 172E · Fort Eustis, VANTSB DIA69D0186Accident · No injuriesClosedCessna 172E · Lorne, VANTSB UNK65X1031Accident · No injuriesClosedCessna 172 · Middleburg, VA