NTSB investigations: Lycoming 0-320 series, 2007

22 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Lycoming 0-320 series, 2007 per year, 1982–2026: 930 cases
198250
198346
198441
198531
198640
198746
198837
198928
199036
199134
199223
199332
199426
199532
199624
199743
199842
199928
200038
200143
200237
200335
200436
200539
200641
200722

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\") = 2007
    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')
      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\" = 260))
  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 MIA08CA022Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Orlando, FLThe student pilot's failure to maintain directional control during landing.Nov 28, 2007 · N148ND · Substantial damageNTSB SEA08CA030Accident · Minor injuriesData collectionFinal reportCessna 172N · Atwater, CAThe failure of the student pilot to maintain directional control during the landing roll. Factors contributing to the accident included the sign and the ditch.Nov 17, 2007 · N3318E · Substantial damageNTSB MIA08LA002Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Toughkenamon, PAThe reason for this accident is undetermined.Oct 6, 2007 · N8642V · Substantial damageNTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.Oct 4, 2007 · N2263E · Substantial damageNTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.Oct 3, 2007 · N437ND · Substantial damageNTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.Sep 30, 2007 · N1839T · Substantial damageNTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.Sep 11, 2007 · N12189 · Substantial damageNTSB DEN07CA151Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Rawlins, WYthe pilot's failure to maintain directional control during landing. A contributing factor to the accident was the crosswind.Aug 31, 2007 · N3914Z · Substantial damageNTSB CHI07CA234Accident · No injuriesData collectionFinal reportBeech 23 · Georgetown, OHThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence. Factors contributing to the accident were the quartering tailwind and the…Jul 27, 2007 · N2306L · Substantial damageNTSB ATL07CA109Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2007 · N51250 · Substantial damageNTSB SEA07CA206Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Ontario, ORThe pilot's improper recovery from a bounced landing and failure to maintain directional control during landing.Jul 16, 2007 · N7474L · Substantial damageNTSB ATL07CA099Accident · No injuriesData collectionFinal reportCessna 172P · Perry, GAThe student pilot's failure to maintain directional control on landing roll out resulting in the airplane departing the runway and collision with a ditch.Jun 29, 2007 · N54730 · Substantial damageNTSB ANC07LA055Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Nenana, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop and main landing gear collapse. Factors contributing to the accident were the ground-loop and landing gear collapse.Jun 24, 2007 · N5540A · Substantial damageNTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.May 16, 2007 · N62960 · Substantial damageNTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.May 14, 2007 · N79941 · Substantial damageNTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.May 10, 2007 · N38730 · Substantial damageNTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…May 1, 2007 · N97224 · Substantial damageNTSB CHI07CA120Accident · No injuriesData collectionFinal reportChampion 7GCAA · Grand Rapids, MNThe pilot's failure to maintain directional control and his excessive use of brakes during the landing which resulted in a nose-over. The downhill slope was a contributing factor.Apr 25, 2007 · N1646G · Substantial damageNTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.Apr 22, 2007 · N186AS · Substantial damageNTSB LAX07CA128Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Porterville, CAThe pilot's failure to maintain directional control.Apr 13, 2007 · N30WH · Substantial damageNTSB MIA07CA057Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Pierce, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in overload failure and subsequent collapse of the right main landing gear.Feb 23, 2007 · N2808P · Substantial damageNTSB CHI07CA076Accident · No injuriesData collectionFinal reportCessna 172N · Holland, MIThe student pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the takeoff, which caused the airplane to impact the snow bank and nose over. Contributing factors were the crosswind and the snow…Feb 23, 2007 · N5321D · Substantial damage