NTSB investigations: Lycoming 0-235 series
4,598 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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, newest first
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'))
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'))
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 MIA82DA040Accident · Minor injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot elected to land on runway 080 with winds from 170 degrees at 14 knots gusting to 25 knots. The aircraft ran off the side of the runway into soft sand where the nose wheel collapsed and the aircraft nosed over.NTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…NTSB FTW82DA051Accident · No injuriesFinal reportCessna 152 · Mckinney, TXDuring local solo flight the aircraft veered off the left side of the runway resulting in substantial damage to the Cessna. The winds were gusting from 8 to 13 knots 35 degrees to the left of the runway heading.NTSB LAX82DA053Accident · No injuriesFinal reportCessna 152 · Lodi, CAThe pilot stated that during the landing roll he felt a vibration in the nose gear. Subsequently the aircraft veered offthe runway into soft ground and collapsed the nose gear.NTSB ATL82FID05Accident · No injuriesFinal reportPiper PA-38-112 · Charlottesville, VAAfter performing four successful night approaches the pilot attempted a short field approach with the landing light off. On final he stated it appeared he was getting too low so he turned the landing light on and continued the approach. The aircraft struck a…NTSB NYC82DA027Accident · No injuriesFinal reportCessna 152 · Ansonia, CTAfter departure from bridgeport on a local instructional flight, it was decided that a landing would be made at the Ansonia airport. The instructor reported that there was no NOTAM concerning hazardous runway conditions at Ansonia. During landing, the…NTSB ATL82FLT02Accident · 1 fatalFinal reportGrumman AA-1 · New Albany, MSThe airport manager stated that he heard the aircraft takeoff, turn right, then turn back left. A few seconds later he heard the engine rev up and shortly after it hit the trees. He further stated that there was fog in the area and the ceiling was no more…NTSB FTW82DA044Accident · No injuriesFinal reportCessna 152 · Midland, TXDuring the student's first supervised solo flight he landed normally but lost control prior to adding power for a touch and go landing. The aircraft ran off the runway and collided with a pile of gravel coming to rest inverted.NTSB NYC82DA024Accident · No injuriesFinal reportCessna 152 · Enfield, NHWhile the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…NTSB CHI82DA028Accident · No injuriesFinal reportPiper PA-38-112 · Grand Rapids, MIThe pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was…NTSB ATL82DLG09Accident · No injuriesFinal reportCessna 152 · Grantiteville, SCThe pilot was unable to find the airport at his intended destination. He saw another airport and elected to land. A no-flap approach was made to rwy 24 with a north wind. The aircraft touched down about 500 feet from the departure end and then became airborne…NTSB CHI82DA021Accident · No injuriesFinal reportCessna 152 · Paxton, ILDuring the student's last landing, the landing gear struck a snowberm at the approach end of the runway. Reportedly, the berm could not be seen from the air. After hitting the berm, the instructor took control of the aircraft and completed the landing. An…NTSB LAX82FA036Accident · 1 fatalField investigationFinal reportPiper PA-22 · Black Canyon Ci, AZThe wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.NTSB CHI82FEC08Accident · No injuriesFinal reportCessna 152 · Ypsilanti, MIDuring takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right…NTSB LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CANTSB CHI82DEP14Accident · No injuriesClosedCessna 152 · Pewaukee, WINTSB CHI82DEC07Accident · No injuriesClosedCessna 152 · Howell, MINTSB CHI82DER17Accident · No injuriesClosedPiper PA-38 · Albert Lea, MNNTSB CHI82DEP11Accident · No injuriesClosedCessna 152 · Monroe, WINTSB NYC82DHA04Accident · No injuriesClosedCessna 152 · Manville, NJNTSB LAX82DUJ11Accident · Minor injuriesClosedCessna 152 · Wikieup, AZNTSB FTW82FRG10Accident · No injuriesClosedCessna 152 · Harlingen, TXNTSB FTW82DRA08Accident · No injuriesClosedCessna 152 · College Sta, TXNTSB LAX82DVA07Accident · No injuriesClosedCessna 152 · Bakersfield, CANTSB NYC82DHD04Accident · No injuriesClosedCessna 152 · Toms River, NJNTSB NYC82FFJ02Accident · Serious injuriesClosedCessna 152 · Lockport, NYNTSB NYC82DFJ05Accident · No injuriesClosedPiper PA-22 · Fulton, NJNTSB MIA82FKJ01Incident · No injuriesClosedPiper PA-23 · Pensacola, FLNTSB FTW82DRA06Accident · No injuriesClosedBellanca 7ECA · Arcola, TXNTSB CHI81DEP07Accident · No injuriesClosedBellanca 7ECA · Neenah, WINTSB CHI82DEP06Accident · No injuriesClosedCessna 152 · Monroe, WINTSB FTW82FRG04Accident · No injuriesClosedPiper PA-38 · San Benito, TXNTSB SEA82DYP01Accident · Minor injuriesClosedBellanca 7ECA · Wapato, WANTSB FTW82FA005Accident · 1 fatalClosedCessna 152 · Jayton, TXNTSB ANC82DAG03Accident · No injuriesClosedPiper PA-38 · Anchorage, AKNTSB FTW82FQA03Accident · Minor injuriesClosedCessna 152 · Alamo, NMNTSB CHI82DEE02Accident · No injuriesClosedPiper PA-38 · Joliet, ILNTSB FTW82DPA03Accident · No injuriesClosedCessna 152 · Mcgregor, TXNTSB ATL82FGM01Accident · No injuriesClosedPiper PA-38 · New Cumberland, WVNTSB CHI82FEK01Accident · No injuriesClosedCessna 152 · New Albany, OHNTSB MKC81FCA01Accident · No injuriesClosedPiper PA-38 · Chesterfield, MONTSB ATL82FA001Accident · 2 fatalClosedPiper PA-38 · Gadsden, ALNTSB FTW81FRG67Accident · No injuriesClosedPiper PA-38 · Gillette, TXNTSB LAX81FA133Accident · 1 fatalClosedCessna 152 · Carlsbad, CANTSB NYC81FHD40Accident · No injuriesClosedPiper PA-38 · Lumberton, NJNTSB MKC81DCQ51Accident · No injuriesClosedCessna 152 · Hays, KSNTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PANTSB MKC81DCJ34Accident · No injuriesClosedPiper PA-38 · Kearney, NENTSB ANC81DAG97Accident · No injuriesClosedPiper PA-12 · Wasilla, AKNTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WY