NTSB investigations: Lycoming 0-320 series, WI
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 3 |
| 1989 | 2 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 353))
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" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.NTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.NTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.NTSB CHI90LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Barron, WIImproper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.NTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.NTSB CHI84LA339Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Washington Is., WIThe acft stalled and crashed after the engine lost power at about 50 ft AGL during takeoff. The acft caught fire after touchdown. The fire consumed the cockpit and cabin. An examination of wreckage showed the fuel selector on the left tank. The left tank had…NTSB CHI84LA166Accident · Minor injuriesLimited investigationFinal reportGrumman AA5A · Cudahy, WIThe acft struck a storage shed while attempting to reach a golf course during an emergency landing in gusty wind conditions. There were no visible signs or odor of fuel at the accident site. When the acft was inspected the carburetor and fuel sumps were…NTSB CHI84LA161Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa City, WIAfter takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…NTSB CHI82DA140Accident · No injuriesFinal reportBeech BE-19 · Ridgeville, WIThe student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…