NTSB investigations: Lycoming 0-320 series, WI

8 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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

19862026

NTSB investigations: Lycoming 0-320 series, WI per year, 1986–2026: 8 cases
1986	1
1995	1
1997	1
2001	2
2002	1
2006	1
2007	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.Jul 8, 2007 · N2292Y · Substantial damage NTSB CHI06CA253Accident · No injuriesData collectionFinal reportHedeman Tailwind W8 · Platteville, WIThe loss of engine power as a result of the pilot's inadequate preflight which resulted in a blocked fuel vent that led to fuel starvation.Sep 3, 2006 · N4FD · Substantial damage NTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.Oct 27, 2002 · N994RV · Substantial damage NTSB CHI01LA264Accident · Minor injuriesLimited investigationFinal reportBeech 23 · West Bend, WIThe pilot not following the aircraft fuel management procedures. Factors were the fuel starvation, the low altitude, the manufacturers service instruction not complied with, and the tree.Aug 6, 2001 · N2367J · Substantial damage NTSB CHI01LA265Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WIThe unsuitable terrain for landing encountered by the pilot. Factors were the high vegetation and the loss of engine power for undetermined reasons.Aug 5, 2001 · N13715 · Substantial damage NTSB CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.Aug 27, 1997 · N9026H · Substantial damage NTSB CHI95LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Viroqua, WIThe loss of engine power for undetermined reasons.Jun 9, 1995 · N5762W · Substantial damage NTSB CHI86FER07Accident · No injuriesFinal reportCessna 172P · Webster, WIShortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…May 17, 1986 · N99583 · Substantial damage