NTSB investigations: Cessna 172
15 cases on aircraft the registry lists as Cessna 172, 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2005 | 2 |
| 2007 | 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 ('2072402')
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 ('2072402')
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 NYC07CA204Accident · Minor injuriesData collectionFinal reportCessna 172 · Julian, WVThe pilot's inadequate preflight planning. Contributing to the accident were the overcast cloud conditions and the pilot's failure to maintain directional control during the landing roll.NTSB LAX06LA064Accident · 4 fatalLimited investigationFinal reportCessna 172 · Gilroy, CAThe non-instrument rated pilot's poor judgment to fly in dark night instrument conditions, which resulted in his spatial disorientation and loss of aircraft control while maneuvering. Contributing factors were the dark night light condition and the low…NTSB IAD05LA028Accident · 2 fatalLimited investigationFinal reportCessna 172 · Knottsville, KYthe pilot's loss of control in flight due to spatial disorientation. Also causal to the accident was the pilot's inadequate preflight planning which resulted in his inadvertent flight into night instrument meteorological conditions.NTSB DEN01FA028Accident · 2 fatalField investigationFinal reportCessna 172 · Lusk, WYthe pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…NTSB DEN00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Tooele, UTThe pilot's failure to correct the descent, and his failure to maintain a visual lookout. Factors were the pilot's improper weather evaluation, his lack of recent experience in type of operation, his inadvertent encounter with instrument meteorological…NTSB MIA99FA150Accident · 1 fatalField investigationFinal reportCessna 172 · Fontana, NCthe pilot continued visual flight into know weather conditions which resulted in reduced visibility, and the subsequent in-flight collision with rising terrain. Factors in this accidents were clouds and low ceiling in the accident area.NTSB LAX91FA247Accident · 1 fatalField investigationFinal reportCessna C-172 · Lakeside, CAThe failure of the pilot to request radar assistance to avoid low ceilings in high terrain and the pilot's inadequate visual outlook which ultimately resulted in an inflight collision with high terrain. Contributing to the accident were the weather conditions…NTSB ATL91FA054Accident · 1 fatalField investigationFinal reportCessna 172 · Crossville, TNThe improper flight planning by the noninstrument rated pilot which resulted in his inadvertent flight into instrument meteorological conditions in mountainous terrain.NTSB LAX90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · California City, CAThe pilot's improper landing flare. A factor related to accident was the gusty wind condition.NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…NTSB LAX89FA182Accident · 3 fatalField investigationFinal reportCessna 172 · Industry, CAThe failure of the pilot to maintain an adequate altitude to ensure obstruction clearance. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's continued flight into adverse weather conditions.NTSB MIA89FA090Accident · 2 fatalField investigationFinal reportCessna 172 · Blue Mountain, MSThe continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.NTSB ATL89FA059Accident · 2 fatalField investigationFinal reportCessna 172 · Wadsworth, OHPIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…NTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…