NTSB investigations: Lycoming 0-320 series, 2006

16 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Hard landing”. 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, 2006 per year, 1982–2026: 384 cases
198220
198312
198416
198515
198613
198721
19888
198913
19905
199112
199212
199315
199419
199512
199622
199715
199816
199920
200016
200112
200222
200312
200416
200513
200616
200711

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\") = 2006
    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\" = 200))
  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 NYC07CA045Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Danbury, CTThe student pilot's inadequate recovery from a bounced landing, which resulted in a hard landing.Dec 11, 2006 · N44635 · Substantial damageNTSB CHI07CA006Accident · No injuriesData collectionFinal reportCessna 172N · Grand Rapids, MNThe student pilot's misjudged landing flare and improper recovery from the bounced landing which led to the failure of the nose landing gear. The overload failure of the nose landing gear was a factor.Oct 9, 2006 · N739XK · Substantial damageNTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.Oct 6, 2006 · N97811 · Substantial damageNTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.Oct 6, 2006 · N275ND · Substantial damageNTSB CHI06CA274Accident · No injuriesData collectionFinal reportBeech B19 · Pontiac, MIThe pilot's failure to perform a go-around when he noticed the airplane was not on a stabilized final approach. Contributing factors to the accident were the hard landing, the subsequent pilot-induced oscillation (porpoise) which resulted in the collapse of…Sep 29, 2006 · N1949W · Substantial damageNTSB NYC06CA213Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Frederick, MDThe flight instructor's delayed remedial action during a hovering autorotation, which resulted in a hard landing and inadvertent dynamic rollover.Aug 28, 2006 · N2649D · Substantial damageNTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.Aug 3, 2006 · N20965 · Substantial damageNTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.Jul 29, 2006 · N97650 · Substantial damageNTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.Jul 12, 2006 · N1725V · Substantial damageNTSB CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.Jul 7, 2006 · N7349G · Substantial damageNTSB ANC06CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for a tailwind during the landing flare, which resulted in an in-flight collision with snow-covered terrain during an aborted landing. Factors contributing to the accident were a tailwind and rising terrain.May 29, 2006 · N2945M · Substantial damageNTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.May 1, 2006 · N738DW · Substantial damageNTSB MIA06CA084Accident · No injuriesData collectionFinal reportLinwood R. Lawrence Van's Aircraft RV-9A · Venice, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.Apr 8, 2006 · N339DL · Substantial damageNTSB MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.Mar 31, 2006 · N172FL · Substantial damageNTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.Mar 28, 2006 · N20488 · Substantial damageNTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.Mar 26, 2006 · N6123D · Substantial damage