NTSB investigations, MI
103 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 5 |
| 1984 | 7 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 7 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 2 |
| 2002 | 5 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 4 |
| 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\" = '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\" = 130)
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" = 130) 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 CHI07CA124Accident · No injuriesData collectionFinal reportWilkinson Daniel V Rotorway Exec 90 · Kalamazoo, MIThe failure of the sprag clutch which resulted in the disengagement of the drive unit and the pilot's misjudged landing during the autorotation. A factor was the low altitude at which the failure occurred.NTSB CHI07FA107Accident · No injuriesField investigationFinal reportCanadair CL-600-2B19 · Lake Michigan, MIIn-flight separation of the left engine thrust reverser translating cowling due to intermittent binding and jamming of the reverser on the accident flight and on previous flights. Contributing factors were the inadequate maintenance action by the operator due…NTSB CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.NTSB CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.NTSB CHI06LA190Accident · 1 fatalLimited investigationFinal reportArmpriest Breezy · South Haven, MIThe inadvertent stall by pilot during climb following propeller blade damage from the compartment door separation after takeoff. The low altitude and airspeed not maintained by the pilot were additional causes. Contributing factors were the compartment door…NTSB CHI06CA111Accident · No injuriesData collectionFinal reportLee SQ 2000 · Berrien Springs, MIFailure of the right main landing gear assembly during landing and the pilot's subsequent inability to maintain directional control of the airplane. Contributing factors were the collapse of the left and right main landing gear and the gusty, crosswind…NTSB CHI05CA267Accident · No injuriesData collectionFinal reportWest Revolution Mini 500 · Ida, MIThe pilot's abrupt (improper) control action which resulted in the main rotor contacting the tail boom. Contributing factors were the false indication provided by the engine tachometer, the pilot's decision to immediately initiate an autorotation instead of…NTSB CHI05LA143Accident · No injuriesLimited investigationFinal reportThomas Zenith CH701 · Redford, MIThe total loss of engine thrust was the result of the propeller blades overstress separation from the propeller hub for an undetermined reason. An additional cause was the unsuitable terrain encountered during the forced landing.NTSB CHI04LA213Accident · No injuriesLimited investigationFinal reportCessna 208B · Big Rapids, MIThe pilot's failure to verify that the cargo door was latched properly prior to flight and the subsequent in-flight opening of the door. A contributing factor was the box which departed the cargo compartment and struck the horizontal stabilizer.NTSB CHI04CA159Accident · Serious injuriesData collectionFinal reportBracken CB540 · Lapeer, MIThe pilot's loss of control due to an undetermined flight control system malfunction. Contributing factors to the accident were the wires and trees.NTSB CHI04LA081Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Jackson, MIThe left main tire failed which resulted in the CFI's inability to maintain directional control of the airplane during the landing. A factor associated with the accident was the snow bank which the airplane contacted.NTSB CHI04IA018Incident · No injuriesIncident investigationFinal reportEnstrom F-28C · Lapeer, MIComplete failure of the right anti-torque cable while on final approach for landing. A factor was the diminished tail rotor control resulting from the broken cable.NTSB CHI03LA235Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Brighton, MIThe pilot's directional control not possible resulting from the rudder control assembly separation during the landing. A factor was the construction vehicle that the airplane impacted.NTSB CHI03LA191Accident · No injuriesLimited investigationFinal reportCessna 140 · Ludington, MIThe maintenance personnel's improper installation of the landing gear axle, which resulted in the separation of the axle from the landing gear.NTSB CHI03IA096Incident · Minor injuriesIncident investigationFinal reportCessna 208B · Saginaw, MIFailure of the engine bleed air pressure regulator. A contributing factor was the anti-chaffing tape on the air supply line.NTSB CHI02LA277Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Martin, MIThe pilot's inadequate aircraft preflight and his inability to abort the takeoff due to the obscured windshield. Contributing to the accident was the bent hopper latch and the pilot's failure to maintain directional control.NTSB CHI02IA275Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Detroit, MIA malfunctioning yaw damper.NTSB CHI02LA218Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Copemish, MIThe in-flight engine and cabin fire caused by a fatigue fracture of the left exhaust stack assembly. An additional cause was the part's inadequate design by the aftermarket part manufacturer. A factor to the accident was the soft field in which the emergency…NTSB CHI02FA234Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.NTSB CHI02FA233Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.NTSB CHI01LA213Accident · Serious injuriesLimited investigationFinal reportLaPorte MXL II Sport · Gaines Twp., MIThe pilot's poor planning which resulted in foreign object damage to the propeller, and the low altitude at which the loss of power occurred which resulted in the pilot not being able to properly flare the airplane. Factors associated with the accident were…NTSB CHI01IA073Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Grand Rapids, MIThe uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.NTSB CHI00LA258Accident · No injuriesLimited investigationFinal reportBeech K35 · Holland, MIthe misjudged glidepath by the pilot. Factors to the accident were the loose throttle cable due to improper installation by maintenance personnel, and the intentional engine shutdown during the precautionary landing by the pilot.NTSB CHI00LA215Accident · No injuriesLimited investigationFinal reportLutke Rotoway Exec 90 · Kalamazoo, MIthe loss of main rotor rpm due to the failure of the top engine mount and the subsequent loss of the main rotor drive belt tension. A factor was the confined area landing zone.NTSB CHI00LA188Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20L · Gregory, MIthe control stick movement being restricted by the pilot's seat-type parachute and the excessive descent rate and airspeed during landing. A factor to the accident was the pilot's lack of familiarity with the aircraft.NTSB CHI00LA135Accident · 1 fatalLimited investigationFinal reportRotorway Exec 162F · Ithaca, MIthe door separation for undetermined reasons and the foreign object damage due to the door impact to the tailboom and tail rotor drive system.NTSB CHI99IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-14 · Grand Rapids, MIthe frozen elevator control. Factors were the rain and the low temperatures.NTSB CHI99FA105Accident · 1 fatalField investigationFinal reportBeech C-45G · Romulus, MIthe aircraft control not maintained and the inadvertent stall by the pilot while maneuvering to the landing area. The open door was a contributing factor.NTSB CHI98LA341Accident · No injuriesLimited investigationFinal reportCessna 210D · Sturgis, MIthe cracked left main landing gear saddle, resulting in the pilot's inability to get the gear into the down and locked position.NTSB CHI98LA281Accident · No injuriesLimited investigationFinal reportLuckey Dragonfly II · Caro, MIan improper inflight decision when he mistook the road for the runway of the nearby airport to land on. A factor in this accident was the total failure of the engine's crankshaft.NTSB CHI98LA151Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Monroe, MIthe pilot-in-command's inability to rotate during takeoff due to restricted movement of the elevator controls for undetermined reasons.NTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.NTSB CHI97IA195Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Flint, MIAn electrical short in the wiring of the left wingtip oscillating position light auto transformer and a failure of the system circuit breaker.NTSB CHI97IA073Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Romulus, MIa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…NTSB CHI97FA056Accident · 2 fatalField investigationFinal reportCessna 210N · Highland, MIin-flight breakup of the airplane for undetermined reason(s).NTSB CHI97IA034Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-211 · Romulus, MIrestricted movement of the autopilot mode engagement/disengagement lever bearing in the rudder artificial feel and trim unit. A factor relating to this incident was: company management not implementing the respective service bulletin.NTSB CHI97FA030Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Grand Rapids, MIa passenger sustained a fractured ankle during an emergency evacuation for undetermined reasons.NTSB CHI96FA185Accident · 1 fatalField investigationFinal reportCorey Cirrus VK-30 · Lapeer, MIincomplete cure of the bonding material in the cruise flap, improper material in the cruise flap hinge, and improper welding of the cruise flap push rod end caps. Factors were delamination of the cruise flap, partial failure of the cruise flap hinge, and…NTSB CHI96IA109Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Detroit, MIa defective diode in the number two stabilizer actuator that produced an intermittent loss of electrical motor power during transient, closed loop control of the actuator. A factor was the intermittent open circuit in the elevator servo controller…NTSB CHI94LA013Accident · No injuriesLimited investigationFinal reportHughes 269A · Coldwater, MIthe fatigue failure of the tailboom support strut attachment lug.NTSB CHI93FA378Accident · 2 fatalField investigationFinal reportAero Commander 690A · Lansing, MIwas the pilot-in-command not maintaining aircraft control during the intermittent operation of the electrically operated attitude gyro. Factor's associated with this accident are an fluctuating (intermittent) electrical system inverter and the…NTSB CHI93DEM02Accident · Minor injuriesFinal reportSheats FALCON-XP · Zeeland, MIan inadequate maintenance inspection by the pilot/owner and the separation of the wing skin.NTSB CHI93IA248Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Detroit, MIthe failure of a navigation system (#1 INS) for reason or reasons undetermined.NTSB CHI93DEM01Accident · No injuriesFinal reportAmato Corben JR. ACE · Traverse City, MIinadequate lubrication of the tailwheel bearings and inadequate preflight by the pilot/owner which resulted in a seized tailwheel.NTSB CHI93LA145Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Port Huron, MIfailure of the landing gear actuator cable.NTSB CHI93IA078Incident · No injuriesIncident investigationFinal reportFokker F-28 MK 1000 · Detroit, MIImproper lubrication of the horizontal stabilizer gearbox by company maintenance personnel. A factor was the manufacturer's inadequate service procedure.NTSB CHI92DEC04Accident · Serious injuriesFinal reportTennessee Engineering & Manf Z-MAX · Manchester, MIAn inadequate design of the rudder control system by the pilot/builder of the airplane, a pullup performed by the pilot, and a total failure of the rudder flight control system.NTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.NTSB CHI92LA185Accident · No injuriesLimited investigationFinal reportCessna 150H · Three Rivers, MIThe pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.NTSB CHI92DEM02Accident · No injuriesFinal reportGillespie/Pitts S1C · Freeland, MIA total failure of the rudder control cable and unavailability of rudder to control the airplane during its landing process. Factors which contributed to the accident were directional control and remedial action not being possible on behalf of the pilot.