NTSB investigations: Cessna 172L, WI

16 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19722026

NTSB investigations: Cessna 172L, WI per year, 1972–2026: 16 cases
1972	1
1973	2
1974	3
1977	3
1978	1
1980	1
1988	1
1996	1
2001	1
2004	1
2022	1

Where

Open the map

Latest cases

Query with SQL

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 ('2072432')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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" = '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 ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.Jan 3, 2022 · N4209Q · Substantial damage NTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.Aug 12, 2004 · N3599F · Destroyed NTSB CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…Dec 9, 2001 · N4303Q · Substantial damage NTSB CHI96LA354Accident · No injuriesLimited investigationFinal reportCessna 172L · Delavan, WIthe pilot's failure to assure the airplane was properly secured prior to hand-propping the engine.Sep 29, 1996 · N7216Q · Substantial damage NTSB CHI88DEP04Accident · No injuriesFinal reportCessna 172L · West Bend, WIAfter 30 minutes of local flight, on a dark night, the pilot increased the throttle setting after selecting approach flaps. There was no response from the engine. A forced landing was initiated and the aircraft collided with trees and terrain. A subsequent…Mar 6, 1988 · N7089Q · Substantial damage NTSB CHI81FA005Accident · 1 fatalClosedCessna 172 · Westfield, WINov 2, 1980 · N7686G · Destroyed NTSB CHI78FEP11Accident · No injuriesClosedCessna 172L · Waukesha, WIJan 15, 1978 · N7699G · Substantial damage NTSB CHI78FEP04Accident · Minor injuriesClosedCessna 172M · Elkhorn, WIOct 17, 1977 · N20011 · Destroyed NTSB CHI77FEP61Accident · No injuriesClosedCessna 172L · West Bend, WISep 18, 1977 · N1TA · Substantial damage NTSB CHI77FEP29Accident · Minor injuriesClosedCessna 172 · Janesville, WIMar 25, 1977 · N4352Q · Substantial damage NTSB CHI75DEP30Accident · No injuriesClosedCessna 172L · Crivitz, WIOct 13, 1974 · N19644 · Substantial damage NTSB CHI75DEP02Accident · No injuriesClosedCessna 172 · Summit Lake, WIJul 21, 1974 · N4225Q · Substantial damage NTSB CHI74DEP33Accident · No injuriesClosedCessna 172 · Burlington, WIFeb 24, 1974 · N1144M · Substantial damage NTSB CHI74DEP25Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 29, 1973 · N3907Q · Substantial damage NTSB CHI73AC092Accident · 1 fatalClosedCessna 172L · Crivitz, WIMay 26, 1973 · N7656G · Destroyed NTSB CHI73FEP31Accident · Minor injuriesClosedCessna 172L · Antigo, WINov 8, 1972 · N7662G · Substantial damage