NTSB investigations: Cessna 172N
72 cases on aircraft the registry lists as Cessna 172N, 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 | 12 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 3 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 4 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 1 |
| 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 ('2072434')
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 ('2072434')
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 SEA07CA183Accident · No injuriesData collectionFinal reportCessna 172N · Greenwater, WAThe in-flight encounter with a sudden windshift during the takeoff initial climb, to which the certified flight instructor responded by aborting the takeoff and landing off the end of the runway. The ditch was a contributing factor.NTSB ANC05FA037Accident · 1 fatalField investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed during an abrupt maneuver to avoid a power line, which resulted in an inadvertent stall, a loss of control, and subsequent collision…NTSB NYC05LA033Accident · 3 fatalLimited investigationFinal reportCessna 172N · Mount Gilead, OHThe pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.NTSB NYC05FA001Accident · 2 fatalField investigationFinal reportCessna 172N · Germantown, NYThe pilot's inadequate in-flight planning/decision which led to VFR flight into IMC and his loss of aircraft control. Factors were night and cloud conditions.NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.NTSB SEA04LA038Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Rigby, IDThe flight instructor's failure to follow procedures, i.e., operating the non-icing certified aircraft in known icing conditions contrary to the pilot operators handbook which resulted in ice accretion and ultimately a stall and loss of control in flight.…NTSB CHI03FA086Accident · 3 fatalField investigationFinal reportCessna 172N · Foley, MNThe pilot's continued visual flight into instrument meteorological conditions which led to spatial disorientation and subsequent impact with the ground. Contributing factors was the pilot's lack of instrument rating, the pilot's disregard of the preflight…NTSB CHI03FA071Accident · 1 fatalField investigationFinal reportCessna 172N · Wellington, KSSpatial disorientation experienced by the pilot and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing prior to the return flight, his attempted flight into…NTSB LAX03FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Kalaupapa, HIthe student pilot's inadvertent VFR flight into IMC, which resulted in his in-flight collision with mountainous terrain while maneuvering. A contributing factor was the low ceiling weather condition.NTSB LAX01FA134Accident · 2 fatalField investigationFinal reportCessna 172N · Rialto, CAThe pilot's intentional visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation and lack of total experience.NTSB ANC00FA076Accident · 1 fatalField investigationFinal reportCessna 172N · Tuntutuliak, AKThe pilot's disregard of the existing wind conditions, and an inadvertent stall. Factors associated with the accident are a tailwind, and wind gusts.NTSB MIA00LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Defuniak Spgs, FLWas the pilot's failure to obtain a proper weather briefing resulting in his encounter with fog, his having to make a precautionary landing in a field when the aircraft became low on fuel, and the on ground collision with trees during landing roll.NTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.NTSB FTW99FA033Accident · 2 fatalField investigationFinal reportCessna 172N · Bacliff, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions and his inability to maintain adequate altitude/clearance from the wire. Contributing to the accident were the fog, low ceilings and his lack of instrument time.NTSB ATL99LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lima, SCThe flight instructor's intentional flight into Instrument Meteorological Conditions. Factors were trees and mountainous terrain.NTSB SEA98LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from terrain. Clouds and mountainous terrain were a factor.NTSB LAX98FA052Accident · 2 fatalField investigationFinal reportCessna 172N · Lytle Creek, CAthe non-instrument rated pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the adverse weather conditions (low ceiling…NTSB MIA96LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryceville, FLThe pilot's improper planning/decision. Factors relating to the accident were: the pilot's inaccurate evaluation of the weather conditions, the pilot becoming lost/disoriented, and the lack of braking action on wet grass during the precautionary landing.NTSB CHI96LA039Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Stevens Point, WIflying into known icing conditions and descending below the minimum descent altitude.NTSB CHI95LA195Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNThe pilot's improper inflight planning/decision, which resulted in continued flight into adverse weather. Factors relating to the accident were: the thunderstorm outflow, and inadequate weather evaluation by the pilot.NTSB ATL95FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Atlanta, GAThe pilot's impairment of judgment and performance due to a drug, VFR flight into instrument meteorological conditions, and failure to remain clear of the obstacle (towering smoke stack). Factors relating to the accident were: the adverse weather conditions.NTSB SEA95FA018Accident · 1 fatalField investigationFinal reportCessna 172N · Klamath Falls, ORThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain below him. Contributing to the accident was a downdraft.NTSB ATL95FA009Accident · 4 fatalField investigationFinal reportCessna 172N · Gerton, NCThe pilot's inadequate weather evaluation and his intentional visual flight into IMC.NTSB NYC94FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Trout Run, PAthe delayed decision of the pilot to deviate from known weather which resulted in an inflight loss of control and impact with terrain.NTSB ATL94LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Hartford, ALThe student pilot's inadequate compensation for gusting wind conditions during the approach to land. Factors were the instructor pilot's inadequate supervision of his student, the gusting wind conditions, and the trees located in close proximity to the runway.NTSB LAX94FA185Accident · 1 fatalField investigationFinal reportCessna 172N · Julian, CAImproper planning/decision by the pilot(s). Factors related to the accident were: the high/mountainous terrain and adverse weather conditions.NTSB SEA93FA179Accident · 1 fatalField investigationFinal reportCessna 172N · Lake Fork, IDPoor judgment of the pilot by flying while under the influence of alcohol and a drug, his continued flight into an area of adverse weather, and his failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors related to the accident…NTSB LAX93FA223Accident · 2 fatalField investigationFinal reportCessna 172N · Lompoc, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude (or clearance) from mountainous terrain. Factors relating to the accident were: the low ceiling, fog, drizzle, obscuration, and mountainous…NTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…NTSB CHI91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sheboygan, WIThe pilot's failure to maintain aircraft control. Factors are the pilot's lack of total expereince, his inadequate recovery from the bounced landing and the crosswind condition.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.NTSB LAX90FA180Accident · 2 fatalField investigationFinal reportCessna 172N · Salinas, CAThe pilot's failure to maintain clearance with terrain while attempting visual flight in instrument meteorological conditions. Self induced pressure to adhere to the proposed flight route in instrument meteorological conditions was a factor.NTSB ATL90LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ocilla, GAThe aircraft's encounter with low level windshear resulting in an uncontrollable descent.NTSB NYC90FA041Accident · 3 fatalField investigationFinal reportCessna 172N · Washington Twp, NJThe failure of the pilot to properly pre-flight plan and execute the VFR flight. Factor's related to the accident were: the pilot's inexperience; no visual cues (lights) due to dark night conditions; the pilot's disregard of the weather briefing.NTSB ATL90FA008Accident · 2 fatalField investigationFinal reportCessna 172N · Eddyville, KYThe pilot continuing VFR flight into adverse weather conditions. Contributing factor(s) was: low ceiling and rain.NTSB DEN89FA222Accident · 2 fatalField investigationFinal reportCessna 172N · Afton, WYThe non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB MKC89LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wentzville, MOThe pilot's delay in aborting the landing, and his failure to maintain clearance from the power lines. Factors related to the accident were: the pilot's selection of the wrong runway, the adverse weather conditions, the pilot's failure to attain the proper…NTSB ATL89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Xenia, OHThe pilot's improper in-flight planning/decision and improper use of the flaps. Contributing was the downdraft.NTSB MKC89LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Ainsworth, NEThe loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.NTSB LAX89FA022Accident · 2 fatalField investigationFinal reportCessna 172N · Petaluma, CAPilot used poor judgement when he attempted v.f.r. flight during instrument meteorological conditions and that he encountered spatial disorientation when he entered into the clouds.NTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.NTSB ATL88FA043Accident · 1 fatalField investigationFinal reportCessna 172N · Blanchester, OHThe aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the…NTSB CHI87DEX03Accident · 3 fatalFinal reportCessna 172N · Raymond, OHThe accident aircraft impacted in an open field shortly after a predawn departure from an unattended airport. IMC prevailed an no flight plan was in effect. In a conversaton held the day before with a local pilot the pilot of the accident aircraft stated his…NTSB NYC87FA011Accident · 1 fatalField investigationFinal reportCessna 172 · Croton On Hud., NYStudent pilot advised by millville fss that VFR flight not recommended due to current and forecast IFR conditions throughout route of flight. Acft observed flying near base of low clouds and in and out of clouds prior to crashing in a residential area.NTSB SEA87LA002Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Roseburg, ORThe plt initiated the takeoff from a taxiway with a 100 ft obscured sky and 1/4 visibility in fog. The non-instrument rated plt was unable to maintain the rwy heading during initial climb. The acft drifted to the right of the taxiway and struck trees located…NTSB MKC86LA182Accident · No injuriesLimited investigationFinal reportCessna 172 · Hayes Center, NEWhile en route, the plt encountered deteriorating wx conditions. He stated that he found himself above an overcast with visibilities decreasing. He saw a hole in the cloud layer and descended thru it. He stated that wx conditions were bad below the cloud…NTSB LAX86LA210Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearlake, CAThe flt instructor (CFI) said he was instructing the student in how to judge a straight-in approach and landing to a dock with minimal taxiing required. During the approach, the CFI determined that the student was overshooting the desired touchdown point, so…NTSB SEA86LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Pioche, NVWhile on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet…NTSB DEN86LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Logan, UTThe plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…