NTSB investigations: Lycoming 0-320 series, 2007
22 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/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 | 50 |
|---|---|
| 1983 | 46 |
| 1984 | 41 |
| 1985 | 31 |
| 1986 | 40 |
| 1987 | 46 |
| 1988 | 37 |
| 1989 | 28 |
| 1990 | 36 |
| 1991 | 34 |
| 1992 | 23 |
| 1993 | 32 |
| 1994 | 26 |
| 1995 | 32 |
| 1996 | 24 |
| 1997 | 43 |
| 1998 | 42 |
| 1999 | 28 |
| 2000 | 38 |
| 2001 | 43 |
| 2002 | 37 |
| 2003 | 35 |
| 2004 | 36 |
| 2005 | 39 |
| 2006 | 41 |
| 2007 | 22 |
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\") = 2007
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\" = 260))
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") = 2007
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" = 260))
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 MIA08CA022Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Orlando, FLThe student pilot's failure to maintain directional control during landing.NTSB SEA08CA030Accident · Minor injuriesData collectionFinal reportCessna 172N · Atwater, CAThe failure of the student pilot to maintain directional control during the landing roll. Factors contributing to the accident included the sign and the ditch.NTSB MIA08LA002Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Toughkenamon, PAThe reason for this accident is undetermined.NTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.NTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.NTSB DEN07CA151Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Rawlins, WYthe pilot's failure to maintain directional control during landing. A contributing factor to the accident was the crosswind.NTSB CHI07CA234Accident · No injuriesData collectionFinal reportBeech 23 · Georgetown, OHThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence. Factors contributing to the accident were the quartering tailwind and the…NTSB ATL07CA109Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe pilot's failure to maintain directional control during the landing roll.NTSB SEA07CA206Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Ontario, ORThe pilot's improper recovery from a bounced landing and failure to maintain directional control during landing.NTSB ATL07CA099Accident · No injuriesData collectionFinal reportCessna 172P · Perry, GAThe student pilot's failure to maintain directional control on landing roll out resulting in the airplane departing the runway and collision with a ditch.NTSB ANC07LA055Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Nenana, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop and main landing gear collapse. Factors contributing to the accident were the ground-loop and landing gear collapse.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…NTSB CHI07CA120Accident · No injuriesData collectionFinal reportChampion 7GCAA · Grand Rapids, MNThe pilot's failure to maintain directional control and his excessive use of brakes during the landing which resulted in a nose-over. The downhill slope was a contributing factor.NTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.NTSB LAX07CA128Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Porterville, CAThe pilot's failure to maintain directional control.NTSB MIA07CA057Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Pierce, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in overload failure and subsequent collapse of the right main landing gear.NTSB CHI07CA076Accident · No injuriesData collectionFinal reportCessna 172N · Holland, MIThe student pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the takeoff, which caused the airplane to impact the snow bank and nose over. Contributing factors were the crosswind and the snow…