NTSB investigations: Lycoming 0-320 series
14,589 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.\"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."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 ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.NTSB LAX02TA105Accident · No injuriesFinal reportPiper PA-18-150 · Winnemucca, NVThe pilot's inadequate fuel consumption calculations that lead to fuel exhaustion.NTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.NTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.NTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.NTSB LAX02LA104Accident · No injuriesLimited investigationFinal reportCessna 172L · Bullhead City, AZThe pilot's failure to comply with maintenance/inspection requirements that resulted in a propeller failure.NTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…NTSB ANC02LA021Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's Failure to maintain a proper descent rate during landing. Factors associated with the accident are variable wind conditions, and the pilot's improper approach to the landing site.NTSB ATL02FA059Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Macon, GAThe pilot's failure to maintain clearance from a tree while maneuvering after takeoff.NTSB SEA02LA047Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COThe student pilot's failure to maintain directional control during landing. Factors included the student pilot's lack of experience, an icy runway, and a mound of snow adjacent to the runway.NTSB LAX02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Diego, CAfuel starvation due to the pilot's mismanagement of the fuel system.NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB LAX02LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Madera, CAThe pilot's becoming lost/disoriented.NTSB NYC02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point.NTSB LAX02FA088Accident · No injuriesField investigationFinal reportRobinson R22 Beta · Glendora, CAThe student's failure to maintain adequate main rotor rpm, and the flight instructor's inadequate supervision. Contributing factors were the high helicopter gross weight and density altitude, and the descending mountainous terrain.NTSB CHI02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot not maintaining clearance from a parked van while taxiing to the parking area. The van was a factor.NTSB FTW02LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Selman, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB DEN02LA027Accident · No injuriesLimited investigationFinal reportKnight BD-4 · Kemmerer, WYThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a snowbank. A contributing factor was the high crosswind.NTSB NYC02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Argyle, NYThe pilot's improper in-flight decision to land on a contaminated runway. A factor was the contaminated runway.NTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.NTSB DEN02LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the crosswind and the pilot's fatigue from lack of sleep.NTSB LAX02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beatty, NVThe pilot failed to maintain control of the airplane.NTSB LAX02LA085Accident · 2 fatalLimited investigationFinal reportEllenberger/Werner Glasair I TD · Minden, NVthe pilot's failure to maintain control of the airplane resulting in the airplane entering a flat spin from which the pilot did not recover.NTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.NTSB FTW02LA080Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Encino, TXThe pilot's failure to maintain aircraft control during lift off from a transport trailer resulting in dynamic rollover of the helicopter.NTSB LAX02LA080Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-1 · San Diego, CAThe pilot failed to maintain directional control after encountering a gust of wind during the landing roll. Factors were the unexpected wind gusts and the soft terrain adjacent to the runway.NTSB FTW02LA079Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMthe loss of engine power as result of the failure of the dual magneto. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Houston, TXthe loss of engine power due to fuel starvation as a result of the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Ottumwa, IAthe student pilot failed to maintain directional control during takeoff. A contributing factor was the snowbank.NTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.NTSB SEA02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle Point, ORThe pilot inadvertently failed to retract the landing gear for the water landing and the aircraft nosed over.NTSB IAD02LA028Accident · 1 fatalLimited investigationFinal reportWilburn Jodel F-12 · Clarksville, VAThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Also causal, was the loss of engine power for undetermined reasons.NTSB NYC02LA052Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Marlborough, MAThe pilot's failure to achieve a proper touchdown point on the runway which resulted in an overrun. A factor was the pilot's lack of experience in short field operations.NTSB MIA02LA051Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Levittown, PRthe failure of maintenance personnel to comply with aircraft manufacturer's inspection procedures, resulting in corrosion and separation of the aileron control cable in flight and the subsequent forced landing in a swamp.NTSB LAX02LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Payson, AZFailure of the pilot to maintain directional control of the airplane. A contributing factor was the premature raising of the flaps.NTSB FTW02FA072Accident · 1 fatalField investigationFinal reportCessna 177 · Farmington, NMthe pilot's inadequate in-flight planning decision which resulted in fuel exhaustion while in the traffic pattern at the destination airport.NTSB CHI02LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Iowa Falls, IAThe pilot's inadequate compensation for the crosswind condition and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind and the rough terrain encountered.NTSB WAS02WA018Accident · 2 fatalForeign investigationGrandman Cozy · Los Barriles, MexicoNTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.NTSB ATL02LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe pilots failure to maintain directional control during landing roll that resulted in a collision with an airport sign. Factors were wet runway surface and wind gust.NTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.NTSB ATL02LA035Accident · 1 fatalLimited investigationFinal reportSpringer Longbow 150 · Oak Hill, FLThe improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…NTSB FTW02LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain clearance with the trees and mountainous terrain while maneuvering. A contributing factor was the pilot's delay in taking remedial action.NTSB DEN02FA017Accident · 1 fatalField investigationFinal reportCessna 172K · Boulder, COthe pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.NTSB LAX02LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Long Beach, CAThe student pilot's inadequate compensation for wind, and his failure to maintain directional control of the aircraft during the landing roll.NTSB ATL02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Trenton, FLThe pilot's improper in-flight decision to make a precautionary landing after sustaining a total loss of electrical power with sufficient fuel remaining to reach his destination airport. This resulted in an off field landing to an off site location in a…NTSB ATL02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kennesaw, GAThe pilot's improper in-flight planning/decision resulting in a total loss of engine power due to fuel exhaustion,which resulted in a forced landing, and subsequent in-flight collision with transmission wires.NTSB LAX02FA056Accident · 2 fatalField investigationFinal reportCessna 172N · San Clemente, CAa loss of engine power due to a loss of magneto to engine timing resulting from stress corrosion crack induced fracture, and separation of the magneto impulse coupling spring.NTSB LAX02LA057Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Show Low, AZThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.NTSB MIA02LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · New Smyrna Bch, FLthe failure of the pilot to maintain airspeed, during initial climb out, which resulted in an inadvertent stall, and subsequent impact with the terrain.