NTSB investigations: Cessna 305A, 1985
6 cases on aircraft the registry lists as Cessna 305A. 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
| 1964 | 2 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 2 |
| 1972 | 7 |
| 1973 | 10 |
| 1974 | 7 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 4 |
| 1979 | 7 |
| 1980 | 5 |
| 1982 | 3 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 2 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074002'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074002'))
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 ATL86LA004Accident · No injuriesLimited investigationFinal reportCessna 305A(0-1A) · Marietta, GAAircraft was on touch and go landing. Pilot allowed aircraft to become airborne prematurely. Flaps were not raised during go around and pilot stated he lost it. Aircraft veered to left after initial lift off for go around touched down repeatedly,with second…NTSB FTW85LA333Accident · Serious injuriesLimited investigationFinal reportCessna 305A · League City, TXThe plt, while setting up for an aerial banner tow pick up, failed to properly divide his attention between his flt duties and observing another acft which was also in the traffic pattern. He allowed the acft to stall without sufficientalt to recover before…NTSB NYC85FA213Accident · 1 fatalField investigationFinal reportCessna C-305A · Brooklyn, NYDuring an aerial banner tow operation at low level along the beach, witnesses observed the airplane bank sharply to the right and dive into the water. Witnesses recall the engine noise to have been loud yet sputtering before the impact. Inspection of the…NTSB ATL85LA152Accident · No injuriesLimited investigationFinal reportCessna 305A · No.Myrtle Bch, SCAfter a banner pickup the plt was instructed by company group and crew to release the banner due to a fouled pickup. The banner was released during a steep climb out altitude. As the banner was released the plt lost directional control of the acft & crashed…NTSB NYC85LA090Accident · No injuriesLimited investigationFinal reportCessna L-19 · Perkasie, PACessna L-19,a practice flight of takeoffs and landings for glider tow operation for philidelphia glider council encounter a wind shift on landing. The student pilot over corrected and the aircraft ground looped. The instuctor pilot at this time took control…NTSB MIA85LA119Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sugar Loaf Key, FLThe engine failed just after takeoff and the acft landed in a field north of the arpt, collided with trees and nosed over. Post accident examination of the fuel system shows that the acft micron fuel filter was contaminated to the extent that it caused…