NTSB investigations: Cessna 305A
12 cases on aircraft the registry lists as Cessna 305A, 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 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 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 ('2074002')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074002')
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 SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.NTSB SEA04LA061Accident · No injuriesLimited investigationFinal reportCessna 305A · Bozeman, MTThe pilot's failure to maintain directional control during the landing roll in the tail wheel-equipped aircraft, leading to an inadvertent ground-loop, during which the aircraft's wing impacted the ground.NTSB CHI03LA321Accident · No injuriesLimited investigationFinal reportCessna 305A · New Richmond, WIThe pilot's inadequate compensation for wind and his failure to maintain directional control. The pilot's in-flight selection of the wrong runway and excessive application of brake pressure are contributing factors.NTSB LAX01LA128Accident · No injuriesLimited investigationFinal reportCessna 305A · Winslow, AZThe student's inadvertent restriction of the rudder pedal's movement during landing rollout precipitated the loss of directional control and ground loop. A finding was that remedial action by the CFI was not possible due to the student’s control interference.NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB LAX99LA118Accident · No injuriesLimited investigationFinal reportCessna 305A · Coalinga, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane.NTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.NTSB DEN93LA082Accident · No injuriesLimited investigationFinal reportCessna 305A · Belen, NMFailure of the pilot in command to maintain directional control. A factor was: a quartering tailwind.NTSB CHI91LA225Accident · No injuriesLimited investigationFinal reportCessna 305A · Keokuk, IADiverted attention by the pilot resulting in directional control not being maintained. A factor related to the accident was crosswind.NTSB DEN88LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Littleton, CONTSB 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 ANC84FA192Accident · No injuriesField investigationFinal reportCessna 305A · Anchorage, AKDuring the rollout the tail wheel began to shimmy and the acft swerved to the right and ground looped. The left wing and left horizontal stabilizer contacted the ground. Investigation revealed that the tail wheel spring ass'y was oversized and not properly…