NTSB investigations: Cessna 305A, MA
5 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1990 | 1 |
| 2004 | 1 |
| 2024 | 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\" = 'MA' 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 ('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 c."eventStateOrRegion" = 'MA' 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 ('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 ERA24LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Sterling, MAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and subsequent landing gear collapse. Contributing was the flight instructor’s delayed remedial action.NTSB NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.NTSB NYC90LA155Accident · No injuriesLimited investigationFinal reportCessna 305A · Newburyport, MAFailure of the pilot in command to follow procedures for landing with a banner still attached, contributing to the accident was the improper modification of banner release mechanism.NTSB NYC80FA079Accident · No injuriesClosedCessna 305 · Newburyport, MANTSB NYC79FNA24Accident · No injuriesClosedCessna 305A · Quincy, MA