NTSB investigations: Cessna 172N, NE
14 cases on aircraft the registry lists as Cessna 172N. 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2016 | 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\" = 'NE' 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 ('2072434'))
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" = 'NE' 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 ('2072434'))
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 CEN16FA073Accident · 1 fatalField investigationFinal reportCessna 172N · Wayne, NEThe noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.NTSB CHI02LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, NEThe pilot not maintaining sufficient airspeed during the takeoff, and the inadvertent stall encountered by the pilot. The low altitude was a factor.NTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB CHI94LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the pilot's lack of total flight experience.NTSB CHI91DCJ01Accident · 1 fatalFinal reportCessna 172N · Western, NESpatial disorientation which resulted in a loss of aircraft control. A factor related to the accident was VFR flight into IMC.NTSB MKC89FA197Accident · Serious injuriesField investigationFinal reportCessna 172N · Hyannis, NEFailure of the pilot to maintain sufficient altitude. Darkness and adverse weather conditions were related factors.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 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 MKC85LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Curtis, NEThe plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing…NTSB MKC83LA156Accident · No injuriesLimited investigationFinal reportCessna 172 · Superior, NEThe plt stated he touched down on the right wheel, rolled on the rwy and became airborne again with the acft banked to the right. He applied power and the engine went to high RPM. The acft swung right almost 180 degrees before touching down off the rwy to the…NTSB MKC83LA047Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearney, NEPilot landed on icy runway and started to swerve. Go-around was initiated. Before aircraft could takeoff it collided with a snow bank.NTSB MKC82DA152Accident · Minor injuriesFinal reportCessna 172 · Thedford, NEThe pilot reported that after he took off on a dark night, he remembered there were obstacles in that area and he reversed his direction of turn. He stated that after reversing the turn, he became disoriented and the aircraft dove into the ground.NTSB MKC79DCJ25Accident · Minor injuriesClosedCessna 172 · Omaha, NENTSB MKC79FCJ04Accident · 1 fatalClosedCessna 172 · Oshkosh, NE