NTSB investigations: Cessna T337C, 1982
4 cases on aircraft the registry lists as Cessna T337C. 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
| 1969 | 3 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 2 |
| 1975 | 1 |
| 1976 | 4 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1982 | 4 |
| 1987 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2006 | 1 |
| 2013 | 1 |
| 2019 | 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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075714'))
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075714'))
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 ATL83LA048Accident · No injuriesLimited investigationFinal reportCessna T-337C · Fulton, KYThe pilot stated that a normal short field approach to runway 27, with the stall warning horn sounding occasionally and touchdown approximately 200 feet from the threshold was accomplished. He also stated that after passing the first half of the runway he…NTSB MKC82DA157Accident · No injuriesFinal reportCessna T337C · Garden City, KSDuring arrival, the pilot landed on runway 17 with a tail wind of about 10 knots. According to the pilot, the touchdown was normal, but after rolling a short distance, the aircraft began to shake and then swerved off the right side of the runway. After…NTSB DEN82DA100Accident · Minor injuriesFinal reportCessna T337C · Gunnison, CODuring takeoff, the rear engine lost power at about 600 ft AGL, and about 20 seconds later, the front engine lost power. The pilot had turned to a downwind, but had lost all power during the turn to final approach. The aircraft impacted about 1/2 mile from…NTSB NYC82FA050Accident · 1 fatalField investigationFinal reportCessna T337C · Bloomfield, CTAt 0630 & 0800 the plt received wx briefing for an IFR flt to bridgeport, CT & was advised of flt precautions for icing, low ceilings & visibilities. The flt departed at 0907. At 1118 the plt diverted to windsor locks for landing at bradley intl arpt because…