NTSB investigations: Cessna 172N, UT
6 cases on aircraft the registry lists as Cessna 172N, where the first occurrence was “Loss of control - on ground/water”. 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 |
|---|---|
| 1988 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2004 | 1 |
Where
Latest 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\" = 'UT' 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')
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\" = 260))
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" = 'UT' 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')
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" = 260))
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 DEN04LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Hurricane, UTthe student pilot's failure to maintain aircraft control during the landing. Contributing factors include the crosswind, the wind gusts, and the exceeded maximum demonstrated crosswind component.NTSB DEN99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · West Jordan, UTThe pilot's failure to maintain directional control of the aircraft. Factors were his lack of recent flight experience, and his lack of experience in the make and model of aircraft.NTSB SEA97LA060Accident · No injuriesLimited investigationFinal reportCessna 172N · Delta, UTThe pilot's failure to adequately compensate for the prevailing wind conditions, and his subsequent failure to maintain directional control during the landing roll. Factors contributing to the accident are a sudden shift in the prevailing wind at the time of…NTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.NTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…NTSB DEN82DA026Accident · No injuriesFinal reportCessna 172 · Bryce Canyon, UTAfter arriving from a cross-country flight, the pilot landed on an icy runway with calm wind conditions. During ground roll, the aircraft began sliding to the left. The left wheel hit snow and pulled the aircraft further left. The pilot applied right rudder…