NTSB investigations: Lycoming 0-320 series, TN
152 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, newest first
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 ('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."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 ATL05LA031Accident · No injuriesLimited investigationFinal reportCessna 172K · Smyrna, TNThe pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB ATL05CA002Accident · Serious injuriesData collectionFinal reportCessna 172K · Knoxville, TNThe pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.NTSB ATL04LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe CFI's inadequate in-flight planning/decision and his inadequate supervision which resulted in fuel exhaustion. A factor was the inadequate preflight planning/preparation to ensure an adequate fuel supply, and the berm.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB ATL03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Winchester, TNA maintenance personnel failure to follow propeller inspection procedures that resulted in a fatigue failure of a propeller blade and the subsequent forced landing.NTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.NTSB ATL03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Rogersville, TNThe rupture of the carburetor float, which resulted in the loss of engine power and subsequent on ground collision with trees.NTSB ATL03LA058Accident · No injuriesLimited investigationFinal reportCessna 172 M · Collegedale, TNThe student pilot's failure to maintain directional control, which resulted in a loss of control, impact with terrain and subsequent nose over.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 MIA02LA009Accident · No injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's inattentive preflight inspection, non-compliance with the prestart checklist, decision to leave the cockpit unattended with engine running, and his inadvertent deactivation of the parking brake as he exited to remove a wheel chock, resulting in…NTSB ATL00LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Clinton, TNThe pilot's inadequate in-flight planning necessitating an intentional ground loop maneuver on landing. Contributing factors were the pilot's misjudgment of distance/airspeed, the high terrain surrounding the runway, and the tailwind condition.NTSB MIA00LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, TNThe inadequate annual inspection of the airplane by the mechanic for his failure to note that the threaded portion of the bail wire had 2 1/2 failed threads which resulted in the inability to keep the gascolator bowl tightly secured. Also his failure to note…NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB MIA99FA031Accident · Minor injuriesField investigationFinal reportPiper PA-28-151 · Chattanooga, TNThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB MIA98LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingsport, TNThe dual student's failure to maintain adequate airspeed which resulted in a stall mush. Contributing to the accident were the flight instructor's inadequate supervision and the night conditions.NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB ATL97LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Athens, TNthe pilot's failure to initiate a go-around. The pilot's misjudged approach was a factor.NTSB ATL96LA118Accident · No injuriesLimited investigationFinal reportCessna 172N · Nashville, TNinadequate annual inspection by other maintenance personnel and inadequate pre-flight inspection by the pilot.NTSB MIA96LA173Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Knoxville, TNFatigue failure of the blade No. 1 hub arm of the left propeller.NTSB ATL96LA085Accident · Minor injuriesLimited investigationFinal reportMerle Musson Cozy · Covington, TNThe clogged fuel strainer that resulted in an engine stoppage. A factor was the lack of a suitable landing site.NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.NTSB ATL96LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, TNthe student pilot's improper recovery from a bounced landing and his failure to maintain directional control. A factor was the improper level-off.NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB ATL95LA072Accident · No injuriesLimited investigationFinal reportCessna 172N · Paris, TNThe failure of the pilots of both aircraft to maintain proper visual lookout during landing at the uncontrolled airport.NTSB ATL95LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Smyrna, TNThe flight instructor's failure to ensure that the magnetos were not energized prior to positioning the propeller, and the dual student's failure to place the ignition switch in the off position after the first start attempt.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 ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.NTSB ATL93LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, TNThe pilot's improper procedures in that he landed with excessive flap extension, and his inadequate compensation for the gusting crosswind.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB ATL91LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tullahoma, TNAn engine power loss for undetermined reasons.NTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.NTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.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 ATL90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Jackson, TNLoss of power in both engines (probable fuel starvation) due to improper planning/decision by the pilot(s), and lack of supervision by the instructor. Soft terrain in the emergency landing area was considered to be a factor.NTSB ATL89LA204Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Gallatin, TNThe pilot used an unsuitable runway area (terrain) for takeoff. Related factors were: inadequate maintenance of the runway, runway conditions (uneven surface & tall grass), and the fence.NTSB ATL88LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Michie, TNWitness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…NTSB ATL86FLT03Accident · Minor injuriesFinal reportCessna 172I · Millington, TNThe acft collaped the nose lndg bear during a forced lndg after the engine failed during takeoff. During post ace eng exam the wires disconnected from the magneto switch. The wires were resting on the 'p' leads. The fastening screw found on the bottom of the…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 ATL84FLT02Accident · Serious injuriesFinal reportPiper PA-22-150 · Memphis, TNThe acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop…NTSB ATL83LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Viola, TNThe acft was damaged in a collision with farm equipment during an emergency landing on a grass strip. The student pilot had received a weather briefing by telephone but had inadvertantly encountered a rain shower. Because of the rain the student elected to…NTSB ATL84LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe acft recontacted the ground during takeoff and bounced several times before coming to rest. The propeller, nose strut and firewall were damaged. The wind was reportedly from 250 degrees at 14 KTS gusting to 26 KTS. The ATC controllers on duty said the…NTSB ATL82FA012Accident · 1 fatalClosedPiper PA-28 · Powell, TNNTSB ATL81FLT12Accident · Minor injuriesClosedCessna 172 · Brownsville, TNNTSB ATL81FKW11Accident · No injuriesClosedPiper PA-28 · Woodbury, TNNTSB ATL80FKW01Accident · No injuriesClosedCessna 172 · Nashville, TNNTSB ATL80DLT12Accident · No injuriesClosedPiper PA-28 · Union City, TN