NTSB investigations: Cessna 172E
9 cases on aircraft the registry lists as Cessna 172E, where the first occurrence was “In flight encounter with weather”. 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
| 1986 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 2001 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…NTSB FTW98LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Watkins, COThe pilot's inadequate evaluation of the weather which resulted in an encounter with a microburst. Contributing was the airplane's climb capability exceeded by the microburst, and rising terrain.NTSB LAX95LA221Accident · No injuriesLimited investigationFinal reportCessna 172 · Yerington, NVThe pilot's improper in-flight decision to enter mountainous terrain at an insufficient altitude to safely escape adverse weather conditions. Factors relating to the accident were: the terrain and weather conditions.NTSB BFO95LA059Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncy Valley, PAthe non-instrument rated pilot's failure to maintain clearance from terrain after inadvertently entering instrument meteorological conditions. The weather conditions (haze and fog) were a factor in the accident.NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.NTSB BFO92LA126Accident · 1 fatalLimited investigationFinal reportCessna 172E · Tuckahoe, NJVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the light conditions at dusk (or darkness), and the pilot's lack…NTSB FTW90LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hammond, LAPilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…NTSB SEA88FA169Accident · 4 fatalField investigationFinal reportCessna 172E · Petersburg, AKPlt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.NTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…