NTSB investigations: Lycoming O&VO-360 series, 1999, FL

6 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 O&VO-360 series, 1999, FL per year, 1964–2026: 331 cases
19644
196510
196612
19677
19688
19695
19705
19718
19725
19737
19749
19753
19763
19777
19787
19798
19806
198110
19823
19835
19843
19857
19867
19874
19888
19892
19906
19922
19938
19945
19954
19964
19974
19989
19996
20003
200111
20023
20036
20046
20056
20065
20076
20086
20095
20102
20114
20124
20146
20154
20164
20178
20183
20194
20203
20214
20223
20232
20243
20256
20263

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\") = 1999
    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 ('41514'))
  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 MIA99LA270Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLthe pilot's failure to ensure that the landing gear was down and locked following loss of electrical power for undetermined reasons, resulting in substantial damage to the airplane when the right main landing gear collapsed upon landing.Sep 24, 1999 · N9536B · Substantial damageNTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.Jul 17, 1999 · N3030Q · Substantial damageNTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.Jun 11, 1999 · N5238P · Substantial damageNTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.May 28, 1999 · N9561B · Substantial damageNTSB MIA99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Fernandina Bch, FLThe failure of the pilot to use the printed checklist which resulted in the gear-up landing. A factor associated with the accident was the intermittent failure of the gear warning horn.Apr 22, 1999 · N7059P · Substantial damageNTSB MIA99LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and subsequent impact with the runway.Mar 6, 1999 · N2890X · Substantial damage