NTSB investigations: Lycoming I0360 series, 2012

7 cases on aircraft whose registry engine model is Lycoming I0360 series, where the defining event was Loss of control in flight. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

NTSB investigations: Lycoming I0360 series, 2012 per year, 2008–2026: 72 cases
2008	7
2009	2
2010	5
2011	5
2012	7
2013	4
2014	4
2015	1
2016	6
2017	5
2018	3
2019	7
2020	3
2021	3
2023	4
2024	1
2025	3
2026	2

Where

Open the map

Latest cases

Query with SQL

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
  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.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN12FA572Accident · Serious injuriesField investigationFinal reportEberle John S Fokker DR-1 Triplane · Parker, COThe pilot's loss of control of the airplane due to the airplane’s reduced climb performance during high density altitude operations.Aug 26, 2012 · N152RB · Substantial damage NTSB CEN12CA598Accident · No injuriesData collectionFinal reportMooney M20E · Gresham, WIThe pilot's failure to maintain airplane control and clearance from field corn during takeoff.Aug 17, 2012 · N5642Q · Substantial damage NTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.Jul 24, 2012 · N9679F · Substantial damage NTSB CEN12LA467Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Miami, TXAn in-flight loss of control on final approach for undetermined reasons.Jul 21, 2012 · N9720Q · Substantial damage NTSB CEN12CA402Accident · No injuriesData collectionFinal reportSchweizer TH55A/269A · Grinnell, IAThe pilot’s inadequate compensation for the wind during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.Jun 26, 2012 · N488MC · Substantial damage NTSB CEN12LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Arcola, TXThe pilot did not maintain adequate crosswind correction during the landing flare and the flight instructor's delayed remedial action.Mar 18, 2012 · N56273 · Substantial damage NTSB CEN12FA170Accident · 2 fatalField investigationFinal reportMooney M20E · San Antonio, TXThe pilot's inadvertent overboost of the turbocharged engine during initial climb, which resulted in detonation and a partial loss of engine power followed by the pilot's failure to maintain airspeed and the instructor's delayed remedial action, which…Feb 26, 2012 · N9224M · Substantial damage