NTSB investigations: Cessna 152, IL
9 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Hard landing”. 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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1998 | 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\" = 'IL' 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\" = 200))
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" = 'IL' 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" = 200))
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 CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.NTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.NTSB CHI90LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILImproper flare and improper recovery from a bounced landing.NTSB CHI87LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Savoy, ILA student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three…NTSB CHI86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILThe student pilot was practicing touch and go landings in preparation for a solo cross country. The pilot was compensating for a crosswind when he landed the aircraft on its nose resulting in substantial damage to the aircraft.NTSB CHI84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILThe student plt stated that when approaching over wires she 'powered up and ended up coming in too fast.' The acft made initial contact on the nose wheel. Subst damage to the eng mount area and the left wing.NTSB CHI83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILThe student plt was on a round robin, cross-country training flt. His first landing was made on rwy 4 at the greater Kankakee arpt. During touchdown in a strong cross-wind, the acft bounced, then veered off the rwy. The acft then encountered soft terrain and…NTSB CHI83LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILThe student pilot made a hard landing on his first solo flight. The aircraft bounced several times and damaged the nose landing gear. The student had made four full stop landings with an instructor pilot. Then the instructor deplaned for the student to make…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.