NTSB investigations, WI
19 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 354) 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 CHI05CA204Accident · Minor injuriesData collectionFinal reportWilson Acrolite 1T · Oshkosh, WIThe partial loss of engine power due to an obstructed carburetor fuel metering jet. Factors to the accident included the low altitude at which the loss of engine power occurred, the contamination of the fuel system from degraded automobile-style fuel lines,…NTSB CHI05CA006Accident · No injuriesData collectionFinal reportPiper PA-28-160 · Altoona, WIThe pilot's inadequate fuel management leading to the fuel starvation in the left tank during the flight's descent. A factor was the impacted power line.NTSB CHI04LA014Accident · No injuriesLimited investigationFinal reportCroke Zenith CH 701 · Brussels, WIA partial loss of engine power for undetermined reasons.NTSB CHI01FA329Accident · 3 fatalField investigationFinal reportCessna 414 Riley Super-8 · Marshfield, WIThe pilot's failure to maintain adequate airspeed (Vmc) which resulted in a loss of control. Contributing factors were the improper in-flight planning/decision not to land at a closer airport and the lack of recent experience in multiengine airplanes by the…NTSB CHI00LA294Accident · No injuriesLimited investigationFinal reportBeech B24 · Necedah, WIThe pilot did not properly flare the airplane during the aborted takeoff and he failed to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the partial power loss for undetermined reasons and the…NTSB CHI99LA186Accident · No injuriesLimited investigationFinal reportNorth American Navion L-17A · Osceola, WIthe pilot's mismanagement of the fuel system in that he had the fuel selector positioned to a tank which did not contain sufficient fuel for the flight. Factors associated with the accident were the crop and the ditch which the airplane encountered during the…NTSB CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.NTSB CHI95LA309Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Walworth, WIloss of engine power which occurred for an undetermined reason. A factor was the soft terrain in the emergency landing site.NTSB CHI94DER01Accident · Minor injuriesFinal reportJohnson Avid Flyer Mark IV · New Richmond, WICarburetor ice, and the owner/builder's inadequate airplane/equipment design, in that there was no carburetor heat/control installed in the airplane. Factors related to the accident were: the weather (carburetor icing conditions), and obstacles (trees) in the…NTSB CHI93FA296Accident · Serious injuriesField investigationFinal reportGrumman G58A · Oshkosh, WIThe pilot-in-command's inadvertent use of the mixture resulting in a lean mixture.NTSB CHI91DEP06Accident · No injuriesFinal reportAvid Flyer Avid Flyer · Endeavor, WIThe pilot in command's inability to effectively eliminate carburetor ice to avoid an emergency landing.NTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.NTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WINTSB CHI88DEP06Accident · No injuriesFinal reportHuntley Challenger II · Platteville, WIAfter climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…NTSB CHI87LA055Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Harrison Twp., WIDuring cruise flt the plt attempted to add power and carb heat with no immediate response in eng power. The plt then tried to make an emergency landing in a field but did not have sufficient altitude and airspeed. The acft collided with trees. The plt…NTSB CHI86LA074Accident · No injuriesLimited investigationFinal reportCessna L-19 · Kenosha, WIThe pilot drained the fuel tanks until no evidence of water was present. Alcohol & 100LL was added prior to takeoff. In the traffic pattern engine power was lost. The runway was over flown & a collision with a fence insued during the forced landing. Water was…NTSB CHI84LA329Accident · Minor injuriesLimited investigationFinal reportGulfstream AA-5A · Wausau, WIDrg a x-country flt at 4500 ft, eng began sputtering. Plt adusted the mix; then applied carb heat, but rprtdly for only a short time. Eng contd operg, but at reduced pwr. Acft lost alt & dscndd into clds, but the plt was able to lvl at APRX500' AGL. He…NTSB CHI83LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Black River Fal, WIAfter flying in the local area about 1 hr, the pilot landed at the airport. While taxiing back to the hangar, he elected to make another short flight. The aircraft was taxied back to the runway and a takeoff was made. No engine runup or carburetor heat check…NTSB CHI82IA284Incident · No injuriesIncident investigationFinal reportCessna 182P · Oshkosh, WIThe pilot entered traffic pattern downwind as number 3 for landing. Traffic pattern spacing required a three mile final approach over lake winnebago. The pilot stated that there were two slower aircraft preceeding him and that spacing between aircraft was…