NTSB investigations: Cessna 152, 1985, MN
2 cases on aircraft the registry lists as Cessna 152. 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
| 1978 | 1 |
|---|---|
| 1979 | 6 |
| 1980 | 5 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2022 | 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 year(c.\"eventDate\") = 1985
AND 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'))
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 year(c."eventDate") = 1985
AND 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'))
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 CHI85LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPilot had dept with minimum fuel for the 60 mi x-country flt. He overflew dest by 25 mi and after correcting course ran out of fuel 2 mi short of the aprt. While landing on a country road acft veered into a ditch.NTSB CHI85LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, MNThe student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down.