Fatal NTSB investigations: Lycoming 0-320 series, TN
13 cases on aircraft whose registry engine model is Lycoming 0-320 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
| 1966 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1978 | 2 |
| 1981 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2021 | 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.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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 ERA21FA232Accident · 1 fatalClass 3 · FieldFinal reportGulfstream American AA-5A · Crossville, TNA partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.NTSB ERA09LA123Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Powder Springs, TNThe non-instrument rated pilot's decision to continue under visual flight rules into an area of instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB MIA02FA162Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Greeneville, TNA loss of engine power for undetermined reasons and the pilot's decision to continue flight with a known equipment deficiency. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL95FA044Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Spring City, TNThe pilot's inadequate preflight planning, and his continued VFR flight into instrument weather conditions which resulted in the collision with the mountain. A factor was low ceilings.NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.NTSB ATL85FA280Accident · 1 fatalField investigationFinal reportCessna 172N · Halls, TNThe private pilot had just leveled off at 2500 feet and pointed out the old naval base to his right front seat passenger when he slumped over the yoke. The passenger in the rear seat held the pilot off the controls while her non-pilot husband attempted to…NTSB ATL82FA012Accident · 1 fatalClosedPiper PA-28 · Powell, TNNTSB IAD78FA108Accident · 1 fatalClosedGrum Amer AA-5 · Jackson, TNNTSB IAD78FA043Accident · 2 fatalClosedPiper PA-22 · Camden, TNNTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNNTSB MIA69A0062Accident · 1 fatalClosedCessna 177 · Murfreesboro, TNNTSB MIA66A0107Accident · 2 fatalClosedPiper PA-23 · Gallatin, TN