NTSB investigations: Cessna 172, WI
18 cases on aircraft the registry lists as Cessna 172. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 2013 | 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\" = 'WI' 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 ('2072402'))
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" = 'WI' 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 ('2072402'))
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 CEN13LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonewoc, WIThe restricted vented fuel cap and obstructed fuel vent lines, which resulted in a total loss of engine power due to fuel starvation.NTSB CHI91LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Neosho, WIThe pilot's failure to properly flare the airplane and an improper recovery from a bounced landing.NTSB CHI88LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Neillsville, WINTSB CHI79FEP22Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WINTSB CHI79DEP14Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WINTSB CHI78FEP30Accident · No injuriesClosedCessna 172 · Middleton, WINTSB CHI77FEP47Accident · Serious injuriesClosedCessna 172 · Lake Geneva, WINTSB CHI74DEP30Accident · No injuriesClosedCessna 172 · Stevens Point, WINTSB CHI73DEP26Accident · No injuriesClosedCessna 172 · Michicot, WINTSB CHI72FEP25Accident · No injuriesClosedCessna 172 · Delavan, WINTSB CHI69A0040Accident · 4 fatalClosedCessna 172 · Platteville, WINTSB CHI68A0048Accident · No injuriesClosedCessna 172 · Palmyra, WINTSB CHI67D0499Accident · No injuriesClosedCessna 172 · Watertown, WINTSB CHI67D0184Accident · No injuriesClosedCessna 172 · Milwaukee, WINTSB CHI67D0080Accident · No injuriesClosedCessna 172 · Richland Cntr, WINTSB CHI66D0777Accident · Minor injuriesClosedCessna 172 · Middleton, WINTSB CHI66F0435Accident · Minor injuriesClosedCessna 172 · Lake Geneva, WINTSB UNK65X1055Accident · Minor injuriesClosedCessna 172 · St Nazianz, WI