Final NTSB investigations: Canadair T-33
6 cases on aircraft the registry lists as Canadair T-33. 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
| 1979 | 1 |
|---|---|
| 1984 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2003 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1901204'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1901204'))
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 LAX04LA034Accident · 1 fatalLimited investigationFinal reportCanadair T33 · Santa Clarita, CAthe pilot's failure to maintain adequate clearance from terrain during low altitude maneuvers.NTSB MIA96LA228Accident · Minor injuriesLimited investigationFinal reportCanadair T-33 · Punta Gorda, FLfailure of the pilot to extend the wing flaps for takeoff, and his failure to attain sufficient airspeed for flight with the flaps retracted, which resulted in a stall/mush after lift-off.NTSB CHI94LA195Accident · 1 fatalLimited investigationFinal reportCanadair T-33 · Mount Clemens, MIThe pilot's failure to maintain clearance from terrain during an aerobatic maneuver. His improper execution of the maneuver was a factor.NTSB DEN90FA104Accident · 2 fatalField investigationFinal reportCanadair CT-133 · Roswell, NMThe pilot-in-command's performance of aerobatic maneuvers that exceeded the design stress limits of the aircraft, resulting in catastrophic failure of the wing.NTSB LAX84LA502Accident · No injuriesLimited investigationFinal reportCanadair T-33 · Palm Springs, CAThe plt stated that 'as I crossed over the field boundry, landing was assured so I closed the throttle. The acft then pitched nose up (slightly), left wing dropped & acft sank out of control to touchdown on the overrun just short of the threshold.' The acft…NTSB MIA79FLD75Accident · No injuriesClosedLockheed T-33 · Sebring, FL