NTSB investigations, MI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 CHI88LA241Accident · No injuriesLimited investigationFinal reportCessna 550 · Fremont, MIThe airplane ran off the end of the runway and struck an embankment after landing downwind from a VOR approach during heavy rain. Both pilots reported poor braking action and ineffectiveness of reverse thrust application after touchdown and during the landing…NTSB CHI88FA231Accident · 1 fatalField investigationFinal reportCessna 172P · Boyne City, MIThe pilot and his passenger were flying low over a sailboat regatta to photograph sailboats. As the pilot maneuvered for a photograph, he throttled back and banked the aircraft in a steep bank. Subsequently, the aircraft stalled and there was insufficient…NTSB CHI88LA227Accident · No injuriesLimited investigationFinal reportCessna 172G · Sparta, MIDuring a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness…NTSB CHI88DEC07Accident · No injuriesFinal reportCessna 305A · Gregory, MIFailure (at first partial, then total) of the aircraft's powerplant at an altitude of about 100 feet above the ground during the initial climbout with a glider in tow; a forced landing ensued, during which the aircraft struck a fence, a small tree, and…NTSB CHI88LA225Accident · Minor injuriesLimited investigationFinal reportBeech B-95 · Alma, MIDuring approach to landing the pilot entered a steep (45 degree bank) left turn from base to final. The pilot stated that he did not realize it at the time, but this action unported the fuel line to the left engine, causing the engine to fail due to fuel…NTSB CHI88DEC06Accident · Minor injuriesFinal reportSackett J2 · Deckerville, MIThe pilot's poor judgement and misjudged perceptions while practicing takeoffs and landings in an unfamiliar aircraft. The pilot executed a hard landing, touching down short of the runway and collapsing the landing gear. The aircraft skidded to a stop on the…NTSB CHI88DEM10Accident · No injuriesFinal reportGrumman G-164B · Schoolcraft, MIThe pilot failed to maintain directional control while maneuvering the aircraft to avoid an obstacle during the landing roll. The aircraft's right wing impacted a corn crop and the aircraft swerved/ground looped to the right and skidded to a stop, nose down.…NTSB CHI88DEM09Accident · No injuriesFinal reportHulliberger Starduster II · White Cloud, MIUnauthorized pilot failed to maintain adequate control of the homebuilt aircraft during the landing roll. The aircraft veered off the right side of the runway, and the left wing struck the ground.NTSB CHI88DEM08Accident · No injuriesFinal reportChampion 7KCAB · Grand Haven, MIThe pilot's inattentive fuel system monitoring, and the resultant total failure of the aircraft's powerplant due to fuel exhaustion. A forced landing was executed on a stretch of beach with sand dunes, and the aircraft was substantially damaged during the…NTSB CHI88LA194Accident · No injuriesLimited investigationFinal reportCessna 150K · Detroit, MIHard landing made by the student pilot resulting in a nose gear failure due to overload forces and the aircraft flipping over on its back.NTSB CHI88DET05Accident · No injuriesFinal reportBell 47J · Dowagiac, MIFailure to maintian adequate rotor RPM by the unqualified pilot.NTSB CHI88LA191Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · St. Charles, MIThe pilot failed to attain sufficient altitude to clear obstacles during the initial climb-out and the aircraft collided with trees located off the departure end of the private grass strip. The aircraft fell to the ground, where it caught fire and was…NTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.NTSB CHI88LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Cheboygan, MIShortly after departure, when the aircraft was approximately 30' in the air, the aircraft's right wing 'dropped hard'. The pilot attempted remedial action, but was unable to regain control of the aircraft before the right wing tip struck the ground. The…NTSB CHI88LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Flint, MIWhile on a solo instructional flight for the purpose of practicing takeoffs and landings, the student pilot executed a hard landing. The aircraft bounced; when it touched down again, the nose gear collapsed and the aircraft skidded to a stop on the runway.NTSB CHI88LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Belleville, MIDuring a solo instructional flight for the purpose of practicing touch and gos, the student pilot experienced a loss of control when the aircraft bounced after a hard landing. The pilot failed to perform remedial action as the aircraft continued to porpoise…NTSB CHI88LA171Accident · No injuriesLimited investigationFinal reportCessna 182E · Cedar Springs, MIDuring cruise flight the pilot reported that a total power loss occurred. The pilot executed a forced landing in an open field. On rollout the aircraft struck a stump and then a small shed. The post accident investigation revealed loosefuel caps and no fuel…NTSB CHI88LA168Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Menominee, MIDuring a demonstration of an autorotation to a run-on landing, the helicopter skids dragged in the soft grass upon touchdown, and the helicopter veered to the left. The pilot failed to maintain aircraft control when the helicopter veered left, the right skid…NTSB CHI88DEM07Accident · No injuriesFinal reportSilliman Hatz CB-1 · Battlecreek, MIWhile attempting to execute a forced landing due to an engine failure, the pilot misjudged his emergency procedure and collided with trees then the gnd during the descent to the fairway he had selected for landing. The engine failure was due to fuel…NTSB CHI88DEC05Accident · No injuriesFinal reportBell 47D1 (OH-13E) · Stockbridge, MIThe plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…NTSB CHI88FA162Accident · 1 fatalField investigationFinal reportCessna 172M · Holland, MIPilot's inadequate aircraft handling during the approach to landing and landing flare phase of flight. The pilot's failure to recognize and avoid a situation from which it was impossible-due to the weight of the aircraft, the amount of power available from…NTSB CHI88LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Breckenridge, MIThe student pilot was attempting to land on the private airstrip when the aircraft touched down hard on the runway. The aircraft bounced back up into the air. The pilot was unable to maintain control of the aircraft and upon impacting back onto the runway the…NTSB CHI88DEC04Accident · No injuriesFinal reportPerkins Dragonfly · Fowlerville, MIThe pilot failed to maintain positive control of his homebuilt aircraft by taking appropriate actions for recovery from the bounced landing. The aircraft contacted the ground abruptly on the third bounce and the upper wing spar failed. The pilot's lack of…NTSB CHI88LA138Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Howell, MINTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.NTSB CHI88DEM06Accident · No injuriesFinal reportKoopsen Miller Sport II · Lake City, MIJust prior to turning on final approach to land, the pilot experienced a complete loss of power. He continued the approach but decelerated more rapidly than he anticipated and was unable to clear a stand of trees on the approach path. Examination revealed a…NTSB CHI88LA127Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2 · Three Rivers, MIThe owner of the acft stated that he released the acft to the PIC so that he could 'checkout' another plt and help her with her tailwheel landings. During their fourth tkof, the plt being checked out attempted to climb out of ground effect with insufficient…NTSB CHI88LA133Accident · No injuriesLimited investigationFinal reportAlon A2 · Flushing, MIDuring initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the…NTSB CHI88DEM05Accident · No injuriesFinal reportBell 47G-2A · Midland, MIThe plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter…NTSB CHI88LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Plainwell, MIDuring an unauthorized flight of unknown duration, by person(s) unknown, aircraft control was not maintained. The aircraft was observed by a witness to 'wobble' as it approached the runway. The witness then saw the aircraft 'crash' into the grass at the left…NTSB CHI88DEC02Accident · 1 fatalFinal reportChappel Ratsrepus 300 · Pontiac, MIDestructive wing/aileron flutter is suspected, but not sufficiently substantiated through research and calculations to be cited as the probable cause of this accident.NTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.NTSB CHI88IA111Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Detroit, MINTSB FTW88IA097Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Detroit, MIThe PIC made an unscheduled landing following decompression at 30,000 feet. The aircraft had been written up by flightcrews numerous times between may 7 and may 9 for pressurization problems. Pressure bulkhead at station 940 in the right wheel well cracked 15…NTSB CHI88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sault Ste Marie, MIDuring taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,…NTSB CHI88LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-140D · Whittemore, MIWhile landing on a farmer's strip, the pilot failed to maintain directional control of the aircraft. The aircraft swerved off the left side of the strip, into a plowed field where it struck a rock.NTSB CHI88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140D · Flushing, MIWhile on final approach for landing on a short, grass strip, the pilot said she encountered sunglare which restricted her visibility such that she was unable to judge the landing. Touchdown occurred with insufficient runway remaining to stop the aircraft. The…NTSB CHI88DEC01Accident · Minor injuriesFinal reportBeech 23 · Brighton, MIThe unsuitable terrain (trees and a lake) encountered during a forced landing made necessary by the partial failure of the aircraft's powerplant during and attempted go-around. The occupants were able to exit the aircraft before it sank; the aircraft was…NTSB CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…NTSB CHI88DEM04Accident · No injuriesFinal reportAnderson Pitts S-1S · Mt. Pleasant, MIThe pilot was performing some inverted maneuvers when the engine quit. The pilot stated he attempted to restart the engine but was unable to. He then executed an emergency landing in a farm field. During the landing roll the pilot was unable to maintain…NTSB CHI88DEM03Accident · No injuriesFinal reportGrumman G-164A · Allegan, MIThe pilot had just completed two swath runs and was turning to start the third when the aircraft began to buffet and approached a stall. The pilot then lowered the nose of the aircraft and added full throttle. After applying full throttle the pilot stated he…NTSB CHI88IA088Incident · Minor injuriesIncident investigationFinal reportBoeing 727-251 · Detroit, MINTSB CHI88FA082Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Alma, MIDrg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…NTSB CHI88LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Sebewaing, MIThe plt rprtd that when he landed, the acft bounced twice & went straight forward for about 200 ft. when he applied brakes, the acft veered to the left. Subsequently, the acft went off the runway & into a ditch where the nose gear collapsed. The plt believed…NTSB CHI88FA075Accident · 3 fatalField investigationFinal reportBeech E18S · Warren, MIThe flt was an air taxi cargo flt carrying truck parts. After takeoff, the twr asked the plt if he was in difficulty and the plt replied 'roger' and requested a change of flt plan. The acft was seen flying erratically just above the tree tops. The acft…NTSB CHI88DEM02Accident · No injuriesFinal reportGalloway XTC · Lowell, MIThe pilot of the homebuilt aircraft was attempting to perform some 'pattern flights' when, after turning on to the base leg of the traffic pattern, the engine seized. The pilot attempted to 'dead stick' the aircraft to the runway, but altitude and airspeed…NTSB 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 CHI88LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIWhile taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank.NTSB CHI88LA065Accident · No injuriesLimited investigationFinal reportCessna 172F · Brighton, MINTSB CHI88LA058Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MI