NTSB investigations: Lycoming 0-320 series, MS
10 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 | 1 |
|---|---|
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2006 | 1 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'MS' 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')
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 c."eventStateOrRegion" = 'MS' 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')
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 DFW08CA003Accident · Minor injuriesData collectionFinal reportCessna 172N · Oxford, MSThe pilots inadvertent stall during takeoff. A contributing factor was his failure to calculate the aircraft gross weight prior to the flight.NTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.NTSB MIA04FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Olive Branch, MSThe student pilot's failure to maintain airspeed (Vso), which resulted in an inadvertent stall/spin, an uncontrolled descent, and an impact with terrain. A factor in the accident was his failure to follow the airplane's operating checklist and retract the…NTSB MIA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Leesburg, MSThe pilot's improper use of flaps, resulting in the degradation of climb performance and collision with the ground.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 MIA96LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Madison, MSThe pilot's premature raising of flaps during a go-around.NTSB MIA94LA004Accident · Serious injuriesLimited investigationFinal reportEhlers Lancair 320 · Bay St. Louis, MSThe pilot-in-command's failure to maintain airspeed resulting in an in flight loss of control (stall/spin) and subsequent in flight collision with trees and terrain.NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.NTSB MIA87FA188Accident · 1 fatalField investigationFinal reportCessna 172I · Ellisville, MSBfr the flt, the arpt owner adzd the plt not to fly, since he (the plt) appeared to be intoxicated. The plt 'said ok & left,' but returned aprx 1 hr later. A witness rprtd the plt atmtd to takeoff with full flaps. Drg the takeoff roll, theacft drifted off the…NTSB ATL82DA185Accident · No injuriesFinal reportPiper PA-28-151 · Duncan, MSPilot attempted takeoff from strip with 4 inch deep grass and a 75 degree crosswind. Occupants weighed total of 490 lbs. Temperature was 94 degrees. Aircraft mushed back into ground and pushed gear struts through wing.