NTSB investigations: Lycoming 0-320 series, 2001
15 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 24 |
|---|---|
| 1983 | 9 |
| 1984 | 11 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 15 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 9 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 15 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 13 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 7 |
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 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\" = 230))
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" = 230))
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 CHI02LA021Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lambertville, MIThe pilot's improper flare during landing.NTSB ANC01LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot's inadequate evaluation of the wind conditions. A factor in the accident was the presence of a tailwind.NTSB CHI01LA294Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Alice, NDThe pilot's unsuccessful recovery from an intentional aerobatic stall/spin maneuver. Contributing to the accident were the pilot's impairment (alcohol), and his psychological condition.NTSB ANC01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sparrevohn, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were rough/uneven terrain, and an overload failure of the main landing gear landing strut.NTSB NYC01LA210Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Brockport, NYThe pilot's delayed go-around during the landing attempt. Factors included the dark night conditions and the pilot's inadequate preflight decision to fly to an airport with inoperative surface lighting.NTSB CHI01FA209Accident · Minor injuriesField investigationFinal reportBeech B19 · Eden Prairie, MNThe student pilot's failure to maintain aircraft control during the landing, her failure to recover from the bounced landing, and the nose gear overload.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB ATL01LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pomaria, SCThe pilot's improper operation of the flight controls while attempting a takeoff from an unimproved surface. A factor was rough and uneven terrain.NTSB DEN01FA111Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Meeker, COthe pilot's failure to maintain terrain clearance as a result of his drug induced impairment. A factor was his exceeding the airplane's gross weight limits.NTSB FTW01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · Patterson, LAthe pilot's failure to maintain control during the go-around. A contributing factor was the wind gust.NTSB SEA01LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172 N · Sultan, WAThe pilot's failure to maintain adequate clearance from trees and terrain during the airplane's initial climb.NTSB SEA01LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Scapoose, ORthe pilot's failure to maintain a speed above minimum in-flight stall speed (Vs). Factors include gusty winds at the time of the attempted landing.NTSB SEA01FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Greenwater, WAFailure to maintain clearance from mountainous terrain.NTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…NTSB CHI01LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Huron, MIThe pilot not maintaing a proper glide path during the simulated forced landing. Factors were flight instructor's inadequate supervision and the wind gusts.