NTSB investigations: Cessna 172L, MN
11 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
| 1970 | 1 |
|---|---|
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2002 | 1 |
| 2006 | 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\" = 'MN' 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" = 'MN' 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 CHI07FA032Accident · 2 fatalField investigationFinal reportCessna 172 · Crookston, MNThe pilot's inadvertent flight into instrument meteorological conditions which led to his spatial disorientation and subsequent loss of control. Factors were the snow, the low ceiling, and the pilot's lack of instrument flight experience.NTSB CHI03LA005Accident · No injuriesLimited investigationFinal reportCessna 172L · Fish Lake, MNThe altitude/clearance not maintained while maneuvering on short final for landing on the lake. The glassy water was a contributing factor.NTSB CHI90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Graceton, MNVso airspeed not maintained and stall encountered by the pilot in command/cfi.NTSB CHI88LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Buffalo, MNNTSB CHI87LA224Accident · No injuriesLimited investigationFinal reportCessna 172L · Lakeville, MNAircraft landed hard, nose wheel first, and collapsed the nose landing gear tire. PIC was concerned about a sharp knocking noise in the rear of the aircraft that he heard after liftoff. The reason for the noise was not determined. He acknowledged that he…NTSB MKC78FER33Accident · No injuriesClosedCessna 172 · Thief Riv Fall, MNNTSB MKC78FER14Accident · No injuriesClosedCessna 172L · Minneapolis, MNNTSB MKC75DER57Accident · No injuriesClosedCessna 172 · Pine River, MNNTSB MKC75DER45Accident · No injuriesClosedCessna 172 · Eden Prairie, MNNTSB MKC74DER41Accident · No injuriesClosedCessna 172 · Ely, MNNTSB MKC71FDM34Accident · No injuriesClosedCessna 172L · Minneapolis, MN