NTSB investigations: Lycoming I0360 SER A&C, CT

9 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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

19862026

NTSB investigations: Lycoming I0360 SER A&C, CT per year, 1986–2026: 9 cases
1986	1
1993	2
1998	1
1999	1
2004	1
2005	1
2020	1
2021	1

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 c."eventStateOrRegion" = 'CT' 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 ('41511')) 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 c.\"eventStateOrRegion\" = 'CT' 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 ('41511'))
  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 c."eventStateOrRegion" = 'CT' 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 ('41511'))
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 ERA21LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Groton, CTThe pilot’s failure to maintain directional control of the airplane during landing, resulting in a runway excursion and collision with an airport sign.Jun 13, 2021 · N430EP · Substantial damage NTSB ERA20CA294Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB200 · Simsbury, CTA runway excursion following an aborted takeoff in tailwind conditions.Aug 22, 2020 · N156BB · Substantial damage NTSB IAD05CA054Accident · No injuriesData collectionFinal reportClark/Loken Christen Eagle II · South Woodstock, CTThe pilot's improper flare, which resulted in a hard landing.Apr 10, 2005 · N130MC · Substantial damage NTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.Jun 21, 2004 · N356ES · Substantial damage NTSB NYC00LA054Accident · No injuriesLimited investigationFinal reportMooney 20J · New Milford, CTFailure of 3 of the 4 connecting rods for an undetermined reason.Dec 17, 1999 · N43TP · Substantial damage NTSB NYC98FA095Accident · 1 fatalField investigationFinal reportMooney M20J · Bridgeport, CTThe pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…Apr 20, 1998 · N40HL · Destroyed NTSB NYC93LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20J · New Haven, CTThe loss of airplane control as a result of the pilot encountering spatial disorientation. Factors in this accident were the low ambient light conditions and the lack of runway end identifier lightsJun 9, 1993 · N1157B · Substantial damage NTSB BFO93LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Willimantic, CTFailure of the pilot to follow emergency procedures to ensure that the gear was locked. A factor related to the accident was the total electrical failure and the construction site located beside the runway.May 2, 1993 · N81529 · Substantial damage NTSB NYC86LA208Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Hartford, CTThe Beech 24R pilot noticed a build-up of a substance on the windshield. He also experienced a problem controlling the propeller. He said upon landing he could not judge forward visibility and flared high (30-40 ft). The pilot reported that the aircraft…Aug 2, 1986 · N6637E · No damage