OpenAirDocs.org

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

9 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

Where

Open the map

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\") = 2012
    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 ERA13CA073Accident · No injuriesData collectionFinal reportBeech B19 · Fort Lauderdale, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.Dec 1, 2012 · N2196W · Substantial damageNTSB ERA12CA466Accident · No injuriesData collectionFinal reportCessna 172P · St. Augustine, FLUndetermined due to a lack of information about when the damage to the airplane occurred.Jul 18, 2012 · N127EP · Substantial damageNTSB ERA12LA442Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pensacola, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.Jul 11, 2012 · N6258J · Substantial damageNTSB ERA12LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot of another airplane to set the parking brake and to maintain a proper visual lookout, which resulted in an on-ground collision.May 23, 2012 · N47749 · 2 aircraft · Minor damageNTSB ERA12LA312Accident · Minor injuriesLimited investigationFinal reportShoup Ronald R RV-6A · Milton, FLA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Apr 30, 2012 · N819RS · Substantial damageNTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.Apr 28, 2012 · N746RA · Substantial damageNTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.Mar 24, 2012 · N99087 · Substantial damageNTSB ERA12LA234Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLA total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.Mar 16, 2012 · N79509 · Substantial damageNTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…Jan 6, 2012 · N8066U · Substantial damage