Skip to content

Fatal NTSB investigations: Lycoming 0-320 series, WI

20 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 per year

19712026

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" = 'WI' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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" = 'WI' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  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 CHI08FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Stevens Point, WIThe partial loss of engine power for undetermined reasons.May 12, 2008 · N1813T · Substantial damage NTSB CHI06LA163Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Columbus, WIThe pilot's failure to maintain adequate clearance from the trees during the attempted low altitude pass along the river. Contributing factors were the intentional low altitude flight maneuver, the pilot's improper decision to attempt that maneuver, and his…Jun 25, 2006 · N8267J · Destroyed NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.Jul 20, 2005 · N65875 · Destroyed NTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.Aug 12, 2004 · N3599F · Destroyed NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.Jun 8, 2003 · N63319 · Destroyed NTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · Destroyed NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.Aug 4, 1997 · N4442C · Destroyed NTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.Sep 5, 1996 · N2338Z · Destroyed NTSB CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.Nov 11, 1995 · N161FS · Destroyed NTSB CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.Sep 3, 1995 · N9838Y · Destroyed NTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…Dec 17, 1991 · N73920 · Destroyed NTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…Aug 15, 1987 · N5831D · Destroyed NTSB CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…Jun 7, 1987 · N1358R · Destroyed NTSB CHI83FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Beloit, WIReportedly, the plt had not flown for 2 or 3 months before his flts on 2/27/83. On that day, he took off & made 5 touch-and-go landings, then stopped for a cup of coffee. The plt then departed again on a 2nd flt. Aprx 1/2 hr later, smoke was observed from the…Feb 27, 1983 · N5769F · Destroyed NTSB CHI81FA054Accident · 1 fatalClosedPiper PA-28 · Johnstown Ctr, WIMay 9, 1981 · N6921W · Destroyed NTSB CHI79FEP74Accident · 1 fatalClosedPitts Spcl S1S · Camp Douglas, WIAug 14, 1979 · N751BF · Destroyed NTSB CHI78FA034Accident · 1 fatalClosedPiper PA-28 · Mellen, WIJan 2, 1978 · N8215C · Destroyed NTSB CHI76AC085Accident · 1 fatalClosedPiper PA-18 · Tomahawk, WIAug 9, 1976 · N3697Z · Destroyed NTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WISep 14, 1972 · N2348L · Destroyed NTSB CHI71FEP53Accident · 1 fatalClosedPiper PA-18 · Ripon, WIJun 13, 1971 · N2366P · Destroyed