NTSB investigations: Lycoming T-53 series, 1993
4 cases on aircraft whose registry engine model is Lycoming T-53 series. 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
| 1974 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 3 |
| 1982 | 2 |
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 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\") = 1993
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41552', '41549', '41587'))
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") = 1993
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41552', '41549', '41587'))
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 ATL94LA035Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mobile, ALAn inadequate major repair by company maintenance personnel who failed to install the cotter pin which secured the retaining nut of the right main rotor hub teeter pin.NTSB SEA93LA207Accident · No injuriesLimited investigationFinal reportBell UH-1B · Pierce, IDSeparation of the 90 degree gearbox after fatigue failure of the gearbox attach bolts. Factors include hilly/mountainous terrain.NTSB ANC93FA056Accident · 1 fatalField investigationFinal reportBell 204B · Copper Harbor, AKFatigue failure of the tail rotor gearbox, and improper helicopter operations being conducted by the operator resulting in repetitive at and over maximum loads. Factors in the accident were: material defect of the tail rotor gear box (inadequate quality…NTSB ATL93LA075Accident · Minor injuriesLimited investigationFinal reportBell UH1F · Gatlinburg, TNThe loss of engine power for unknown reasons.