NTSB investigations, IL
34 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 1999 | 1 |
| 2002 | 3 |
| 2005 | 1 |
| 2007 | 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\" = 'IL' 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\" = 352)
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" = 'IL' 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" = 352) 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 CHI07LA240Accident · No injuriesLimited investigationFinal reportAircoupe F-1A · Greenwood, ILThe loss of engine power due to carburetor icing, which resulted in the pilot having to perform a forced landing to unsuitable terrain. Factors contributing to the accident were the carburetor icing conditions and the broken carbuerator heat lever.NTSB CHI05CA256Accident · No injuriesData collectionFinal reportBoeing A75N1 · Ellisville, ILThe loss of engine power due to the failure of the number four connecting rod. A factor to the accident was the soybean crop.NTSB CHI02LA281Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Effingham, ILThe partial loss of engine power due to the seized exhaust valve. A factor was the soft field.NTSB CHI02LA166Accident · 1 fatalLimited investigationFinal reportJacobs Rutan Vari Viggen · Urbana, ILThe pilot's failure to abort the takeoff. Additional factors included the partial loss of engine power due to an excessively rich mixture as a result of a bad accelerator pump housing seal, and the pilot failed to maintain control of the airplane.NTSB CHI02LA150Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sparta, ILThe total loss of engine power due to a separated cylinder and the failure of the pilot to perform a precautionary landing at the nearest suitable airport when the engine had a partial loss of engine power. The failure of the aircraft owners to perform an…NTSB CHI99LA275Accident · No injuriesLimited investigationFinal reportFairchild 24 C8C · La Fayette, ILthe pilot's failure to obtain/maintain the proper descent rate. A factor to the accident was the partial loss of engine power as a result of the exhaust valve keeper becoming unlocked, which jammed the exhaust valve.NTSB CHI97LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Champaign, ILan undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.NTSB CHI97LA142Accident · No injuriesLimited investigationFinal reportMooney M20F · Wheeling, ILbinding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.NTSB CHI97IA117Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILinadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…NTSB CHI96LA340Accident · No injuriesLimited investigationFinal reportCessna 150 · Wonder Lake, ILa blocked exhaust pipe as a result of an inadequate weld repair to the muffler.NTSB CHI95IA142Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC10-10 · Chicago, ILfailure of the safety wire and/or safety wire lug arm on one of the stage one to two disk flange bolts due to an inadequate safetying method.NTSB CHI94LA332Accident · No injuriesLimited investigationFinal reportCessna 170 · St. Anne, ILEngine failure due to an inadequately reconditioned cylinder.NTSB CHI93LA343Accident · No injuriesLimited investigationFinal reportCessna T210N · Lake In The Hil, ILChafing of a fuel system line.NTSB CHI93LA256Accident · Minor injuriesLimited investigationFinal reportQuad City Challenger II Specia · Ottawa, ILThe pilot in command's failure to maintain proper clearance. Factors to the accident include an oil fouled spark plug and a power ground cable.NTSB CHI92FA282Accident · 1 fatalField investigationFinal reportCessna 152 · Ottawa, ILPilot did not maintain a proper airspeed which led to an inadvertent stall/spin at a low altitude where the pilot could not perform a recovery.NTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.NTSB CHI92LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Aurora, ILFatigue fracture of the engine crankshaft resulting in loss of power. Factors were the pilot's excessive descent and his lack of total experience.NTSB CHI92LA179Accident · No injuriesLimited investigationFinal reportCessna 210B · Belleville, ILThe improper fuel pump high end discharge adjustment. A related factor is improper maintenance/annual inspection.NTSB CHI92LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Markham, ILThe result of an inadequate annual inspection by other maintenance personnel and, as a result, a total failure of the throttle linkage. A factor was the pilot overshot his intended emergency landing area, due to excessive speed.NTSB CHI92LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Carlyle, ILFuel contamination and blockage of the carburetor, which restuled in fuel starvation. The high obstructions (trees) were a related factor.NTSB CHI92LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Roscoe, ILOperation of an aircraft with known deficiencies and deterioration/failure of the magneto(s). Factors related to the accident were: the lack of an annual inspection and non-compliance with an airworthiness directive (AD).NTSB NYC91FA246Accident · 2 fatalField investigationFinal reportCessna 172P · West Chicago, ILThe pilot's improper in-flight decision to return to the airport following a loss of engine power at a low altitude. The pilot failed to maintain airspeed which resulted in an inadvertent stall at an altitude insufficient for recovery. Factors contributing to…NTSB CHI90FA233Accident · No injuriesField investigationFinal reportPiper PA-23-160 · Odell, ILA loss of left engine power due to oil accumulation in the right magneto and a non-usable spark lead from the left magneto. In addition, the right engine was unable to provide adequate power to maintain altitude due to a partial blockage in the carburetor by…NTSB CHI90DEV08Accident · Minor injuriesFinal reportHilvety Cwii · Moweaqua, ILThe pilot's failure to maintain flying speed and stalling the airplane while attempting to reverse course for a forced landing. Contributing to the accident was the pilot's failure to properly reinstall spark plug cables during servicing conducted prior to…NTSB CHI89LA191Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Chicago, ILA hard landing caused by the pilot not being able to judge his altitude above or his closure rate to terrain because of high vegetation in the area available for a forced landing. An engine faulure caused by material failure of the compressor section is a…NTSB CHI89FA109Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Saint Charles, ILThe failure of the mechanic to properly inspect the alternate air door during annual inspection. This failure led to air starvation, loss of power, and a forced landing by the pilot onto rough terrain.NTSB CHI88DEV03Accident · No injuriesFinal reportHughes 369HS · Ashland, ILAs the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the . Tail boom. An inspn of the eng…NTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…NTSB CHI86FA215Accident · No injuriesField investigationFinal reportCessna 172P · Grayslake, ILDrg cruise flt, there was a loss of eng power (decreasing to 1900 RPM). The plt initiated a precautionary landing on rwy 27, but overran the intended landing area. The acft contd beyond the end of the rwy & subsequently flipped over in a corn field, west of…NTSB CHI85IA032Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Chicago, ILShortly after takeoff, the flight crew heard a noise from the right side of the aircraft, which sounded like an engine compressor stall. The #3 engine was shut down & the crew made an uneventful landing at the departure airport. Pieces of cowling from the…NTSB CHI84LA387Accident · No injuriesLimited investigationFinal reportMooney M20E · Lansing, ILThe plt had just demonstrated the acft for sale and filed an IFR flt plan. Run up and pre-takeoff checks were rushed to beat void clearance time. Just before liftoff, plt noted sluggish acceleration but believed insufficient runway remained to successfully…NTSB CHI83LA424Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Wheeling, ILThe acft went off the rwy and collapsed the landing gear after power loss during takeoff. Three of the passengers furnished statements and 2 seemed to think that the left engine quit. The acft turned to the right but the pilot did notknow which engine quit.…NTSB CHI83LU011Accident · Serious injuriesFinal reportPioneer Flightstar · Robinson, ILThe plt reported that after taking off, he stayed low over farm fields. He reported that he traveled about 1 1/4 mi from the arpt & decided to return & land. However, during a left turn, the ultralight vehicle crashed. The plt was seriously injured & did not…NTSB CHI82DA367Accident · No injuriesFinal reportCessna 207 · Bedford Park, ILPilot made forced landing at night in railroad yard. Engine had loose fuel line.