NTSB investigations: Cessna 305A, NJ
4 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 2010 | 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\" = 'NJ' 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" = 'NJ' 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 ERA10CA304Accident · No injuriesData collectionFinal reportCessna 305A · Toms River, NJThe pilot-in-command's loss of airplane control during landing, which resulted in a ground-loop.NTSB NYC89FA074Accident · 1 fatalField investigationFinal reportCessna 305A · Blairstown, NJDelays by both pilots in releasing the glider tow line after the glider pilot allowed the glider to maneuver excessively above the tow aircraft. The weather conditions were factors.NTSB NYC88LA168Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJDuring a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…NTSB NYC83LA234Accident · No injuriesLimited investigationFinal reportCessna 305A · Seaside Heights, NJThe acft collided with a ditch during landing and nosed down. The pilot had made a low approach to pick up a banner but was unable to maintain airspeed and altitude. The banner was dropped but the acft continued to descend. The pilot flaredfor a normal…