NTSB investigations: Lycoming 0-320 series, 1997

200 cases on aircraft whose registry engine model is Lycoming 0-320 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 per year

19642026
NTSB investigations: Lycoming 0-320 series, 1997 per year, 1964–2026: 14,588 cases
1964302
1965338
1966427
1967453
1968424
1969392
1970393
1971396
1972335
1973316
1974328
1975332
1976346
1977365
1978417
1979355
1980341
1981324
1982314
1983244
1984242
1985222
1986244
1987209
1988197
1989204
1990190
1991219
1992202
1993207
1994187
1995189
1996168
1997200
1998204
1999207
2000206
2001206
2002235
2003213
2004226
2005192
2006188
2007169
2008188
2009155
2010165
2011159
2012165
2013132
2014123
2015123
2016121
2017114
2018138
2019125
2020127
2021113
2022143
2023115
2024115
202596
2026103

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\") = 1997
    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'))
  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.

NTSB NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.Dec 28, 1997 · N9604H · DestroyedNTSB FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.Dec 27, 1997 · N2343T · Substantial damageNTSB NYC98LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Riverside, PAthe pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.Dec 26, 1997 · N8015V · Substantial damageNTSB SEA98LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kenmore, WAthe pilot's inadequately planned approach and failure to maintain directional control. The pilot's lack of total experience in kind of aircraft and haze were factors.Dec 24, 1997 · N9566L · Substantial damageNTSB FTW98LA075Accident · 1 fatalLimited investigationFinal reportCessna 172M · Monticello, UTThe pilot's failure to maintain adequate altitude and clearance from obstacles. Also causal was the pilot becoming lost and disoriented. Contributing factors were his lack of familiarity with the geographical area, lack of experience, night conditions, and…Dec 24, 1997 · N1596V · Substantial damageNTSB NYC98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PAThe pilot's failure to maintain proper distance and altitude during approach which resulted in an undershoot and collision with a fence.Dec 16, 1997 · N2932X · Substantial damageNTSB FTW98LA082Accident · No injuriesLimited investigationFinal reportMooney M20 · Pocahontas, ARfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.Dec 13, 1997 · N6159E · Substantial damageNTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · DestroyedNTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.Dec 9, 1997 · N55259 · Substantial damageNTSB NYC98LA040Accident · No injuriesLimited investigationFinal reportCessna 172P · Mitchellville, MDThe pilot's improper recovery from a bounced landing.Dec 8, 1997 · N99510 · Substantial damageNTSB FTW98LA065Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Worland, WYloss of engine power for undetermined reason(s). A related factor was the rough and uneven terrain on which the forced landing was made.Dec 6, 1997 · N71AT · Substantial damageNTSB LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.Nov 28, 1997 · N739HE · Substantial damageNTSB NYC98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Middlefield, OHloss of engine power for undetermined reasons.Nov 25, 1997 · N1816J · Substantial damageNTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.Nov 25, 1997 · N39995 · Substantial damageNTSB LAX98FA043Accident · 1 fatalField investigationFinal reportCessna 172N · La Jolla, CAthe pilot's act of suicide by intentionally diving his aircraft into the ocean.Nov 24, 1997 · N6463D · DestroyedNTSB FTW98LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COloss of engine power for undertermined reason(s).Nov 24, 1997 · N738LC · Substantial damageNTSB FTW98LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, TXthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, while landing. The gusty crosswind was a related factor.Nov 24, 1997 · N80831 · Substantial damageNTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.Nov 22, 1997 · N7528D · Substantial damageNTSB LAX98LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAthe flight instructor's failure to thoroughly brief his student on the performance standards of the proposed autorotation and the method to be used for a positive transfer of controls. The student's failure to verify the performance standards of the…Nov 22, 1997 · N45SG · Substantial damageNTSB NYC98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mount Holly, NJThe student pilot's failure to maintain directional control during the landing roll.Nov 19, 1997 · N5189W · Substantial damageNTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…Nov 15, 1997 · N5231B · DestroyedNTSB FTW98LA049Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lubbock, TXfailure of the student pilot to maintain control of the helicopter during hover out-of-ground-effect. A related factor was: the student pilot's lack of experience in flying helicopters.Nov 15, 1997 · N26026 · Substantial damageNTSB NYC98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pittstown, NJthe pilot's misjudgment of distance and speed during the approach, and her failure to perform a go-around.Nov 13, 1997 · N2973Y · Substantial damageNTSB FTW98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Broomfield, COthe pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.Nov 7, 1997 · N9607D · Substantial damageNTSB LAX98LA030Accident · No injuriesLimited investigationFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain adequate clearance from a hangar while taxiing.Nov 5, 1997 · N98483 · Substantial damageNTSB MIA98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Clarksville, FLthe pilot's improper flare and touchdown.Nov 3, 1997 · N4502X · Substantial damageNTSB FTW98LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · Tooele, UTfailure of the pilot to maintain directional control of the airplane, while landing. Factors related to the accident were: the pilot's improper flare for landing, his delay in attempting to go around (abort the landing), and the encounter with a runway marker…Nov 1, 1997 · N96575 · Substantial damageNTSB NYC98LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Salisbury, MDThe student pilot's improper flare which resulted in a hard landing.Oct 30, 1997 · N1487V · Substantial damageNTSB MIA98FA015Accident · 2 fatalField investigationFinal reportCessna 172M · Rabun Gap, GAThe pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.Oct 24, 1997 · N1499U · DestroyedNTSB SEA98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vashon, WAA misjudged soft field takeoff. Factors include wet grass.Oct 19, 1997 · N5987F · Substantial damageNTSB CHI98LA018Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Rapid City, SDthe windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.Oct 18, 1997 · N88119 · Substantial damageNTSB MIA98LA012Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Pompano Beach, FLThe improper use of collective control by the dual student which prevented the flight instructor from stopping an uncontrolled roll to the left.Oct 17, 1997 · N333PH · Substantial damageNTSB MIA98TA011Accident · Minor injuriesFinal reportCessna 172P · Wiggins, MSLoss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain and the aircraft nosing over during landing roll.Oct 12, 1997 · N945SM · Substantial damageNTSB IAD98LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Oceana, VAImproper flare by the pilot, which resulted in a hard landing. A related factor was the diverted attention.Oct 11, 1997 · N64507 · Substantial damageNTSB MIA98LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Gulf Of Mexicoloss of engine power for undetermined reason(s), which resulted in a forced landing (ditching) at sea.Oct 9, 1997 · N7198D · Substantial damageNTSB FTW98LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Folsum, NMthe pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.Oct 6, 1997 · N83454 · Substantial damageNTSB CHI98LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Sandwich, ILthe pilot's inability to maintain flying airspeed resulting in an inadvertent stall/mush. A factor contributing to this accident was the wind gust.Oct 5, 1997 · N73899 · Substantial damageNTSB ANC98LA001Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Sterling, AKUndetermined.Oct 3, 1997 · N8955D · DestroyedNTSB LAX98LA002Accident · No injuriesLimited investigationFinal reportBlackwell Midget Mustang · Glendale, AZThe pilot's inability to maintain directional control of the aircraft due to the deflation of the right main gear tire. Factors in this accident were the soft sand on the side of the runway and the left crosswind.Oct 2, 1997 · N32JB · Substantial damageNTSB SEA97LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Dixie, IDShifting of a briefcase stored behind the pilot's seat to a position where it obstructed movement of the rudder pedals, resulting in loss of directional control capability. A factor was trees adjacent to the airstrip.Sep 28, 1997 · N7153Z · Substantial damageNTSB NYC97LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kutztown, PAthe student pilot's failure to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the student's pilot's selection of the wrong runway, the resultant tailwind, and the encounter…Sep 28, 1997 · N5338E · Substantial damageNTSB CHI97LA303Accident · No injuriesLimited investigationFinal reportCessna 172P · Yankton, SDThe pilot's failure to maintain control of the aircraft. A factor contributing to the accident was the wind gusts.Sep 28, 1997 · N52419 · Substantial damageNTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).Sep 28, 1997 · N3402Z · Substantial damageNTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.Sep 27, 1997 · N6308W · DestroyedNTSB ATL97LA146Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay-Varina, NCThe pilot's misjudged flare, improper level-off, and improper recovery from a bounced landing.Sep 26, 1997 · N75522 · Substantial damageNTSB ATL97LA140Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, SCthe pilot's improper use of the elevator control and delayed liftoff during takeoff, which resulted in an inadvertent porpoise, collision with the runway, and collapse of the nose gear as he aborted the takeoff.Sep 25, 1997 · N738SZ · Substantial damageNTSB SEA97FA215Accident · 3 fatalField investigationFinal reportCessna 172M · Bremerton, WAThe pilot's misjudgment of distance and altitude from the runway, and his subsequent failure to maintain clearance from the terrain. Factors contributing to the accident were dark night conditions, the pilot's improper decision to conduct the flight at night,…Sep 24, 1997 · N6756H · Substantial damageNTSB LAX97LA329Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hawthorne, NVThe pilot's inadequate compensation for the existing wind condition and his subsequent failure to maintain directional control.Sep 24, 1997 · N82259 · Substantial damageNTSB ANC97TA152Accident · No injuriesFinal reportPiper PA-18 · Coldfoot, AKThe overservicing/pressurizing of the hydraulic brake system by maintenance personnel that locked the brake system and prevented directional control.Sep 18, 1997 · N2355H · Substantial damageNTSB MIA97LA247Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Bainbridge, GAthe failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.Sep 17, 1997 · N3985P · Substantial damage