NTSB investigations: Cessna 172M
43 cases on aircraft the registry lists as Cessna 172M, 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 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2006 | 2 |
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 ('2072418')
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 ('2072418')
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 SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…NTSB IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.NTSB NYC04CA072Accident · No injuriesData collectionFinal reportCessna 172 · West Dover, VTThe pilot's failure to maintain aircraft control, and his failure to perform a go-around. Factors were wind gusts and the pilot's lack of flight experience.NTSB ATL03LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hendersonville, NCThe pilot's inadequate evaluation of the weather. The downdraft was a contributing factor.NTSB FTW03LA056Accident · No injuriesLimited investigationFinal reportCessna 172M · Vici, OKThe pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing.NTSB ANC00LA111Accident · No injuriesLimited investigationFinal reportCessna 172 · Alexander Creek, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were gusty winds, and a downdraft.NTSB MIA00LA187Accident · No injuriesLimited investigationFinal reportCessna 172M · Davis, NCThe pilot's inadequate compensation for wind. The crosswind was a contributing factor.NTSB IAD98FA072Accident · 1 fatalField investigationFinal reportCessna 172M · Hebron, CTThe pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…NTSB ANC98FA048Accident · 2 fatalField investigationFinal reportCessna 172M · Palmer, AKThe pilot's intentional flight into known adverse weather conditions. Contributing factors were the terrain induced turbulence, clouds, the pilot's overconfidence in his abilities, and mountainous terrain conditions.NTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.NTSB SEA94LA133Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Lookout Pass, IDPoor in-flight planning. Factors include cloudy weather.NTSB DEN93FA097Accident · 1 fatalField investigationFinal reportCessna 172M · Clines Corners, NMThe pilot's failure to maintain a safe and proper altitude. Factors were the pilot's failure to obtain a preflight weather briefing, dark night condition, and weather conditions that included obscuration, fog, and drizzle.NTSB FTW93FA128Accident · 2 fatalField investigationFinal reportCessna 172M · Hobart, OKInadvertent stall. Factors were the instructor pilot's spatial disorientation, his lack of total instrument time, the weather, and the dark night conditions.NTSB BFO93LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lewisburg, OHThe pilot experienced spatial disorientation. Contributing to the accident was the dark night and inadvertent flight into instrument meteorological conditions.NTSB FTW93FA039Accident · 1 fatalField investigationFinal reportCessna 172M · Snook, TXThe pilot's intentional flight into instrument meteorological conditions as a result of his alcoholic and drug impairment of efficiency and judgement. Factors contributing to the accident were: the pilot's failure to obtain weather information, the dark night…NTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.NTSB FTW92LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Springer, NMThe pilot's poor judgement in attempting flight into forcasted adverse weather, his disregard for the hazardous weather advisory received which resulted in partial loss of engine power as a result of a blocked induction system due to ice and snow, and the…NTSB DEN90LA079Accident · No injuriesLimited investigationFinal reportCessna 172M · Colorado Spring, COThe pilot's decision to initiate flight into known adverse weather, and his in-flight planning/decison. Factors related to the accident were: the adverse weather conditions, and the accumulation of airframe ice.NTSB SEA90FA133Accident · 1 fatalField investigationFinal reportCessna 172M · Snoqualmie, WAIntentional flight into known adverse weather conditions and poor weather evaluation by the pilot.NTSB MIA89LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Okeechobee, FLThe pilot's poor preflight preparation when he failed to recheck weather conditions after he delayed takeoff because of thunderstroms. Also, the pilot's poor inflight decision to land off-airport rather than return to the departure airport.NTSB MIA89FA109Accident · 2 fatalField investigationFinal reportCessna 172M · Pascagoula, MSContinued flight by the pilot into instrument meteorological conditions (IMC). Contributing factors were: inadequate preflight planning, weather conditions, pilot's lack of instrument flight time, lack of visual cues at night, and trees at the crash site.NTSB LAX89FA091Accident · 1 fatalField investigationFinal reportCessna 172M · Oxnard, CAContinued VFR flight by the pilot into instrument meteorlogical conditions which resulted in an in-flight collsion with terrain. Related factors were: failure of the pilot to use a preflight briefing service, his decision to initiate flight into known adverse…NTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…NTSB FTW88FA084Accident · 1 fatalField investigationFinal reportCessna 172M · Hope, ARThe non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…NTSB DEN88FA071Accident · 3 fatalField investigationFinal reportCessna 172M · Red Lodge, MTThe plt and two pax were returning to twin falls, id from billings, MT. The plt rec two wx briefings prior to dep. The wx forecast indicated low clouds, snow, turb and icing cond along the intended route of flight. The route of flight required the plt to…NTSB MIA87LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar Key, FLThe plt was attempting to go around after landing fast, due to a tail wind that was stronger that anticipated. Unable to climb, the acft was then blown off the rwy, collided with trees, & came to rest in the gulf of Mexico.NTSB LAX87LA092Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakdale, CADuring a solo instructional flight the student pilot was practicing touch and go landings. Upon take-off on runway 28, the wind was light from 100 degrees. On the first landing the wind had changed to a right cross wind from the north. The pilot compensated…NTSB SEA86LA244Accident · No injuriesLimited investigationFinal reportCessna 172 M · Red'S Horse Ran, ORThe pilot was attempting to depart an airstrip with a strong tail wind. 10 to 20 feet AGL the aircraft descended back onto the ground to the right of the airstrip, bounced, rolled through a wire fence and onto soft muddy terrain. The nose wheel dug into the…NTSB LAX86LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CABefore takeoff, the plt tuned in the hayward ATIS & received information alpha, which rprtd the wx was: 2200' scattered,3000' overcast & visibility 8 mi. After taking off from rwy 28R, the plt climbed to about 650' & made a rgt turn. At about that time, the…NTSB ATL86LLQ01Accident · Minor injuriesFinal reportCessna 172 · London, KYThe acft crashed during a forced landing after fuel exhaustion during a x-country flt. The plt had encountered wx and in attempting to reach an alternate arpt the acft ran out of fuel. The plt was not instrument rated and the wx at London was 600 ft overcast…NTSB ANC85FA138Accident · 4 fatalField investigationFinal reportCessna 172M · Red Devil, AKShortly after the plt took off on a ngt flt to bethel, the acft crashed just north of the east/west rwy in a nose down attitude & on a southwesterly heading. The acft was destroyed during impact, but contd sliding aprx 35 yds to the north edge of the rwy,…NTSB MKC85LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Madison, IAThe plt stated that an inflight encounter with a gust of wind during landing resulted in a sharp loss of altitude and a bounced landing. Consequently a second gust on rollout followed by the plts loss of directional control resulted in the acft departing the…NTSB ATL85LA045Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ahoskie, NCWhile on a night VFR local area flight the pilot noticed haze obscuring the lights on the ground. He returned to the airport and activated the REIL lights, he lost sight of the lights as he entered the traffic pattern. During the left turn to base, he entered…NTSB LAX85FA048Accident · 2 fatalField investigationFinal reportCessna 172M · Lake Isabella, CAAcft departed arpt in mountain valley (elev 2,614) generally direct toward a saddle pass (elev 6,500) about 1 mi nw & on the lee side of the valley. Tops of the mountains around the valley average about 7,000 ft MSL. Flt encountered updrafts during climb…NTSB SEA85FA016Accident · 1 fatalField investigationFinal reportCessna 172M · Aberdeen, WAAcft wreckage indicates impact was nose down inverted. No evidence was found of acft failure/malfunction. Plt departed on night cross-country after an evening out with friends. Wreckage found two months later, no toxicological tests possible.NTSB LAX84LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Kelseyville, CAThe plt became disoriented while in IMC and could not locate the arpt. The ple stated that due to lights on the ground he thought that he was over the peninsula, which is an area of low terrain. He attempted a 180 deg turn after descendingto 500 ft MSL. The…NTSB FTW84FA023Accident · 3 fatalField investigationFinal reportCessna 172M · Redfield, ARAt aprx 1331 CDT, the plt entered the pine bluff fss station & requested a briefing for a VFR flt to springfield, MO. He was advised that VFR flt was not recommended. The plt returned again between 1335 & 1350 & was seen examining the wx charts. At aprx 1420,…NTSB CHI83FA089Accident · No injuriesField investigationFinal reportCessna 172 · Rockford, ILThe acft collided into the 2nd floor of a building while making an ILS approach to runway 36 at Rockford, IL. The weather was IMC. An IFR flight plan was filed. A pilot weather briefing was not given. The pilot was instrument rated. An approach was attempted…NTSB NYC83FA033Accident · Minor injuriesField investigationFinal reportCessna 172M · Williamsport, PAThe aircraft departed the airport with ice on the airframe. The pilot encountered more icing in flight and decided to return to the airport, but was unable to maintain his altitude. The aircraft collided with trees during a forced landing. The pilot had been…NTSB ATL82FA153Accident · 1 fatalField investigationFinal reportCessna 172M · Alabaster, ALAt 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…NTSB MIA82DA047Accident · No injuriesFinal reportCessna 172 · San Juan, PROn final approach the tower controller told the flight that other aircraft had reported wind shear below 800 feet. The pilot landed the aircraft and ran off the right side of the runway. The pilot reported wind gusts to 21 knots.NTSB NYC82FNA10Accident · Minor injuriesFinal reportCessna 172 · Taunton, MAThe student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported…