Skip to content

NTSB investigations: Lycoming 0-320 series, IA

193 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.

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."eventStateOrRegion" = 'IA' 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

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\" = 'IA' 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.

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" = 'IA' 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

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 MKC86LA158Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Audubon, IAThe pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,…Jul 27, 1986 · N9835U · Substantial damage NTSB MKC86LA160Accident · No injuriesLimited investigationFinal reportHuizenga SEA Hawk · Clinton, IADuring a test flt of an experimental sea plane, the plt rptd a loss of eng pwr during a turn in the traffic pattern at Clinton airport. The plt stated he had 5 gallons of fuel onboard and had flown about 2 tenths of an hour. Inspection of the fuel system…Jul 25, 1986 · N85CK · Substantial damage NTSB MKC85FCD01Accident · 1 fatalFinal reportJoel K. Senter RV-4 · Jefferson, IAThe acft crashed out of control after & low alt demonstration passes above rwy at about 50 ft AGL. After the last pass, a low airspeed maneuver. The plt executed a steep turn and descended in a nose low attitude to ground impact.Jun 16, 1985 · N4703S · Destroyed NTSB MKC85LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Madison, IAThe plt stated that an inflight encounter with a gust of wind during landing resulted in a sharp loss of altitude and a bounced landing. Consequently a second gust on rollout followed by the plts loss of directional control resulted in the acft departing the…Feb 16, 1985 · N61868 · Substantial damage NTSB MKC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Algona, IAAt about 100 ft AGL after takeoff, eng lost pwr. Plt attempted to circle to land on closest runway but eng was developing insufficient pwr to maintain altitude in turn. Acft touched down 150 ft short of threshold. Plt did not level wings prior to touchdown.…Nov 7, 1984 · N4312Z · Substantial damage NTSB MKC84LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkader, IAThe acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow…Jan 8, 1984 · N73043 · Substantial damage NTSB MKC84LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa Falls, IAThe acft swerved and collided with a snowbank alongside the rwy during landing. The pilot stated that she hit some snow and ice on the rwy and when the acft started to slide she lost control. The acft turned left and when the left wing hit the snowbank the…Dec 26, 1983 · N9565W · Substantial damage NTSB MKC83LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Atlantic, IAThe aircraft swerved off the left side of the runway collided with a fence and nosed over in a freshly plowed field during landing. The acft was owned by the pilot and was being landed on the pilots private airstrip at his farm. The pilot indicated that the…May 16, 1983 · N8094N · Substantial damage NTSB MKC83FA041Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Bancroft, IAThe acft impacted the ground in a near wings level, 20 deg nose down attitude at a high rate of speed. Witnesses statedthat the weather was clear & visibility good but it was a very dark night with only a very small portion of the moon showing. The only…Dec 20, 1982 · N2838V · Destroyed NTSB MKC82DA130Accident · Minor injuriesFinal reportPiper PA-28 · Council Bluffs, IAThe pilot was making his first solo landing, swerved off the runway, attempted a go-around and collided with a ditch.Jul 24, 1982 · N9391C · Substantial damage NTSB MKC82DA103Accident · No injuriesFinal reportCessna 172N · Marion, IAThe pilot reported that he took off, stayed in the traffic pattern, and made a normal approach with one notch of flaps at about 75 mph. He stated that on final approach, the wind shifted from 350 to almost 180 degrees. He landed long and was unable to stop on…Jun 13, 1982 · N5158E · Substantial damage NTSB MKC82DA051Accident · No injuriesFinal reportCessna 172L · Des Moines, IAThe pilot landed on runway 23 with the wind from 230 degrees at 34 gusting 40 knots. After turning off to the right side of the runway, a gust of wind tipped the aircraft, turned it further to the right, and then blew it over on its back.Mar 30, 1982 · N4325Q · Substantial damage NTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…Feb 16, 1982 · N44710 · Substantial damage NTSB MKC82FA001Accident · 2 fatalClosedVarga 2150A · Glenwood, IAOct 2, 1981 · N8334J · Destroyed NTSB MKC81DCD31Accident · No injuriesClosedPiper PA-22 · Burlington, IAAug 9, 1981 · N9701D · Substantial damage NTSB MKC81DCD30Accident · No injuriesClosedCessna 172M · Oxford, IAAug 9, 1981 · N20029 · Substantial damage NTSB MKC81DCD23Accident · No injuriesClosedThorp T-18 · Waterloo, IAJul 11, 1981 · N179RW · Substantial damage NTSB MKC81DCD10Accident · No injuriesClosedCessna 172 · Spencer, IAFeb 22, 1981 · N7318G · Substantial damage NTSB MKC80DCD03Accident · No injuriesClosedPiper PA-28 · Oelwein, IAOct 24, 1979 · N538FL · Substantial damage NTSB MKC79FCD18Accident · No injuriesClosedCessna 172 · Fort Dodge, IAApr 26, 1979 · N734LV · Substantial damage NTSB MKC79DCD02Accident · No injuriesClosedCessna 172 · Williams, IAOct 10, 1978 · N80310 · Substantial damage NTSB MKC78DCD57Accident · No injuriesClosedCessna 172 · Jesup, IASep 30, 1978 · N46438 · Substantial damage NTSB MKC78DCD55Accident · No injuriesClosedPiper PA-25 · Milford, IASep 7, 1978 · N6447Z · Substantial damage NTSB MKC78FCD27Accident · No injuriesClosedPiper PA-28 · Anamosa, IAMay 24, 1978 · N5192W · Substantial damage NTSB MKC78FCD20Accident · No injuriesClosedCessna 177 · Des Moines, IAMay 10, 1978 · N3158T · Substantial damage NTSB MKC78FA020Accident · 3 fatalClosedPiper PA-22 · Tama, IAJan 15, 1978 · N6819B · Destroyed NTSB MKC78FCD08Accident · Serious injuriesClosedCessna 172M · Lamoni, IAOct 21, 1977 · N21210 · Substantial damage NTSB MKC77DCD47Accident · No injuriesClosedBeech B19 · Akron, IASep 11, 1977 · N9174S · Substantial damage NTSB MKC77DCD42Accident · No injuriesClosedPiper PA-28 · Burlington, IAAug 27, 1977 · N15203 · Substantial damage NTSB MKC77FCD34Accident · No injuriesClosedPiper PA-28 · New Liberty, IAJul 20, 1977 · N5508U · Substantial damage NTSB MKC77FCD33Accident · No injuriesClosedAmer Avco AA-5A · Osage, IAJul 4, 1977 · N9580U · Substantial damage NTSB MKC77FCD28Accident · No injuriesClosedAmer Avco AA-5A · Boone, IAJul 3, 1977 · N9873U · Substantial damage NTSB MKC77DCD24Accident · No injuriesClosedBellanca 7GCAA · Moulton, IAJun 27, 1977 · N8739 · Substantial damage NTSB MKC77IA008Incident · No injuriesClosedPiper PA-28 · Muscatine, IADec 16, 1976 · N6474W · 2 aircraft · Minor damage NTSB MKC77DCD04Accident · No injuriesClosedPiper PA-28 · Atlantic, IANov 15, 1976 · N8701N · Substantial damage NTSB MKC76DCD56Accident · No injuriesClosedPiper PA-28 · Cherokee, IAJun 23, 1976 · N461CT · Substantial damage NTSB MKC76DCD49Accident · No injuriesClosedPiper PA-22 · Larchwood, IAJun 13, 1976 · N5933D · Substantial damage NTSB MKC76DCD38Accident · No injuriesClosedCessna 172 · Council Bluffs, IAApr 8, 1976 · N84412 · Substantial damage NTSB MKC76DCD35Accident · No injuriesClosedPiper PA-28 · Castalia, IAMar 28, 1976 · N4203J · Substantial damage NTSB MKC76DCD34Accident · No injuriesClosedPiper PA-22 · Hartley, IAMar 20, 1976 · N5728D · Substantial damage NTSB MKC76DCD19Accident · No injuriesClosedPiper PA-22 · Marble Rock, IANov 2, 1975 · N9651D · Substantial damage NTSB MKC76FCD14Accident · 1 fatalClosedPiper PA-28 · Montezuma, IASep 28, 1975 · N44657 · Substantial damage NTSB MKC76DCD09Accident · No injuriesClosedPiper PA-28 · Riceville, IASep 1, 1975 · N555NA · Substantial damage NTSB MKC75FCD32Accident · Minor injuriesClosedPiper PA-28 · Estherville, IAJan 16, 1975 · N6671J · Substantial damage NTSB MKC75FCD01Accident · No injuriesClosedPiper PA-25 · Southerland, IAJul 4, 1974 · N6374Z · Substantial damage NTSB MKC74DCD44Accident · No injuriesClosedPiper PA-28 · Mason City, IAJun 23, 1974 · N5613U · Substantial damage NTSB MKC74AK037Accident · 1 fatalClosedChampion 7GCAA · Andover, IAJan 15, 1974 · N9609S · Destroyed NTSB MKC73DCD19Accident · No injuriesClosedPiper PA-28 · Oelwein, IANov 3, 1973 · N1330T · Substantial damage NTSB MKC74DCD18Accident · No injuriesClosedCessna 172 · Davenport, IAOct 14, 1973 · N19749 · Substantial damage NTSB MKC74DCD17Accident · Serious injuriesClosedPiper PA-22 · West Branch, IAOct 8, 1973 · N3336Z · Substantial damage