NTSB investigations: Lycoming 0-320 series, 1992

12 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, 1992 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\") = 1992
    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 CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.Oct 27, 1992 · N75823 · Substantial damageNTSB DEN93LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spring, COProper descent rate was not maintained by the pilot in command which resulted in a hard landing.Oct 18, 1992 · N1450U · Substantial damageNTSB CHI92LA294Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Grand Forks, NDThe pilot's premature flare.Sep 29, 1992 · N150ND · Substantial damageNTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.Sep 15, 1992 · N96593 · Substantial damageNTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.Jun 14, 1992 · N97883 · Substantial damageNTSB LAX92LA238Accident · No injuriesLimited investigationFinal reportCessna 177A · Mariposa, CAThe pilot's poorly planned approach for landing, his failure to initiate a go-around, his failure to obtain the proper touchdown point, his misjudgment of the touchdown flare, and his improper recovery from a bounced landing. A factor in this accident was the…Jun 7, 1992 · N3144T · Substantial damageNTSB SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.May 23, 1992 · N116DC · Substantial damageNTSB MIA92LA123Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Fort Lauderdale, FLDelay by the CFI to take remedial action. Contributing to the accident was the students premature flare.May 17, 1992 · N4026Q · Substantial damageNTSB LAX92LA162Accident · No injuriesLimited investigationFinal reportRobinson R22B · Simi Valley, CAThe instructor pilot's delayed flare from the autorotation landing. A contributing factor was the soft nature of the terrain.Apr 3, 1992 · N504RS · Substantial damageNTSB FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.Mar 16, 1992 · N96493 · Substantial damageNTSB LAX92LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe pilot's misjudged landing flare and her improper bounced landing recovery technique. Contributing factors were the airplane's excessive approach airspeed and the student's lack of experience.Mar 9, 1992 · N98662 · Substantial damageNTSB ATL92LA055Accident · No injuriesLimited investigationFinal reportPitts S-1 · Reidsville, NCThe pilot's failure to compensate for the tailwind and the improper touch down point. Factors were the tailwind and downdraft which resulted from the tall obstacles (trees) around the runway.Mar 1, 1992 · N517L · Substantial damage