NTSB investigations: Lycoming 0-320 series, 2001
26 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 30 |
|---|---|
| 1983 | 35 |
| 1984 | 34 |
| 1985 | 40 |
| 1986 | 35 |
| 1987 | 23 |
| 1988 | 40 |
| 1989 | 21 |
| 1990 | 31 |
| 1991 | 34 |
| 1992 | 31 |
| 1993 | 33 |
| 1994 | 32 |
| 1995 | 20 |
| 1996 | 21 |
| 1997 | 30 |
| 1998 | 25 |
| 1999 | 27 |
| 2000 | 30 |
| 2001 | 26 |
| 2002 | 31 |
| 2003 | 36 |
| 2004 | 30 |
| 2005 | 37 |
| 2006 | 27 |
| 2007 | 36 |
Where
Latest 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\") = 2001
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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") = 2001
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 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.NTSB CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…NTSB MIA02LA031Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Barceloneta, PRThe pilot's failure to maintain control of the aircraft which resulted in an uncontrolled descent and an in flight collision with water. Contributing to the accident was the impairment of the pilot due to alcohol.NTSB FTW02FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Ben Wheeler, TXThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI02LA030Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Hillman, MNThe inadvertent stall by the pilot. Factors were the tailwind, and the improper decision of the pilot to takeoff with a tailwind.NTSB SEA02FA002Accident · 3 fatalField investigationFinal reportCessna 172N · Decatur Island, WAThe pilot's failure to maintain airspeed during a low altitude turn, resulting in a stall. The pilot exceeding the aircraft's maximum gross takeoff weight was a factor.NTSB CHI01LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's improper flare, and the flight instructor's delayed remedial action, which resulted in a loss of directional control.NTSB FTW01TA194Accident · Minor injuriesFinal reportPiper PA-18-150 · Van Horn, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to the accident was the high density altitude.NTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.NTSB DEN01LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Peyton, COThe pilot's improper go-around procedure and his failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's lack of total experience.NTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.NTSB DEN01FA133Accident · 1 fatalField investigationFinal reportWilson Glastar · Henefer, UTthe pilot's failure to maintain aircraft control for an undetermined reason.NTSB LAX01LA259Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Placerville, CAInadequate airspeed during climb out following an aborted landing that was precipitated by the pilot's misjudged speed/distance on final approach. Also, contributing to the accident was the pilot's inexperience in the type of operation, his failure to…NTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB NYC01LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Stevensville, MDThe pilot's improper flare and his improper recovery from a bounced landing.NTSB IAD01LA101Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Columbus, OHThe pilot's loss of control after turning his head into the slipstream outside of the helicopter.NTSB SEA01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lewistown, MTPilot's failure to maintain directional control of the aircraft while landing.NTSB CHI01LA181Accident · 2 fatalLimited investigationFinal reportMasko Mustang MII · Ann Arbor, MIThe pilot's failure to maintain control of the airplane resulting in the inadvertent stall/spin. A factor was the pilot's unfamiliarity with the airplane.NTSB MIA01LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Miami, FLThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling, descending uncontrolled, impacting the runway, and sliding off the runway and nosing over.NTSB FTW01FA129Accident · 1 fatalField investigationFinal reportCessna 150 · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.NTSB NYC01FA128Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Danvers, MAThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, low ceiling, reduced visibility, and the pilot's decision to attempt a visual flight rules flight in marginal weather conditions.NTSB LAX01LA176Accident · No injuriesLimited investigationFinal reportLeonard Walters Avid Magnum · Lake Shasta, CAA loss of control on final approach due to encountering a strong wind gust and downdraft.NTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.NTSB CHI01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · West Chicago, ILThe inadequate compensation for the crosswind by the student pilot. Additional factors included the student pilot's lack of total flight time, the runway sign and the crosswind.NTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.NTSB LAX01FA129Accident · 3 fatalField investigationFinal reportCessna 172N · Santa Monica, CAthe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the dark night, the marine cloud layer that restricted the pilot's cruising altitude, and the pilot's lack of familiarity with nighttime flight…