Skip to content

NTSB investigations: Lycoming 0-320 series, NE

187 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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 MKC89LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Ainsworth, NEThe loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.Jan 29, 1989 · N4843G · Substantial damage NTSB MKC89LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crete, NEThe pvt pilot said shortly after takeoff, the engine coughed, sputtered, then quit. An emergency ldg was attempted on a farm field which resulted in substantial damage to the acft, serious injury to the pax and minor injuries to the pilot. Post accident…Dec 8, 1988 · N5875W · Substantial damage NTSB MKC88LA052Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEThe pilot said that he was using outdated charts for his destination apt. He failed to notice a new runway. He also failed to notice the yellow x's, signifying closure of the old runway. It was almost parallel to the runway, within ten degrees of heading. Ldg…Feb 11, 1988 · N12600 · Substantial damage NTSB MKC86LA182Accident · No injuriesLimited investigationFinal reportCessna 172 · Hayes Center, NEWhile en route, the plt encountered deteriorating wx conditions. He stated that he found himself above an overcast with visibilities decreasing. He saw a hole in the cloud layer and descended thru it. He stated that wx conditions were bad below the cloud…Aug 30, 1986 · N75571 · Substantial damage NTSB MKC86LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bertrand, NEThe pilot stated that he was on an unsupervised local solo flight when he decided to land at a private airstrip. As he had driven his automobile on this runway four days prior to the accident and had found the landing surface clear he assumed that the runway…Aug 24, 1986 · N5376F · Substantial damage NTSB MKC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ashby, NEThe plt stated that he and a passenger were sightseeing when he increased the mixture to full rich, applied carb heat and reduced power for a glide across a valley. When he advanced the throttle to level off the engine did not respond. During the forced…May 11, 1986 · N7255D · Substantial damage NTSB MKC86LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weeping Water, NEThe pilot stated that he was going too fast when he touched down on the short runway and should have made a go around. The airplane went off the end of the runway, went down a slope and impacted a piloe of rocks.Oct 25, 1985 · N47734 · Substantial damage NTSB MKC85LA192Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Grand Island, NEDuring flt, the plt encountered radio receiver problems & diverted to Grand Island, NE. During arrival, he requested a special VFR clearance, but could not ascertain if the tower had answered. Radio communication was established in the traffic pattern & the…Jul 29, 1985 · N9937Y · Substantial damage NTSB MKC85LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Minden, NEPlt said that he was unable to clear wires at the end of the 2,100 ft long, sod, farm, strip. He said he began truning to avoid the wires and in the turn the acft settled, the rt wing hit the ground and the acft crashed. The acft weight was near max allowable…Jul 29, 1985 · N98193 · Substantial damage NTSB MKC85LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Curtis, NEThe plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing…Jun 8, 1985 · N2267E · Substantial damage NTSB MKC84LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Fremont, NEThe pilot selected a downwind rwy for landing. Touchdown was nose gear first, followed by a porpoise and a go-around. On the second approach to the same runway, touchdown was again nose first and the aircraft porpoised twice before landing was completed. The…Jun 8, 1984 · N97163 · Substantial damage NTSB MKC84LA096Accident · No injuriesLimited investigationFinal reportCessna 172P · Broken Bow, NEA gust of wind overturned the acft during taxi from landing. The wind was from 330 degrees at 24 KTS gusting to 34 KTS.Mar 7, 1984 · N52252 · Substantial damage NTSB MKC83LA047Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearney, NEPilot landed on icy runway and started to swerve. Go-around was initiated. Before aircraft could takeoff it collided with a snow bank.Dec 31, 1982 · N6532F · Substantial damage NTSB MKC83FA025Accident · 3 fatalField investigationFinal reportCessna 172K · Oxford, NEThe pilot made 3 low passes near his son's home. Reportedly, the 3rd pass was made at an altitude of about 40 to 50 ft AGL. A witness then observed the pilot pull up abruptly to about a 45 deg climb. After climbing an additional 40 to 50 ft, the aircraft…Nov 25, 1982 · N79173 · Destroyed NTSB MKC82DA152Accident · Minor injuriesFinal reportCessna 172 · Thedford, NEThe pilot reported that after he took off on a dark night, he remembered there were obstacles in that area and he reversed his direction of turn. He stated that after reversing the turn, he became disoriented and the aircraft dove into the ground.Aug 22, 1982 · N3419E · Substantial damage NTSB MKC82FCJ03Accident · Serious injuriesFinal reportCessna 177 · Near Qgallala, NEThe pilot reported that during the preflight, there was about 4 inches of fuel in one tank and about 3 inches in the other tank. However, he did not remember the accident or what happended for about a week thereafter. Witnesses reported that the engine quit…Jun 27, 1982 · N29397 · Destroyed NTSB MKC82DA072Accident · No injuriesFinal reportPiper PA-18 · North Loup, NEThe pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…May 7, 1982 · N4339Z · Substantial damage NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…Feb 22, 1982 · N4812A · Destroyed NTSB MKC80DCJ31Accident · No injuriesClosedPiper PA-28 · Ogallala, NESep 7, 1980 · N5376F · Substantial damage NTSB MKC80FCJ10Accident · No injuriesClosedPiper PA-22 · Lincoln, NEApr 18, 1980 · N8631D · Substantial damage NTSB MKC80DCJ05Accident · No injuriesClosedCessna 172M · Sidney, NEJan 6, 1980 · N64294 · Substantial damage NTSB MKC79DCJ39Accident · No injuriesClosedPiper PA-28 · Omaha, NESep 23, 1979 · N54435 · Substantial damage NTSB MKC79DCJ33Accident · Minor injuriesClosedPiper PA-28 · Hay Springs, NEAug 11, 1979 · N4513R · Substantial damage NTSB MKC79DCJ25Accident · Minor injuriesClosedCessna 172 · Omaha, NEJun 30, 1979 · N5520D · Destroyed NTSB MKC79DCJ22Accident · No injuriesClosedGrumman AA5A · Oneill, NEJun 2, 1979 · N9910U · Substantial damage NTSB MKC79DCJ12Accident · No injuriesClosedCessna 172 · Kearney, NEMar 13, 1979 · N8945V · Substantial damage NTSB MKC79FCJ01Accident · Minor injuriesClosedPiper PA-22 · Merriman, NEOct 9, 1978 · N9603D · Substantial damage NTSB MKC78DCJ15Accident · No injuriesClosedPiper PA-28 · Lincoln, NEMar 30, 1978 · N56705 · Substantial damage NTSB MKC78DCJ11Accident · No injuriesClosedCessna 172 · Thedford, NEMar 2, 1978 · N79445 · Substantial damage NTSB MKC77DCJ35Accident · No injuriesClosedPiper PA-18 · Cody, NEJul 30, 1977 · N83332 · Substantial damage NTSB MKC77FA024Accident · 4 fatalClosedCessna 172M · Gordon, NEJun 7, 1977 · N80078 · Destroyed NTSB MKC77DCJ18Accident · No injuriesClosedPiper PA-18 · Bassett, NEApr 25, 1977 · N9396D · Substantial damage NTSB MKC77DCJ15Accident · No injuriesClosedPiper PA-22 · Whitman, NEMar 14, 1977 · N4812A · Substantial damage NTSB MKC76DCJ49Accident · No injuriesClosedCessna 172 · Mccook, NEJul 15, 1976 · N64294 · Substantial damage NTSB MKC76DCJ46Accident · No injuriesClosedBellanca 7GCBC · Cedar Rapids, NEJul 3, 1976 · N8721V · Substantial damage NTSB MKC76FCJ43Accident · No injuriesClosedPiper PA-28 · Kennard, NEJun 18, 1976 · N5505W · Substantial damage NTSB MKC76DCJ18Accident · No injuriesClosedPiper PA-18 · Merriman, NENov 22, 1975 · N3820Z · Substantial damage NTSB MKC76FCJ14Accident · No injuriesClosedPiper PA-28 · Utica, NEOct 5, 1975 · N41371 · Substantial damage NTSB MKC76DCJ08Accident · No injuriesClosedPiper PA-25 · Benedict, NEAug 3, 1975 · N6454Z · Substantial damage NTSB MKC76FCJ04Accident · No injuriesClosedPiper PA-18 · Hebron, NEJul 20, 1975 · N3985Z · Substantial damage NTSB MKC76FCJ03Accident · Minor injuriesClosedPiper PA-25 · Waco, NEJul 13, 1975 · N6481Z · Substantial damage NTSB MKC75DCJ62Accident · No injuriesClosedPiper PA-18A · Danbury, NEJun 30, 1975 · N8172D · Destroyed NTSB MKC75DCJ41Accident · No injuriesClosedPiper PA-28 · Albion, NEDec 8, 1974 · N7116R · Substantial damage NTSB MKC75DCJ30Accident · No injuriesClosedPiper PA-25 · York, NESep 25, 1974 · N6416Z · Substantial damage NTSB MKC75DCJ26Accident · No injuriesClosedAmer Avco AA-5 · Tekamah, NESep 1, 1974 · N5852L · Substantial damage NTSB MKC75DCJ23Accident · Minor injuriesClosedPiper PA-28 · Ogallala, NEAug 25, 1974 · N54386 · Substantial damage NTSB MKC75DCJ16Accident · No injuriesClosedPiper PA-18 · Dunning, NEAug 4, 1974 · N14159 · Substantial damage NTSB MKC74DCJ38Accident · No injuriesClosedPiper PA-25 · Hemingford, NEApr 30, 1974 · N6340Z · Substantial damage NTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NESep 25, 1973 · N8519Y · Substantial damage NTSB MKC74DCJ10Accident · No injuriesClosedPiper PA-25 · Gresham, NESep 15, 1973 · N6481Z · Substantial damage