NTSB investigations: Cessna 337A, FL
8 cases on aircraft the registry lists as Cessna 337A. 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
| 1973 | 2 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 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\" = 'FL' 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 ('2075704'))
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" = 'FL' 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 ('2075704'))
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 MIA86LA086Accident · No injuriesLimited investigationFinal reportCessna 337A · Key Biscayne, FLThe acft had been flown for aprx 7 hrs and 15 mins during a flt from curacao, netherlands antilles. Nearing miami, both engs failed within a short time of each other and the plt performed a night ditching. The acft was not equipped with aux fuel tanks. The…NTSB MIA85LAMS2Accident · 4 fatalFinal reportCessna 337 · Atlantic Ocean, FLThe acft was reported missing and search & rescue control center initiated a search on 1-17-85. The search was suspendedon 1-24-85. The last reported position of the acft was 66 miles northeast of jacksonville, FL. The acft is still missing & the damage index…NTSB MIA82DA134Accident · Serious injuriesFinal reportCessna 337 · Near Stuart, FLThe pilot made an uneventful flight from gainsville to sebring, FL where 3 passengers were deplaned. He then departed on a VFR flight to freeport on the grand bahama island. The pilot stated the he had proceeded about 30 miles east of the Florida coast when…NTSB MIA79FLO65Accident · Minor injuriesClosedCessna 337 · Kissimmee, FLNTSB MIA76DKT63Accident · No injuriesClosedCessna 337A · W Palm Beach, FLNTSB MIA76FLD30Accident · Minor injuriesClosedCessna 337 · Titusville, FLNTSB MIA74AM044Accident · 1 fatalClosedCessna 337 · Ft Lauderdale, FLNTSB MIA73FLA42Accident · No injuriesClosedCessna 337 · Gainesville, FL