NTSB investigations, IN
23 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2004 | 1 |
| 2007 | 2 |
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\" = 'IN' 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" = 'IN' 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 CHI08CA035Accident · No injuriesData collectionFinal reportMooney M20E · Lafayette, INThe improper installation of the connecting rod bolts during major overhaul, which resulted in the separation of the connecting rod from the crankshaft in flight. Contributing to the accident was the rising terrain encountered during touchdown and the…NTSB CHI07LA289Accident · No injuriesLimited investigationFinal reportCessna 310Q · Brownsburg, INThe pilot's poor in-flight planning to make an off airport precautionary landing and his failure to maintain clearance from the construction equipment during the landing roll. Contributing to the accident was the construction equipment.NTSB CHI04CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Noblesville, INThe pilot's failure to select carburetor heat and his failure to maintain airspeed resulting in a stall. Factors were unstabilized approach the aircraft's low altitude, and the weather conditions conducive to carburetor icing.NTSB CHI00LA311Accident · No injuriesLimited investigationFinal reportCessna 150H · Michigan City, INfuel contamination (water) and the pilot exceeding his landing field distance. Factors relating to this accident were the pilot inadequate preflight planning/preparation, his having to select an unsuitable landing area, the short landing area, and the marsh.NTSB CHI00LA082Accident · 1 fatalLimited investigationFinal reportEllis Q2 · Shelbyville, INaircraft control not being maintained by the pilot during the attempted go-around. Factors to the accident were the inadequate preflight by the pilot, which resulted in fuel exhaustion. An additional factor to the accident was the inadvertent stall/mush.NTSB CHI98LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wheatfield, INthe pilot's failure to apply carburetor heat when the engine lost power. Factors associated with the accident were the carburetor icing conditions which prevailed, the low altitude at which the loss of power occurred, and the soybean crop in which the…NTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.NTSB CHI94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Lebanon, INInadequate preflight preparation by the pilot-in-command. Factors were fuel system contamination and an unsuitable terrain encountered by the pilot-in-command during a forced landing.NTSB CHI93LA297Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Lafayette, INthe loss of engine power for reason or reasons undetermined.NTSB CHI93LA228Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownsburg, INfailure to replace a dirty air filter.NTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.NTSB CHI92LA056Accident · No injuriesLimited investigationFinal reportCessna 177 · Elkhart, INThe pilot in command's failure to use carburetor heat. A factor to the accident was the carburetor icing conditions.NTSB CHI91DEX01Accident · Minor injuriesFinal reportCessna 210G · Indianapolis, INInadequate maintenance and inspection of the airplane resulting in an engine power loss due to water and fuel contamination. A contributing factor was the dark night.NTSB CHI89LA171Accident · No injuriesLimited investigationFinal reportCessna 172H · Lake Village, INWater contamination in the fuel/fuel system and inadequate preflight by the pilot. Soft terrain in the emergency landing area was a contributing factor.NTSB CHI89DEX03Accident · No injuriesFinal reportGrumman American AA-1C · Richmond, INThe pilot's attempt to continue the takeoff with a partial loss of power. Contributing to the accident were the carburetor icing conditions.NTSB CHI88FA201Accident · 4 fatalField investigationFinal reportCessna 210B · Noblesville, INNTSB CHI87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kentland, INPilot reported a loss of power approx. 10 to 30 feet above the runway. The aircraft came to rest along the left side and approx. 1500 feet down the 3500-foot runway. Inspection of the aircraft after the accident did not reveal any evidence of engine problems.…NTSB CHI87LA046Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Lake Village, INThe pilot stated that he gradually lost power while on final approach. He finally stalled the aircraft and pancaked it into the trees before the runway. The pilot also stated that he suspected carburetor ice was involved.NTSB CHI85FA213Accident · Serious injuriesField investigationFinal reportHughes 369E · Indianapolis, INAs the helicopter was on downwind for the heliport, the plt experienced an pwr interruption and eventually a eng failure. He was attempting an autorotation to railroad tracks when he saw wires. He managed to miss the wires but by doing so he expended the…NTSB CHI85FA165Accident · 3 fatalField investigationFinal reportPiper PA-30 · Worthington, INThe acft stalled and crashed in a fld after the plt declared an emergency stating he was losing pwr on the right eng and he could not maintain alt. At 1405 EST, the acft was told to contact hulman apch with instructions to descend to 3000 ft MSL. The mode c…NTSB CHI85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankton, INDuring a setup for a practice stall the solo student pilot retarded the throttle, raised the nose slightly and applied carb heat. He believed he was losing airspeed too quickly so he then reapplied full power. At this point the engine rpms dropped to 5 or…NTSB CHI84LA103Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Logansport, INThe plt stated that the acft eng was running rough at rotation. He climbed to approx 300 ft AGL and began a left trafficpattern back to rwy 27. A landing was made 225 ft short of the rwy. During the post-accident eng run-up the eng started easily and ran…NTSB CHI82DA324Accident · No injuriesFinal reportPiper PA-28-160 · Knox, INThe pilot departed on a flight from lake village to Knox, IN. While en route, he landed to refuel at rensselaer, IN. During the flight from rensselaer to Knox, the engine began loosing power when he was about 5 mi from the destination. When the pilot realized…