NTSB investigations, MI
31 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 3 |
| 1992 | 3 |
| 1993 | 2 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 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\" = 'MI' 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" = 'MI' 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 CHI05CA095Accident · No injuriesData collectionFinal reportCessna 172P · Ann Arbor, MIThe failure of the carburetor nozzle resulting in loss of engine power and the unsuitable terrain encountered during the forced landing. A factor was the low altitude.NTSB CHI04CA261Accident · No injuriesData collectionFinal reportAbbott RAF 2000 · Pontiac, MIThe partial loss of engine power due to the scoring and overheating of the cylinders as a result of the pilot/owner's improper servicing of the modified engine cooling system. Additional factors included the pilot/owner modifying and servicing the engine…NTSB CHI03LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Carleton, MIThe #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB CHI00LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Coopersville, MIfuel starvation due to the blocked carburetor. Factors relating to the accident were the foreign object (tab), the improper maintenance performed on the carburetor, and the corn crop.NTSB CHI00LA056Accident · No injuriesLimited investigationFinal reportCessna 210 · South Lyon, MIthe failure of the throttle and the unsuitable terrain encountered by the pilot in the taxi area. Factors were the collapsed nose gear and the rough terrain,NTSB CHI98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Napoleon, MIthe pilot inadequate pre-flight planning. Factors in this accident were the airplane's weight and balance limitations had been exceeded by the pilot and an improper top overhaul of the engine's cylinder by the mechanic.NTSB CHI97LA284Accident · 2 fatalLimited investigationFinal reportNorth American-Aero Classics P-51D · Monroe, MIthe pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…NTSB CHI97FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Canton, MIA loss of engine power due to fuel starvation from a binding throttle/power lever cable. Also causal was the improper maintenance, installation of the throttle arm. Contributing to the accident were the dark night and unsuitable terrain for the forced landing.NTSB CHI96LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Pleasant, MIthe student pilot's inadequate preflight and the loose oil filler cap, which resulted in oil starvation and failure of the #1 cylinder connecting rod. A factor relating to this accident was the snow covered terrain.NTSB CHI96LA035Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Montrose, MIa loss of engine power as a result of the separation of the throttle push-pull cable.NTSB CHI95LA293Accident · Serious injuriesLimited investigationFinal reportPatin Challenger II · Cedar Springs, MIinadequate engine maintenance by the owner/pilot-mechanic. Factors associated with the accident were fouled spark plugs and the pilot not being able to maintain proper altitude/clearance between his airplane and the electrical power lines during his landing…NTSB CHI95LA283Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Ironwood, MIthe pilot's failure to maintain control of the airplane during the aborted takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB CHI95LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brooklyn, MIthe pilot operating the airplane with a known deficiency. A factor was the pilot not maintaining control of the airplane.NTSB CHI93DEC01Accident · Minor injuriesFinal reportBradford Pietenpol Skyscout · Eaton Rapids, MIthe pilot's failure to maintain airspeed which resulted in an inadvertant stall. Factors related to the accident were the low altitude and the restricted movement of the carburetor needle.NTSB CHI93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Houghton Lake, MIThe pilot operating the airplane with a known deficiency.NTSB CHI93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ludington, MIThe partial loss of engine power during the initial climb out on a night flight.NTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.NTSB CHI92DEM01Accident · No injuriesFinal reportRose Wesley Rotorway WR Exec · Hudsonville, MIThe failure of an intake valve spring. Factors related to the accident were the low altitude at which the autorotation was initiated and the soft terrain on which the helicopter was landed.NTSB CHI90LA267Accident · No injuriesLimited investigationFinal reportCessna 182 · Troy, MIA loss of engine power due to failure of the rocker arm bosses on the #2 cylinder.NTSB CHI90LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Flint, MIA loose fuel line caused by improper installation by maintenance personnel.NTSB CHI90LA136Accident · No injuriesLimited investigationFinal reportCessna 182F · Clare, MIImproper maintenance by maintenance personnel resulting in a sticking carburetor float. Inadequate planning by the pilot in command during the approach is a factor in the accident.NTSB CHI89DEM10Accident · 1 fatalFinal reportFletcher SONERAI-2L · Interlochen, MILoose cylinder due to improper maintenance by the pilot/owner, which resulted in overheating and failure of the aluminum cylinder head. The presence of trees was considered to be a factor.NTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB CHI88DEM01Accident · Minor injuriesFinal reportNorth American T-28A · Schoolcraft, MIWhile the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…NTSB CHI87LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Hillsdale, MITkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were…NTSB CHI87DEC02Accident · Minor injuriesFinal reportCessna 172G · Linden, MIThe student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the…NTSB CHI86FA170Accident · Serious injuriesField investigationFinal reportGrumman AA5B · Benton Harbor, MIThe aircraft departed on runway 09. Passenger remembers the pilot starting to turn back to the airport when the wings went perpendicular to the horizon and the ground came rushing up. Teardown of the engine revealed a bent push rod and a split push rod shroud…NTSB CHI86FA079Accident · 2 fatalField investigationFinal reportCessna 421C · Birmingham, MIAt rotation the right eng failed. The acft entered a skidding turn to the rt and continued to climb to about 100 ft AGL. During the turn 110 deg from t.o. heading acft rolled inverted and descended into a car port. Extensive post impact fire destroyed acft,…NTSB CHI85LA360Accident · No injuriesLimited investigationFinal reportSchweizer G164A "450" · Constantine, MIThe acft nosed over during a forced landing in a corn fld. The plt stated that at 30 ft AGL during his second swath run the eng backfired and lost pwr. He attempted to dump the load however, the acft continued to loose alt and the forced landing resulted.…NTSB CHI85LA060Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Allegan, MIThe plt stated he lost power on takeoff, but elected to takeoff rather than abort. He cleared wires but decided he could not clear trees & made a forced landing in a corn field. Inspection of the acft revealed that the fuel control rod cotter pin was…NTSB CHI83LA406Accident · Serious injuriesLimited investigationFinal reportEdwards Mitchell P-38 · Sheridan, MIThe acft nosed down in a crop of corn during a forced landing after the engine lost power at 200 ft AGL during takeoff climb. During the turn back to the airstrip the left wing stalled. The pilot said he recovered about 10 ft AGL but the corn stalks slowed…