NTSB investigations: Lycoming IO-320 series, TN
16 cases on aircraft whose registry engine model is Lycoming IO-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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2008 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509'))
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 ERA22LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Waverly, TNThe pilot’s improper pre-flight fuel planning, which resulted in a total loss of engine power to both engines due to fuel exhaustion.NTSB ERA09LA147Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Moscow, TNThe pilot's initiation of a low altitude maneuver followed by an uncontrolled descent into terrain.NTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.NTSB ATL03FA125Accident · 2 fatalField investigationFinal reportBellanca 7KCAB · Dover, TNThe pilot continued VFR flight into adverse weather conditions including instrument meteorological conditions and turbulence in thunderstorms, which resulted in a loss of control in flight and subsequent collision with terrain.NTSB MIA02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Clarksville, TNThe failure of the CFI/check pilot to insure Vmc was maintained during a go-around following a simulated failed engine approach, resulting in an in-flight loss of control, uncontrolled descent, and collision with the terrain. A factor in the accident was the…NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…NTSB ATL89FA004Accident · 1 fatalField investigationFinal reportPiper PA-30 · La Follette, TNThe pilot reported an autopilot problem and was not able to maintain control of the airplane. The airframe components were scattered in a circular pattern. All fractures displayed overload failures. The wreckage examination failed to disclose any system or…NTSB ATL85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Portland, TNThe plt made a visual aprch to the wrong airport & attempted to go-around. During the go-around the acft coll ided with trees on the departure end of the rwy.NTSB ATL85LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sparta, TNDual engine stoppage. Fuel tanks topped before takeoff. Plt had filed IFR en route but the wind had shifted to a 30 kt headwind. Plt became concerned about fuel remaining and made an instrument apch which was missed because of low clouds. During course to an…NTSB ATL81FA072Accident · 1 fatalClosedPiper PA-30 · Smyrna, TNNTSB ATL81FA024Accident · 2 fatalClosedPiper PA-30 · Sunbright, TNNTSB IAD78IA002Incident · No injuriesClosedPiper PA-30 · Selmer, TNNTSB IAD74FKW23Accident · No injuriesClosedPiper PA-30 · Morristown, TNNTSB MIA73FKW18Accident · No injuriesClosedPiper PA-30 · Nashville, TNNTSB MIA67F0101Accident · No injuriesClosedPiper PA-30 · Nashville, TNNTSB MIA66F0078Accident · No injuriesClosedPiper PA-30 · Shelbyville, TN