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

12 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, FL per year, 1964–2026: 824 cases
19647
19658
196617
196716
196816
196911
197015
197118
197213
19739
197415
197516
197611
197718
197816
197919
198021
198120
198217
198310
198415
198515
198615
198711
198811
198911
199010
199111
199216
199310
199413
199510
199611
199714
199812
199913
200018
200115
200212
200315
200419
200514
200613
20076
200816
200914
20106
201113
20129
201310
201411
201511
201613
20179
201819
201916
202010
202113
202211
20239
202410
202510
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\" = 'FL' 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 MIA03FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Coral Springs, FLThe failure of the dual students and flight instructors on both N9840V and N6101F to see and avoid each other, which resulted in a midair collision.Oct 27, 2002 · N9840V · 2 aircraft · DestroyedNTSB MIA03LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sebring, FLThe student pilot's premature rotation and failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall, an uncontrolled descent, and an impact with the ground.Oct 25, 2002 · N267EP · Substantial damageNTSB ATL03LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Opa Locka, FLThe pilot' inadequate evaluation of weather information, and the selection of the wrong runway that resulted in an attempted takeoff with a tailwind and the subsequent loss of control during takeoff.Oct 17, 2002 · N903WA · Substantial damageNTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.Oct 13, 2002 · N6542J · Substantial damageNTSB ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.Sep 23, 2002 · N8828N · Substantial damageNTSB MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.Jul 12, 2002 · N6024L · Minor damageNTSB ATL02LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Merritt Island, FLThe pilot's improper recovery after a bounced landing and improper landing flare which resulted in the airplane colliding with the runway.Jul 12, 2002 · N54119 · Substantial damageNTSB ATL02FA074Accident · 1 fatalField investigationFinal reportPiper PA-16 · Lakeland, FLThe failure of the PA-16 pilot to maintain a visual lookout and to yield the right-of-way to a lower aircraft while on final approach resulting in a midair collision. Contributing to the accident was the failure of both pilot's to adhere to an ATC clearance…Apr 5, 2002 · N5293H · 2 aircraft · Substantial damageNTSB ATL02LA073Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during the landing roll. Contributing to the accident was the pilot's decision to land with a tailwind.Apr 4, 2002 · N64079 · Substantial damageNTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.Mar 7, 2002 · N1446V · Substantial damageNTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…Mar 6, 2002 · N75908 · Substantial damageNTSB ATL02LA035Accident · 1 fatalLimited investigationFinal reportSpringer Longbow 150 · Oak Hill, FLThe improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…Jan 10, 2002 · N150LB · Substantial damage