NTSB investigations: Cessna A152
8 cases on aircraft the registry lists as Cessna A152, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071836')
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\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071836')
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" = 250))
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 LAX94LA261Accident · 2 fatalLimited investigationFinal reportCessna 152 · Half Moon Bay, CAThe pilot's loss of aircraft control due to spatial disorientation.NTSB NYC91LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookville, OHThe pilot's improper use of the flight controls resulting in loss of directional control and an inadvertent stall.NTSB LAX90FA320Accident · 2 fatalField investigationFinal reportCessna A152 · Tucson, AZFailure of the pilot to recover from a spin. Factors related to the accident were: the pilot's failure to assure there was adequate altitude to recover from an inadvertent or intentional spin, and his lack of recent expereince in the type of operation.NTSB CHI89FA151Accident · Minor injuriesField investigationFinal reportCessna A152 · Oshkosh, WIThe pilot's poor judgement, and poor evaluation of the weather due to self induced pressure and overconfidence in his personal ability. Contributing factor was the experimental aircraft association's inadequate supervision of the operation.NTSB MKC88LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Ottawa, KSThe student pilot was on a solo cross country flight. During the landing, the aircraft began to porpoise. The pilot performed remedial action, however, the aircraft had already sustained substantial damage.NTSB MKC86FCA02Accident · Serious injuriesFinal reportCessna A152 · Old Monroe, MOThe stu PIC and his instructor were practicing forced lndgs to a corn stubblefield. As they initiated a climb fm a simulated forced lndg, the acft crashed nose low, right wing low. No mech pblm was found with the flt controls or the pwrplant.NTSB MIA83FA225Accident · 1 fatalField investigationFinal reportCessna A152 · Homosassa Sprgs, FLThe acft was first observed making low passes, almost striking trees & power lines. It then continued in a steep bank through about 90 deg of turn, rolled inverted & pitched down simultaneously. The acft impacted the ground in the parkinglot of a convenience…NTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.