NTSB investigations: Lycoming T-53 series, 1985
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\") = 1985
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") = 1985
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 FTW85FA310Accident · 1 fatalField investigationFinal reportBell UH-1B · Saint James, LAAcft was at a 150' hover preparing to pick up a log when it experienced a power loss. Witnesses stated that they heard a loud 'bang' and the pilot radioed 'get out of the way'. Acft autorotated thru 60' to 80' trees with very low rotor RPM and impacted with…NTSB FTW85FA188Accident · Serious injuriesField investigationFinal reportBell UH-1B · Boutte, LAThe plt had stabilized acft in a 125' hover, prior to picking up a load, when the eng spooled down and acft entered talltrees with low rotor RPM and pitched nose down as it descended thru the trees. Ground witnesses heard 2 loud 'bangs' prior to the acft…NTSB LAX85FA115Accident · 1 fatalField investigationFinal reportBell 205A-1 · Newhall, CAThis helicopter collided with hilly terrain while circling at a low altitude. It was following another helicopter in a clockwise circular pattern at the time, and being filmed for the t.v. series 'air wolf'. One witness observed the helicopter decending in…NTSB LAX85LA105Accident · No injuriesLimited investigationFinal reportBell 204 · Snelling, CAPlt vacated the acft with engine at idle & with the blades turning to refuel. The landing platform mounted on the 'nurse' truck was slippery from an oil & copper mixture used in the spraying operation. The helicopter started to slide & the plt reboarded just…