NTSB investigations: Lycoming 0-320 series, 2002, TX

17 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, 2002, TX per year, 1964–2026: 916 cases
196428
196525
196630
196727
196834
196933
197030
197116
197224
197314
197420
197518
197626
197723
197823
197924
198019
198122
198225
198314
198411
198511
198613
19876
19887
19897
19908
199110
199211
199316
19944
19958
199613
199713
199810
199913
200011
20019
200217
200320
200414
200510
200614
20077
200813
200910
201011
201112
20127
20137
201410
201511
20168
20177
20186
20196
202013
20219
202211
202310
20249
20257
202611

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    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 FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.Dec 28, 2002 · N3885J · DestroyedNTSB FTW03LA045Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Carrizo Springs, TXThe pilot's failure to maintain control of the helicopter after encountering dynamic rollover. A contributing factor was the deer pulling the aircraft unevenly.Nov 13, 2002 · N7734H · Substantial damageNTSB FTW03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Porter, TXThe loss of engine power for an undetermined reason.Oct 31, 2002 · N1317E · Substantial damageNTSB FTW02CA249Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Graham, TXthe pilot's failure to attain the proper touchdown point which resulted in a runway overrun.Sep 4, 2002 · N9855S · Substantial damageNTSB FTW02LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Price, TXThe loss of engine power for an undetermined reason, which resulted in a forced landing.Aug 31, 2002 · N3961K · Substantial damageNTSB FTW02LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Masterson, TXThe loss of engine power due to fuel starvation as a result of a blockage of the carburetor. A contributing factor was the lack of suitable terrain for the emergency landing.Aug 8, 2002 · N43473 · Substantial damageNTSB FTW02LA225Accident · Minor injuriesLimited investigationFinal reportSouthworth EAA Bi-Plane May Bee · West, TXThe pilot's inadequate preflight/planning inspection which resulted in fuel exhaustion and subsequent loss of engine power.Aug 3, 2002 · N11S · Substantial damageNTSB FTW02LA185Accident · Minor injuriesLimited investigationFinal reportQuinn RV-6A · El Paso, TXA loss of engine power for undetermined reasons.Jun 19, 2002 · N799RQ · Substantial damageNTSB FTW02LA178Accident · No injuriesLimited investigationFinal reportCessna 172M · Kirbyville, TXthe pilot's failure to attain the proper touchdown point. A contributing factor was the loose gravel.Jun 15, 2002 · N21799 · Substantial damageNTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.Jun 9, 2002 · N2282Y · Substantial damageNTSB FTW02LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Dalhart, TXThe pilot's failure to maintain aircraft control. Contributing factors were the shifting gusty winds and the ditch.Jun 2, 2002 · N4261Q · Substantial damageNTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.May 22, 2002 · N734KG · Substantial damageNTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.Apr 8, 2002 · N99341 · Substantial damageNTSB FTW02LA114Accident · No injuriesLimited investigationFinal reportMcClung Starduster SA-1 · Sherman, TXthe pilot's inadvertent use of unsuitable taxi terrain, which resulted in an encounter with a ditch while taxing from landing.Apr 8, 2002 · N2XM · Substantial damageNTSB FTW02LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Selman, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.Feb 20, 2002 · N238NY · Substantial damageNTSB FTW02LA080Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Encino, TXThe pilot's failure to maintain aircraft control during lift off from a transport trailer resulting in dynamic rollover of the helicopter.Feb 11, 2002 · N8557Z · Substantial damageNTSB FTW02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Houston, TXthe loss of engine power due to fuel starvation as a result of the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.Feb 7, 2002 · N4013E · Substantial damage