Skip to content

NTSB investigations: Lycoming 0-360-A1D

256 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, newest first

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."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.\"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."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 ANC93LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Katmai, AKThe unsuitable terrain selected by the pilot-in-command. Factor was soft terrain condition.Jun 18, 1993 · N7300G · Substantial damage NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.Jun 4, 1993 · N6349C · Substantial damage NTSB LAX93LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Las Vegas, NVThe pilot's failure to maintain directional control of the aircraft during the touchdown. Factors in the accident were the pilot's lack of experience and his failure to maintain a balance between the wing fuel tanks.Apr 26, 1993 · N83364 · Substantial damage NTSB LAX93LA082Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Oceano, CAThe pilot's operation of the aircraft with known deficiencies in the brake system.Dec 30, 1992 · N5653R · Substantial damage NTSB SEA93LA037Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Garden Valley, IDInadequate preflight planning and preparation. Factors include the snow covered runway.Dec 13, 1992 · N5652W · Substantial damage NTSB ATL93LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Clarksville, TNThe fracture of the section gear in the main landing gear retraction and extension mechanism.Oct 15, 1992 · N9797B · Substantial damage NTSB NYC93LA011Accident · Serious injuriesLimited investigationFinal reportAnderson Pitts S-1 · Minersville, PAA loss of control due to a foreign object jamming the elevator flight controls.Oct 8, 1992 · N31SP · Destroyed 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 CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…Mar 8, 1992 · N105A · Substantial damage NTSB ATL91LA118Accident · No injuriesLimited investigationFinal reportMaule MXT-180 · Mobile, ALThe pilot's failure to properly compensate for wind conditions. A factor to this accident was the gusting winds.Jun 23, 1991 · N9217T · 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 CHI91DEE02Accident · Minor injuriesFinal reportMaule M-4-220C · Romeoville, ILThe pilot's inadequate preflight inspection resulting in power loss from fuel contamination. A factor in the accident was the owner's failure to accomplish airworthiness directive 84-9-7 which provided direct, convenient access to sample and purge the main…Dec 11, 1990 · N40614 · Substantial damage NTSB FTW90LA084Accident · No injuriesLimited investigationFinal reportCessna 172G · Rio Hondo, TXOil starvation induced power loss due to improper maintenance procedures. Contributing to the accident were inadequate maintenance inspection and the soft terrain in which the forced landing was performed.Mar 17, 1990 · N4696L · Substantial damage NTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.Mar 11, 1990 · N35485 · Substantial damage NTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.May 28, 1989 · N17184 · Substantial damage NTSB CHI86LA232Accident · Serious injuriesLimited investigationFinal reportMcculloch J-2 · Rush City, MNJust after lift off, while taking off with a tail wind, the plt diverted his attention to the instrument panel & did not realize the gyrocopter was going into an unusual attitude. He said that when he did notice what had happened, he 'just got ready for the…Sep 26, 1986 · N90563 · Destroyed NTSB MKC86LA040Accident · No injuriesLimited investigationFinal reportBeech C23 · Dubuque, IAThe aircraft landed on runway 13 because the n-s runway was covered with ice. The wind was from 220 degrees at 16, gusts to 24 knots. The aircraft bounced twice during the landing and drifted left. The aircraft encountered snow along the left side of the…Dec 30, 1985 · N67248 · Substantial damage NTSB FTW85LA278Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Austin, TXThe eng failed at about 2000 ft MSL while the acft was climbing to cruise flt. The plt attempted to turn back to the arpt but realized it was too FAR away. The plt then made a forced landing in a grass area adjacent to a large hwy at about a 45 deg angle to…Jul 9, 1985 · N8203D · Substantial damage NTSB SEA85LA139Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Ontario, ORThe plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at…Jun 15, 1985 · N5652W · Substantial damage NTSB MKC85LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Pratt, KSStudent pilot was on his second cross-country flight to this airport. He stated that after touchdown, he reached to raise the flaps and the airplane started to drift. He overcorrected and went off left side of the runway and nosed over when he went through a…Jun 15, 1985 · N6723C · Substantial damage NTSB ATL85LA139Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNPilot lost directional control during landing and skidded of the left side of runway. Pilot reported windshift.Apr 18, 1985 · N86756 · Substantial damage NTSB DEN85FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Vail, COThe plt did not obtain a wx briefing, file a flight plan or refuel the acft prior to departing for eagle Colorado. The acft departed at 1800 under VFR cond. The plt reported over minturn co at 2019. Witnesses at Vail co stated that the wx cond were poor from…Mar 22, 1985 · N8359B · Destroyed NTSB DEN85LA071Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Grand Forks, NDOn Sunday 1/27/85 at approximately 0849 MST, a Beech DUCHESSN1850S, on lease to the university of north dakota crashed after takeoff from the Grand Forks airport, Grand Forks, ND.the student pilot and certified flight instructore were not injured. Two…Jan 27, 1985 · N1850S · Substantial damage NTSB LAX84LA270Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Fair Oaks, CABefore departing on a x-country flt, the plt was warned to refuel midway on his route. He recalculated his fuel while en route & thought sufficient fuel was remaining. During arrival, the plt activated the rwy lights, but did not see them until he was nearly…Apr 28, 1984 · N81784 · Destroyed NTSB ATL83LA342Accident · No injuriesLimited investigationFinal reportAir & Space 18-A · Murray, KYAprx 400 ft AGL, while executing a jump takeoff and a right turn, the aircraft began to settle. It then struck trees and then the ground. The temperature was 100 degrees f. the pilot stated that more attention should have been paid to ambient conditions.Aug 27, 1983 · N6155S · Substantial damage NTSB NYC83FA088Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Hawthorne, NYThe flt departed cleveland at 1539. The flt enroute was conducted at 6,000 ft. about 45 mi w of destination the fuel gages indicated 5 gals of fuel in each of the two tanks. At about 5 mi w of the arpt the eng quit. The plt made a forcedlanding on the…Apr 10, 1983 · N8302T · Substantial damage NTSB ATL82FLJ06Accident · 2 fatalFinal reportBede BD-4 · Knightdale, NCTwo witnesses observed the aircraft on a low final approach for runway 19. They reported that the aircraft then turned to an easterly heading. One witness reported that the left turn appeared to be coordinated. The other witness heard the pilot add power…Mar 18, 1982 · N223LW · Destroyed NTSB FTW82DPJ09Accident · No injuriesClosedGrumman AA5B · Guymon, OKDec 27, 1981 · N3773N · Substantial damage NTSB DEN82FTG01Accident · No injuriesClosedPietsch GJ · Minot, NDSep 15, 1981 · N180WP · Substantial damage NTSB MIA81DLA06Accident · No injuriesClosedMooney M20C · Bunnell, FLDec 4, 1980 · N3603H · Substantial damage NTSB ANC80DAG54Accident · No injuriesClosedBellanca 8GCBC · Kashwitna Riv, AKMay 7, 1980 · N57690 · Substantial damage NTSB MKC80FCQ14Accident · Minor injuriesClosedBucker Jung BU131 · Colwich, KSMay 4, 1980 · N80424 · Substantial damage NTSB FTW80DQG12Accident · No injuriesClosedPitts S-1S · Midland, TXMar 21, 1980 · N117Q · Minor damage NTSB MIA80DKT25Accident · Serious injuriesClosedMooney M20C · Marco Island, FLFeb 6, 1980 · N3256F · Substantial damage NTSB LAX79FUG35Accident · No injuriesClosedMooney M20C · Bermuda Dunes, CAMar 6, 1979 · N666GS · Substantial damage NTSB MIA79FLA07Accident · No injuriesClosedMooney M20C · Daytona Beach, FLOct 27, 1978 · N7092V · Substantial damage NTSB DEN78FTE61Accident · No injuriesClosedMooney M20C · Bennett, COJun 6, 1978 · N3528H · Substantial damage NTSB OAK77DVG50Accident · Minor injuriesClosedMooney M20C · Auburn, CAJul 14, 1977 · N7044V · Substantial damage NTSB SEA76DTI37Accident · Minor injuriesClosedPiper PA-28 · Turner, MTAug 16, 1976 · N9051J · Substantial damage NTSB MIA76FKG20Accident · No injuriesClosedBellanca 8GCBC · Waynesboro, GASep 1, 1975 · N86756 · Substantial damage NTSB FTW75DPJ01Accident · No injuriesClosedAir & Space 18A · Boise City, OKJul 24, 1974 · N6121S · Substantial damage NTSB CHI73FEI33Accident · No injuriesClosedPiper PA-24 · U.Sandusky, OHApr 6, 1973 · N5188P · Substantial damage NTSB FTW73FQG29Accident · Minor injuriesClosedPiper PA-28R · Odessa, TXFeb 4, 1973 · N5046S · Substantial damage NTSB MKC73DCD36Accident · No injuriesClosedCessna 172 · Columbus Jct, IAOct 8, 1972 · N6403E · Substantial damage NTSB MIA73FKJ24Accident · No injuriesClosedPiper PA-18 · Tuscaloosa, ALSep 29, 1972 · N3949Z · Substantial damage NTSB CHI72FEA04Accident · Minor injuriesClosedMooney M-20C · Watson, INAug 2, 1972 · N9289V · Substantial damage NTSB DEN72FQA22Accident · No injuriesClosedCessna 172 · Bernalillo, NMOct 4, 1971 · N35485 · Substantial damage NTSB NYC71FGM10Accident · No injuriesClosedCessna 177A · Bedford, PAAug 24, 1970 · N30418 · Substantial damage NTSB FTW70F0246Accident · No injuriesClosedMooney M-20C · Oklahoma Cty, OKOct 13, 1969 · N9289V · Substantial damage NTSB DIA67F0082Accident · Minor injuriesClosedPiper PA-24 · Alexandria, VAMay 1, 1967 · N7566P · Substantial damage