NTSB investigations: Cessna 305A
5 cases on aircraft the registry lists as Cessna 305A, where the first occurrence was “Loss of engine power”. 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 |
|---|---|
| 1986 | 2 |
| 1988 | 1 |
| 1996 | 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\" = 350))
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" = 350))
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 IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.NTSB MIA88FA269Accident · 1 fatalField investigationFinal reportCessna 305A · Tampa, FLPlt experienced complete loss of engine power while climbing through 200 ft. the aircraft stalled and mushed, descending out of control and crashing to the ground. The engine was operated to full power after the accident. The cause of the loss of engine power…NTSB FTW87LA030Accident · No injuriesLimited investigationFinal reportCessna 305A · Mason, TXPrivate pilot of Cessna 305A ferrying aircraft from glascow, MT. To mc allen TX. Engine failed approximately 1 1/2 hours after departure from graham TX. Pilot attempted downwind landing on farm-to-market road and struck tree. Aircraft was destroyed. Pilot and…NTSB NYC86LA065Accident · No injuriesLimited investigationFinal reportCessna 305-L-19 · Hilltown, PAThe Cessna was towing a glider when at an altitude of about 150 feet to about 200 feet, a decrease in RPM was experienced. The glider was detached from the aircraft, the nose was lowered and a left turn made while still over the gliderport. A rapid descent…NTSB NYC84FHJ02Accident · No injuriesFinal reportCessna 305A · East Moriches, NYAt the completion of a banner tow flt the banner was released and a climbing right turn to downwind was initiated. A loss of power was experienced on downwind. Unable to return to the arpt to land, a forced landing was made in a wooded area. Investigators…