NTSB investigations: Cessna T337B
13 cases on aircraft the registry lists as Cessna T337B. 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
| 1967 | 2 |
|---|---|
| 1968 | 2 |
| 1970 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1978 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1994 | 1 |
| 2012 | 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 ('2075707'))
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 ('2075707'))
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 ERA12LA273Accident · No injuriesLimited investigationFinal reportCessna T337B · Dothan, ALThe failure of the landing gear to extend and lock, despite troubleshooting attempts using normal and emergency procedures. The reason for the failure could not be determined because the systems were unavailable for testing.NTSB MIA94WA092Accident · Serious injuriesForeign investigationCessna T-337-B · Cay Sal, BahamasNTSB ATL86FA055Accident · 2 fatalField investigationFinal reportCessna T337B · Talladega, ALThe acft collided with trees during the final approach to landing. The light conditions were dark, skies were clear and winds were calm. Prior to the accident, the plt had landed and visited the FBO from where the acft was recently purchased to correct some…NTSB FTW82FRG01Accident · No injuriesClosedCessna T337B · Port Isabel, TXNTSB LAX79FUJ05Accident · Minor injuriesClosedCessna T337B · Marana, AZNTSB LAX76O0001Accident · Serious injuriesClosedCessna T337 · Mulege, MexicoNTSB CHI75FEC38Accident · No injuriesClosedCessna T337B · Pontiac, MINTSB DEN75OD001Accident · No injuriesClosedCessna 337 · Pt Pescadores, MexicoNTSB CAN71AP907Accident · 4 fatalClosedCessna T337B · Cranbrook, CanadaNTSB MKC69F0274Accident · Minor injuriesClosedCessna 337B · Fullerton, NENTSB LAX69D0025Accident · No injuriesClosedCessna 337 · Tombstone, AZNTSB DEN68F0174Accident · Serious injuriesClosedCessna T337B · Cortez, CONTSB LAX67A0088Accident · 2 fatalClosedPiper PA-22 · Long Beach, CA