NTSB investigations: Cessna 152, MN
13 cases on aircraft the registry lists as Cessna 152, 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1999 | 2 |
| 2001 | 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\" = '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 ('2071835')
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" = '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 ('2071835')
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 CHI01LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNThe student pilot's failure to maintain directional control during the landing. Factors relating to the accident were the student pilot's lack of total experience, the icy runway, the strong crosswind, the wind gusts, and the snowbank.NTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.NTSB CHI99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elmo, MNthe student pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the snow covered, icy runway condition and the snowbank which the airplane contacted.NTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.NTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.NTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.NTSB CHI91LA065Accident · No injuriesLimited investigationFinal reportCessna 152 II · St. Cloud, MNThe student pilot's failure to maintain directional control during acceleration for takeoff.NTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.NTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.NTSB MKC89LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Hibbing, MNWhile practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing.NTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.NTSB CHI86LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Warren, MNThe pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over.NTSB CHI84LA310Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNDuring a touch & go landing the acft veered to the right, exiting the runway. The nose wheel struck a manhole cover which protruded 12 to 18 inches above the ground. The acft nosed over upon contacting the cover. The student pilot stated that he had allowed…