Skip to content

NTSB investigations: Lycoming 0-360-A1D, FL

20 cases on aircraft whose registry engine model is Lycoming 0-360-A1D. 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

19652026

Where

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" = '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 ('41504')) 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\" = '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 ('41504'))
  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" = '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 ('41504'))
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 ERA25LA109Accident · Serious injuriesClass 4 · LimitedFinal reportNear William J RV-7A · Weirsdale, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent nose over.Feb 5, 2025 · N811WJ · Substantial damage NTSB ERA21LA080Accident · 1 fatalClass 3 · LimitedFinal reportSocata TB10 · Pembroke Pines, FLThe pilot’s failure to use carburetor heat in environmental conditions favorable for serious carburetor ice during a prolonged wait with the engine at a low power setting before takeoff, which resulted in a partial loss of engine power due to carburetor ice.…Dec 17, 2020 · N5547Y · Destroyed NTSB ERA15LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Palm Beach, FLThe failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…Jan 28, 2015 · N54380 · 2 aircraft · Minor damage NTSB ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…Aug 10, 2014 · N214MJ · Substantial damage NTSB NYC07CA120Accident · Serious injuriesData collectionFinal reportMaule MXT-7-180A · St Petersburg, FLThe pilot's failure to obtain the proper climb rate to clear an obstacle after aborting the landing. Factors in the accident were the pilot's failure to maintain directional control during landing, which prompted the aborted landing, and a wind gust.May 17, 2007 · N1044M · Destroyed NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.Feb 8, 2007 · N9395B · Substantial damage NTSB MIA07LA026Accident · No injuriesLimited investigationFinal reportLingwall Rebich-Pitts · Naples, FLThe experimental airplane's pilot inadequate visual lookout while taxiing for takeoff, which resulted in an on-ground collision with a Piper airplane which was standing with its engine operating in the runup area.Dec 13, 2006 · N427RD · 2 aircraft · Minor damage NTSB MIA02LA156Accident · No injuriesLimited investigationFinal reportAviat A1 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing rollout while landing in a crosswind which resulted in the airplane inadvertently veering off the runway and incurring damage when the pilot forced it into a ground loop to avoid entry…Aug 8, 2002 · N13HU · Substantial damage NTSB MIA01LA017Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLan inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.Oct 21, 2000 · N928ER · Substantial damage NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.Feb 19, 2000 · N68197 · Substantial damage NTSB MIA98LA190Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Daytona Beach, FLThe pilot's failure to maintain airspeed, which resulted in a stall. A contributing factor was the pilot's delay in initiating remedial action.Jun 27, 1998 · N32HU · Substantial damage NTSB MIA97FA217Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Naples, FLleaking fuel cap(s), due to inadequate maintenance/repair, which resulted in water contamination of the fuel; inadequate preflight by the flight crew; and improper planning/decision by the flight crew. Factors relating to the accident were: high obstructions…Jul 25, 1997 · N28246 · Substantial damage NTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.Mar 28, 1994 · N9786B · Substantial damage NTSB MIA92LA149Accident · No injuriesLimited investigationFinal reportMooney M20C · Pass-A-Grille, FLTotal loss of engine power due to fuel starvation.Jul 13, 1992 · N9379A · Substantial damage NTSB MIA91LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe pilot's selection of the wrong runway for wind conditions.May 15, 1991 · N83021 · Substantial damage NTSB MIA81DLA06Accident · No injuriesClosedMooney M20C · Bunnell, FLDec 4, 1980 · N3603H · Substantial damage NTSB MIA80DKT25Accident · Serious injuriesClosedMooney M20C · Marco Island, FLFeb 6, 1980 · N3256F · Substantial damage NTSB MIA79FLA07Accident · No injuriesClosedMooney M20C · Daytona Beach, FLOct 27, 1978 · N7092V · Substantial damage NTSB MIA66D0556Accident · No injuriesClosedPiper PA-24 · Pensacola, FLApr 6, 1966 · N7566P · Substantial damage NTSB MIA66F0011Accident · No injuriesClosedPiper PA-24 · St Petersburg, FLMay 26, 1965 · N7488P · Substantial damage