NTSB investigations: Lycoming 0-320 series, 1995
32 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
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\") = 1995
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") = 1995
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 CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.NTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.NTSB LAX96LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop. The pilot's diverted attention while raising the flaps and pushing in the carburetor heat control was a factor in this accident.NTSB LAX96LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bullhead City, AZThe failure of the pilot/flight instructor to adequately supervise the student pilot resulting in loss of directional control, and his abrupt overcorrection resulting in a waterloop. A contributing factor was the pilot's limited experience as a flight…NTSB LAX96LA025Accident · No injuriesLimited investigationFinal reportCessna 172 · Livermore, CAthe pilot's failure to maintain directional control during the landing roll. A contributing factor was the rough/uneven terrain.NTSB FTW96LA014Accident · No injuriesLimited investigationFinal reportCessna 172M · Sugar Land, TXthe student pilot's diverted attention and failure to maintain directional control.NTSB MIA95LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB LAX95LA320Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Santa Rosa, CAthe pilot's failure to maintain directional control. The pilot's improper use of the brakes and the soft terrain were factors in this accident.NTSB FTW95LA377Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Westcliffe, COFailure by the pilot to maintain directional control. A factor was gusting cross winds.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.NTSB FTW95TA390Accident · Minor injuriesFinal reportPiper PA-18-150 · Brackettville, TXThe pilot's improper compensation for wind conditions, and failure to maintain directional control. A factor relating to the accident was: the variable crosswind.NTSB LAX95LA267Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Reno, NVthe pilot's loss of directional control during a crosswind landing using full flaps and the lack of familiarity with the crosswind landing component chart for the aircraft.NTSB CHI95LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Versailles, MOthe pilot's improper recovery from a bounced landing, which resulted in his failure to maintain directional control of the airplane.NTSB LAX95LA256Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAthe pilot's failure to maintain directional control of the aircraft after one foot slipped off the rudder pedals, and his inadvertent application of asymmetrical brake forces.NTSB SEA95LA149Accident · No injuriesLimited investigationFinal reportEdwin J. Estenson RV-4 · Elk River, IDThe pilot failed to maintain directional control. The tall vegetation was a factor.NTSB ANC95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's failure to maintain directional control, during an off-airport landing on rough/uneven terrain, which resulted in an inadvertent ground swerve. The terrain condition was a related factor.NTSB SEA95LA144Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Moses Lake, WAThe pilot's failure to maintain directional control during the landing and go around. The crosswind and gusty wind conditions were factors in the accident.NTSB LAX95LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · New Cuyama, CAthe pilot's failure to attain and maintain an adequate airspeed, his premature rotation, and his failure to maintain directional control when the aircraft settled back onto the runway. The pilot's selection of a closed airport for the takeoff attempt was a…NTSB LAX95LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Bear, CAthe pilot's failure to maintain directional control during an aborted takeoff attempt, which was necessitated by his failure to properly lean the fuel mixture. The pilot's limited experience in small piston engine airplanes was a factor in the accident.NTSB ANC95LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Skwentna, AKThe pilot's failure to maintain directional control. Factors associated with the accident are the wet and uneven airstrip surface.NTSB NYC95LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, OHan improperly planned approach and touchdown, which resulted in an loss of directional control at touchdown, with the airplane departing the runway, and striking a ravine.NTSB ANC95LA060Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Koliganek, AKThe pilot's failure to attain the proper approach and landing speed, not maintaining directional control, and his inadequate remedial action(s). A factor in the accident was the loose objects in the landing area.NTSB NYC95LA126Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Fairfield, NJThe student pilot's failure to maintain control of the helicopter. The student's lack of experience in the type of operation (solo flight) was a related factor.NTSB CHI95LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit, MIthe student pilot's failure to maintain directional control during the takeoff ground run. A factor associated with the accident was the soft terrain.NTSB ANC95LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe pilot's failure to correct for torque/p factor. The presence of snowberms that narrowed the width of the runway and the pilot's lack of total experience were factors in the accident.NTSB CHI95LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Alma, MIthe flight instructor's inadequate remedial action during the approach to landing/landing roll. Related factors are the flight instructor's inadequate supervision, the dual student's wrong runway selection, the tailwind, and the dual student's failure to…NTSB LAX95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corona, CAthe pilot's failure to maintain runway alignment after aborting a takeoff and improper use of the brakes during the abort.NTSB LAX95LA095Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Carson City, NVthe pilot's improper use of the brakes.NTSB ATL95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Meridianville, ALThe failure of the student pilot to maintain directional control of the aircraft.