NTSB investigations, IL
28 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1984 | 6 |
|---|---|
| 1985 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2006 | 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\" = 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" = '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" = 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 CHI07LA106Accident · Minor injuriesLimited investigationFinal reportBrowns Vans RV-7A · Gardner, ILEngine failure during cruise flight for undetermined reasons. A factor was the rough/uneven terrainNTSB CHI06LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Prospect Height, ILThe partial loss of engine power during takeoff due to the flight crews failure to use carburetor heat and the flight instructor's inadequate planning/decision. A factor was the unsuitable terrain for a forced landing.NTSB CHI04LA002Accident · Minor injuriesLimited investigationFinal reportGoldman Dragonfly · Peoria, ILThe loss of power for undetermined reasons and the inadvertent stall of the canard by the pilot on the turn to final during the forced landing, as well as the excessive descent rate causing the aircraft to "pancake" into the ground.NTSB CHI01FA233Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Chenoa, ILThe inadvertent stall the pilot encountered during his turn with an in-flight loss of engine power due to fuel starvation on initial climbout and the improper in-flight decision he made to continue the turn. Factors were the fuel starvation and the incorrect…NTSB CHI00LA223Accident · No injuriesLimited investigationFinal reportCessna 210N · Harrisburg, ILThe power loss for undetermined reasons and unsuitable terrain.NTSB CHI00LA201Accident · Minor injuriesLimited investigationFinal reportWitlock CIRCA-NIEUPORT 12 · Peotone, ILthe carburetor icing conditions and the fact that the aircraft was not equipped with carburetor heat protection. A factor to the accident was the crops.NTSB CHI99LA210Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Jacksonville, ILA material defect in the sloshing compound. Factors were the blocked fuel system, inspection not identifying material defect, and the crop field.NTSB CHI97TA198Accident · Minor injuriesFinal reportCessna 182R · Peoria, ILthe pilot's improper use of carburetor heat and the carburetor icing conditions which existed at the time of the accident. Factors were the ditch and poles which the airplane contacted.NTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.NTSB CHI96LA273Accident · Minor injuriesLimited investigationFinal reportBeech 77 · South Elgin, ILwater contamination in the carburetor.NTSB CHI94LA061Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Dekalb, ILwas an aborted takeoff not performed by the pilot-in-command. Factors related to the accident were the partial power loss for undetermined reasons and the continued operation of the airplane with a deficiency.NTSB CHI93LA340Accident · No injuriesLimited investigationFinal reportRobinson R22 · Bethalto, ILthe pilot-in-command's not maintaining rotor RPM.NTSB CHI93LA083Accident · No injuriesLimited investigationFinal reportCessna 177 · Barrington, ILLoss of engine power due to fuel contamination.NTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.NTSB CHI92LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe pilot's delayed application of carburetor heat.NTSB CHI91DEE05Accident · Minor injuriesFinal reportCharles Raucci, JR. Firebolt · Schaumburg, ILThe pilot not following the specification for installation of the fuel tank vent.NTSB CHI89LA163Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Putnam, ILImproper use of carburetor heat by the pilot which resulted in reduced power for takeoff. The obstructions (hangar & trees) and weather conditions were contributing factors.NTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.NTSB CHI87DCA01Accident · Minor injuriesFinal reportBeech 3NM · Cahokia, ILThe acft experienced a loss of pwr in the rt eng immediately aft tkof. The plt was not able to feather the propeller and was forced to land in a wheat field on arpt property. Conditions were conducive to carburetor icing at the time of the accd. Investigation…NTSB CHI85FEE04Accident · Minor injuriesFinal reportJauch Coot/Amphib · Mendota, ILThe acft touched down in a bean fld during a forced landing following a loss of pwr on takeoff. The plt reported the acft had low pwr during the takeoff run, however, he elected to continue the takeoff and make a 180 deg turn back to the airstrip. Once…NTSB CHI85LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…NTSB CHI85IA101Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILThe aborted takeoff that began this sequence was due to engine inlet icing. Moisture from the wet ramp was ingested into the engines as the acft taxied to the runway. No engine anti-ice was used because no visible moisture existed. Following the abort the…NTSB CHI84LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · La Salle, ILThe acft made a forced landing in a corn field after a power loss. The plt said that the engine seemed to be running rough at start-up. After leaning and a run-up it smoothed out. Twenty minutes after takeoff the engine started vibratingand the EGT went up to…NTSB CHI84LA222Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Kankakee, ILAfter departing the arpt, the plt elected to practice emergency procedures. He shut down & feathered the left eng about 4 mi south of the arpt at 4000 ft MSL. He then tried to restart the eng, but reported that the battery did not have enough pwr to turn the…NTSB CHI84FA194Accident · Minor injuriesField investigationFinal reportBeech A36 · Schaumburg, ILThe plt reported that he lost partial engine power during climb and decided to return to the arpt. He said the engine changed power output when he used the electric fuel pump but he left it off. During final approach, not having declared an emergency, he had…NTSB CHI84LA189Accident · No injuriesLimited investigationFinal reportCessna 190 · St. Anne, ILThe plt stated that during his 2nd takeoff from a restricted landing area, the eng hesitated at an alt of about 10 ft AGL. He then aborted the takeoff & tried to land on the remaining rwy. However, the acft touched down in a plowed field where it nosed over.…NTSB CHI84LA181Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ridge Farm, ILThe helicopter rolled over after a hard landing following loss of rotor RPM. The plt reported that during initial climb at about 300 ft AGL the rotor decreased about 500 RPM. He tried to regain rotor RPM until about 100 ft AGL and then tried an autorotation.…NTSB CHI84LA079Accident · No injuriesLimited investigationFinal reportCessna 150G · Plato Center, ILThe acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage.