NTSB investigations: Lycoming 0-235 series
88 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “On ground/water collision with object”. 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 | 6 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 6 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 3 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 2 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
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\" = 310))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
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" = 310))
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 LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB ERA10CA112Accident · No injuriesData collectionFinal reportBellanca 7ECA · Calhoun City, MSThe pilot's failure to maintain clearance from a fallen tree located off the right side of the runway during takeoff.NTSB LAX06CA083Accident · No injuriesData collectionFinal reportPiper J5 · Carefree, AZthe pilot's selection of unsuitable terrain for the precautionary landing and failure to avoid obstacles during the landing roll.NTSB DFW06CA005Accident · No injuriesData collectionFinal reportCessna 152 · Tupelo, MSThe pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.NTSB NYC02LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe student pilot's failure to maintain adequate clearance while maneuvering to avoid obstructions.NTSB LAX02LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Sacramento, CAFailure of the pilot to ensure the seat was set properly prior to engine start, and not using the parking brake when adjustment of seat was necessary, which resulted in the inadvertent deactivation of the brakes and subsequent collision with the fuel trucks.NTSB SEA02LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Longmont, COThe pilot's failure to maintain directional control of the aircraft during landing. Factors were a contaminated runway, which was icy and covered with snow, and a snow bank.NTSB MIA01LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe pilot's attempted takeoff with a tail wind and his failure to maintain directional control of the airplane during takeoff resulting in the airplane veering to the left and colliding with trees.NTSB IAD01LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallipolis, OHcollision with a deer during take-off roll.NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.NTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)NTSB MIA00LA230Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · New Smyrna Bch., FLthe pilot's failure to maintain control of the airplane during the landing roll. Factors in this accident were; a crosswind, and the pilot lack of experience in this kind of aircraft.NTSB LAX00LA270Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Luis Obispo, CAThe pilot's inadequate visual lookout while taxiing to the runway, which resulted in his failure to see and avoid the fuel truck.NTSB LAX00LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe pilot's in-flight decision to continue the takeoff and his subsequent delayed decision to abort the takeoff after he noted that the airplane was unable to climb out of ground effect.NTSB MIA00LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Steens, MSthe flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.NTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.NTSB CHI99LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INthe student pilot's inability to gain clearance between the airplane and the hanger. Factors contributing to this accident were the wet, grass landing surface, the student pilot's attempted turn to avoid the embankment drop off at the end of the runway, the…NTSB LAX99LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe pilot's failure to maintain clearance between the airplane's wing and a parked fuel truck.NTSB IAD98LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Windsor Locks, CTThe student pilot's inattention during taxi, which resulted in the collision with a fuel truck.NTSB MIA98LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Georgetown, SCthe pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…NTSB CHI98LA056Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Nevada, MOa deer that ran onto the runway as the airplane was landing. The reduced light condition at dusk was a related factor.NTSB MIA97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Villa Rica, GAInadequate runway maintenance by the pilot for allowing trees to be in close proximity of the runway and failure to maintain clearance from the trees.NTSB ATL97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Smithfield, NCan animal (deer) on the runway. Factors associated with the accident were: the light condition at dusk, and failure or inability of the flight crew to see the deer in time to avoid a collision.NTSB CHI97LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNthe pilot's misjudgment of his clearance around the parked vehicle. A factor was the location of the parked vehicle.NTSB LAX97LA191Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Payson, AZan animal (elk) on the runway. Factors associated with the accident included: darkness, the pilot's inability to see the animal in sufficient time to avoid a collision, and the lack of a taller fence around the airport.NTSB ATL97LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fernandina Bch, FLinadequate visual lookout by the student pilot, which resulted in a collision with a parked trailer, while his attention was diverted. The proximity of the trailer was a related factor.NTSB NYC96LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAan animal (deer) that wandered onto the runway. The light condition (at dusk) was a related factor.NTSB MIA96LA126Accident · No injuriesLimited investigationFinal reportLuttrell-Lacky Breezy · Hendersonville, NCinadequate preflight planning/preparation by the pilot, by not adequately surveying the area to be used for takeoff, which resulted in a collision with a fence.NTSB ATL96LA070Accident · No injuriesLimited investigationFinal reportO'Connell Christen Eagle · New Smyrna Bch, FLthe failure of the pilots of the Cessna 152, N757NP, to see and avoid the Christen Eagle, N13LD.NTSB MIA96LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLthe pilot misjudged the clearance between the fuel trucks.NTSB ATL95LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kissimmee, FLThe inadequate visual lookout by the driver of the vehicle. A factor in the accident was the inoperative anti-collision lights of the aircraft.NTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB CHI95LA238Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Oshkosh, WIthe pilot's failure to maintain clearance.NTSB MIA95LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Indiantown, FLAn evasive maneuver to avoid collision with animals.NTSB SEA94FA199Accident · 2 fatalField investigationFinal reportPiper PA-12 · Salem, ORFailure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.NTSB MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.NTSB ANC94LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe failure of the student pilot to maintain directional control of the aircraft. Factors contributing to the accident were the frozen main landing gear brake shoe, the uncontrolled airport operations by airport personnel and extreme low temperature…NTSB MIA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Orlando, FLVisual lookout not maintained by the pilot-in-command while taxiing the airplane. Contributing to the accident was the failure of the driver of the vehicle to advise the ground controller that he had stopped the vehicle on the taxiway.NTSB MIA93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe pilot-in-command's failure to maintain a visual lookout while taxiing into the parking area, resulting in an on-ground collision with a light pole.NTSB MIA92LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCFailure of the pilot-in-command to maintain adequate wingtip clearance with bushes off the side of the taxiway while taxiing to takeoff.NTSB MIA92LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, FLFailure of the pilot to maintain clearance while taxiing.NTSB LAX92LA007Accident · No injuriesLimited investigationFinal reportCessna 421C · Santa Monica, CAThe failure of the pilot of the other aircraft to maintain an adequate visual lookout while taxiing his aircraft.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.NTSB ANC91LA016Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Fairbanks, AKThe pilot-in-command's failure to properly perform the aircraft preflight resulting in a collision with a tow bar during initial taxi.NTSB ATL91LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Centerville, TNThe propable cause of the accident was the runway incursion by the deer during the pilot's takeoff roll.