NTSB investigations: Cessna 172L, ID
9 cases on aircraft the registry lists as Cessna 172L. 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
| 1973 | 1 |
|---|---|
| 1977 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2006 | 1 |
| 2020 | 1 |
| 2023 | 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\" = 'ID' 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 ('2072432'))
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" = 'ID' 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 ('2072432'))
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 WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR20CA095Accident · No injuriesData collectionFinal reportCessna 172 · Dubois, IDThe student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…NTSB SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.NTSB SEA98LA121Accident · No injuriesLimited investigationFinal reportCessna 172L · Lapwai, IDThe pilot's inadequate preflight planning or preparation from unsuitable terrain. Factors include an embedded railroad tie in the takeoff path, and high vegetation..NTSB SEA95LA135Accident · No injuriesLimited investigationFinal reportCessna 172L · Stanley, IDThe pilot's failure to use all available runway, his improper use of flaps, and his failure to maintain airspeed. A factor contributing to the accident is high density altitude.NTSB SEA92FA109Accident · 1 fatalField investigationFinal reportCessna 172L · Colburn, IDThe pilot became lost/disoriented, failed to maintain airspeed when he attempted to reverse course in a box canyon, and the aircraft stalled. Factors relating to the accident were the narrow box canyon, the high density altitude, and the lack of mountain…NTSB SEA86LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Emmett, IDWhile landing in calm wind conditions on a 2400 ft rwy, the left brake failed & the acft contd off the departure end, then hit a fence. An exam revealed the left brake pads were worn & the left actuator cylinder was losing fluid. The brake backing plate & the…NTSB SEA77DYA33Accident · No injuriesClosedCessna 172 · Challis, IDNTSB DEN74AD007Accident · 1 fatalClosedCessna 172L · Preston, ID