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 CHI84LA407Accident · No injuriesLimited investigationFinal reportCessna 150M · Clio, MIThe airport consists of three sod strips none of which contains rwy lights. The CFI and student departed the arpt for a local night flight. The CFI stated that upon returning to the arpt he called the arpt office on the UNICOM freq and requested the night…NTSB CHI84LA392Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Rapids, MIIn an effort to land at the threshold the acft collided with a fence and landed short of the prepared surface. Runway edge lights were operating but runway end identifier lights were not installed.NTSB CHI84LA380Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Pontiac, MIDuring a takeoff climb at 400 ft AGL the eng lost pwr. The plt stated that he failed to switch fuel tanks. The right fuel tank was found empty.NTSB CHI84LA371Accident · No injuriesLimited investigationFinal reportCessna 210M · Howell, MIThe plt stated that about 10 min after takeoff, the fuel flow fluctuated & slowly went to zero. He turned the aux fuel pump on, increased the mixture to rich & repositioned the fuel selector to another tank, but to no avail. The plt made a forced landing in a…NTSB CHI84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lake City, MIAccording to the plt, at about 30 ft AGL after takeoff the eng RPM began to decrease. The acft flew into a tree adjacent to a road near the end of the rwy. A visual inspection of the engine revealed no mechanical malfunctions. The property owner reported that…NTSB CHI84FA354Accident · 3 fatalField investigationFinal reportCessna 150A · Twin Lake, MIThe acft collided with the ground in a spiral like descent with the eng in a power retarded state as evidenced by the sound effects. The was no missing or backfiring of the power plant. The acft struck the ground vertically after being seen in a nose dwn…NTSB CHI84LA351Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Acme, MIThe landing gear collapsed as a result of an intentional ground loop when the aircraft overran the runway after a bounce 450 ft beyond the approach end of the 2300' long grass strip. The pilot stated he added throttle, then landed on the remaining runway, but…NTSB CHI84LA347Accident · No injuriesLimited investigationFinal reportLindsay Davis Benson B8M · Gross Ile, MIThe student pilot was in the airport traffic pattern when he noticed the eng cylinder head temp exceeding the red line. He attempted to lower the temp by reducing the eng RPM but could not maintain alt. The pilot maneuvered the acft toward the airport and at…NTSB CHI84LA405Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mackinac Island, MIPlt stated that during takeoff, at an alt of 40 feet AGL a loss of power occurred. He reported he landed straight ahead on the end of the runway. The airplane continued into a field off the departure end of the rwy, into weeds before it struck a steel fence…NTSB CHI84FA343Accident · 2 fatalField investigationFinal reportPiper PA-12 · Alpena, MIWitnesses stated that the acft flew at a very low altitude over the lake performing what appeared to be a series of stalls and recoveries with the acft climbing steeply to aprx 150 ft above the lake and then dropping sharply back down within a few feet of the…NTSB CHI84LA330Accident · No injuriesLimited investigationFinal reportDahlman BD4 · Grand Haven, MIThe pilot indicated that he observed the wind tee indicating a westerly wind but during landing flare/roll, a gusty wind from the south caused the acft to veer to the right. The acft veered off the runway and the left main gear separated.NTSB CHI84LA327Accident · No injuriesLimited investigationFinal reportGulfstream 690 · Detroit, MIOn right engine start the right main landing gear collapsed. The gear handle was found in the down position after the accident. Functional and bench check of the actuating components revealed no discrepancies.NTSB CHI84LA323Accident · Serious injuriesLimited investigationFinal reportFairchild BC12-D · Hessel, MIAcft departed in VFR conditions for short x-country flt. No weather briefing was obtained. On initial encounter with deteriorating ceiling and visibility conditions, plt reduced altitude in attempt to maintain ground reference. Course reversal not initiated…NTSB CHI84FU007Accident · 1 fatalFinal reportCollins Fisher FP-202 · Ludington, MIThe ultra-light was constructed by the pilot and two other persons. This group had no previous experience in aircraft construction. This was the third known flight for this aircraft. It had been flown two days prior to the accident and an adjustment to the…NTSB CHI84LA305Accident · No injuriesLimited investigationFinal reportBeech B-35 · Harrison, MIThe plt inadvertently landed the acft with the landing gear retracted. He said he forgot to lower the gear. Most of his 200+ hours of flight time had been in fixed gear acft.NTSB CHI84LA302Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Munising, MIThe acft nosed over during landing on a solo instructional flt. The students instructor said the approach seemed normal. When the acft flared the nose struck the ground first. The student said he 'did not remember pushing the wheel forward but apparently I…NTSB CHI84LA299Accident · No injuriesLimited investigationFinal reportCessna 172 · Alpena, MIThe plt stated that while flaring for their 5th stop-&-go at night, a deer ran out onto the rwy. The acft collided with the deer & the left main landing gear was sheared off. The acft then veered off the rwy.NTSB CHI84LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Almont, MIOn 7/13, the plt departed fraser, MI, with full fuel tanks & flew to lakes of the north. The next day he flew to mackinac island. He then departed mackinac island without refueling. Near flint, MI, the plt contacted apch control & informed them he was low on…NTSB CHI84LA295Accident · No injuriesLimited investigationFinal reportCessna 172M · Southgate, MIAfter takeoff, the plt climbed to 8500 ft MSL to practice maneuvers. He then made a descent to 4500 ft & began heading back to the arpt, then continued descending to 1800 ft & entered the tca. The eng lost power aprx 7 miles from the airport. Later, during an…NTSB CHI84FA289Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Pullman, MIThe acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…NTSB CHI84LA291Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti FN-333 · Lansing, MIThe acft was not flown for 6 yrs. During last annual inspection, 67 hrs of labor, the batteries (2), spark plug gaskets,magneto gaskets, battery cable lugs and impulse coupling were replaced. The fuel quantity transmitter, battery, magnetos and spark plugs…NTSB CHI84LA283Accident · No injuriesLimited investigationFinal reportPitts S-1C · Port Sanilac, MIThe acft was on a VFR x-country when the weather began to deteriorate. The plt overflew sandusky arpt with wx 0F 1000 ftovercast and visibility 3 miles in fog. He said he 'inspected' the arpt as a possible landing site but continued the flt. Following a road…NTSB CHI84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe plt stated that during preflight, he noticed that after straining the fuel sump, the strainer handle did not go backin as FAR as it should have. He checked to make sure no fuel was leaking & decided to take off. En route, he smelled fuel vapors. The eng…NTSB CHI84LA281Accident · No injuriesLimited investigationFinal reportJordan Henry J Acey Deucy P70 · Holly, MIWhile flying over a wooded terrain, the eng lost power. The plt selected an area with the least amount of trees for a forced landing. During the landing, the right wing tip hit a tree & plane crashed. An exam of the eng revealed that the alternator belt had…NTSB CHI84LA279Accident · Serious injuriesLimited investigationFinal reportBell 47G2 · Detroit, MIThe acft landed in the Detroit river after the engine sputtered and the acft vibrated. The plt reduced pwr & collective and pushed the cyclic forward. The RPM reduced from 3000 to 2500 but the rotor and engine RPM remained married. The plt adjusted descent…NTSB CHI84FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 172P · St. Joseph, MIPieces of wreckage and the body of the plt were recovered from lake Michigan aprx 4 mi sw of st Joseph. Wx at the dep arpt was VFR but deteriorated along the route of flt over the lake due to fog becoming IMC. A caution statement printed on the chicago…NTSB CHI84LA309Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle · Osseo, MIThe plt stated that the thermals dissipated & he had to make an off arpt landing. The landing was made in a field of tall grass & the left wing contacted the grass first resulting in a 90 deg ground loop. The aft fuselage section separated.NTSB CHI84LA276Accident · No injuriesLimited investigationFinal reportCessna 150G · Williamston, MISome cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.NTSB CHI84LA258Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Mears, MIThe pilot reported that when the amphibious aircraft reached 8 to 10 feet AGL during takeoff, a x-wind gust caused the left sponson to contact the water surface. This caused loss of control and resulted in the plane crashing inverted in the Lake.NTSB CHI84LA244Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7B · Lake Orion, MIA 74 year old passenger in a balloon lost her footing during landing and fell on her arm. Later examination revealed that her arm was broken. The plt and another passenger were not injured. The plt reported that the passengers had been briefed on landing and…NTSB DCA84AA028Accident · Minor injuriesFinal reportMcdonnell Douglas DC-9-31 · Detroit, MIDuring arrival, the aircrew (visually & by use of wx radar) noted thunderstorms (tstms) west & southwest of the arpt. The crew elected to continue & make an ILS apch. At 1636, a spcl wx obsn had tstm info, but was not noted. At 1650, the vis dropped to 1/4 mi…NTSB CHI84LA233Accident · No injuriesLimited investigationFinal reportRobert Judd Sonerai II · Troy, MIThe plt reported that after a local flt he began a reduced power (1800 RPM) descent from 4500 ft MSL back to the arpt. At 3300 ft MSL the eng quit. The plt was unable to restart the eng as the prop was not windmilling & the acft was not equipped with an eng…NTSB CHI84IA252Incident · No injuriesIncident investigationFinal reportFairchild SA-227-TT · Pontiac, MIThe aircrew noticed a 'nose up' pitch change during descent at about the time they were leveling to slow for the arpt pattern & traffic. The plt reported that full forward yoke pressure was required to stop the nose up condition. The acft was landed without…NTSB CHI84LA234Accident · No injuriesLimited investigationFinal reportCessna 152 · Marine City, MIThe student plt reached down to adjust the trim after touchdown & the acft became airborne again. The acft then bounced hard, 2 times, & the student made a go-around. He did not realize the extent of the nose gear damage until after the next landing. During…NTSB CHI84LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Iron Mountain, MIThe plt reported that after he made a normal landing, he retracted the gear instead of the flaps. However, there were indicates that the gear was not fully extended during touchdown. The landing gear circuit breaker was found popped. The landing gear safety…NTSB CHI84LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Berrien Springs, MIThe acft crashed shortly after takeoff near the end of the rwy. The sequence began when the plt noticied that acft acceleration was 'a bit slow' on the rwy. Then a noticable drop in RPM on the right engine occurred at about halfway down the 3100 ft rwy. The…NTSB CHI84LA217Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt. Pleasant, MIThe student plt was in the traffic pattern practicing touch-&-go landings when the eng lost power. He suspected a carburetor problem because of recent problems. He used the primer, at which time the engine responded momentarily. Subsequent, the plt made a…NTSB CHI84LA227Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Flint, MIThe balloonist stated that the wind became stronger during her flt and even though she selected a landing area adequate for a high wind landing the balloon was dragged about 200 ft until the envelope became entangled in trees. The flt lasted about 1 hour and…NTSB CHI84LA220Accident · No injuriesLimited investigationFinal reportLeblanc Dragon FLY · Lansing, MIThe acft inadvertently became airborne on a high speed taxi test. The plt lowered the nose resulting in a porpoise & thecanard was damaged. The acft had not been inspected or certified by the FAA. Examination revealed that the right wing had a higher angle of…NTSB CHI84LA211Accident · Serious injuriesLimited investigationFinal reportBell 47G · Drummond Island, MIThe plt had previously made 2 local flts, during which, he practiced water landings & takeoffs as well as other maneuvers. On the 3rd flt, he made several water takeoffs & landings. Then while on a landing, the helicopter began to roll quickly to the right.…NTSB CHI84LA207Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Plainwell, MIThe acft veered to the left side of a grass strip into taller grass which increased the drag on the left main gear. The acft swerved farther off path until a furrow was struck and the acft nosed over. Local winds were reported from 150 degrees at 8 KTS. The…NTSB CHI84LA209Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martin, MIThe plt had landed on a dragstrip after he encountered deteriorating wx. When the wx improved, he took off & attempted to depart over a bleacher area. The plt had difficulty climbing over the bleachers & said 'noticed RPM at 2700, helicopter in a turn.' He…NTSB CHI84LA205Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Pontic, MIThe plt stated that during the flare in a cross-wind landing, the acft ballooned & drifted to the right. The acft then touched down at an angle & the landing gear collapsed. The wind was gusting to 20 KTS.NTSB CHI84LA184Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Alpena, MIPrior to the accident, the owner/plt of the helicopter reportedly 'buzzed' a local baseball game. Shortly after that, the helicopter was observed to maneuver over a wooded area, enter a nose high attitude, then roll or bank & enter a descent into a wooded…NTSB CHI84LA202Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ortonville, MIThe acft landed hard short of the rwy, bounced, & both landing gear collapsed.NTSB CHI84IA197Incident · No injuriesIncident investigationFinal reportde Havilland DHC-7-102 · Battle Creek, MIWhile cruising at 7000 ft MSL, the 1st officer was trimming the rudder, using the rotary switch on the center console, when he felt a 'snap' inside the switch. After that, the switch would rotate freely between the stops. The acft began yawing left & right…NTSB CHI84LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot landed with excess airspeed & bounced. The second landing was harder than the first & collapsed the nose wheel. The acft nose over as it slid off the right side of the rwy. Investigation revealed that the tower had advised the plt to hold…NTSB CHI84LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Marine City, MIThe plt departed london, ontario with 14 gal of fuel on board. He became disoriented & flew over sarnia which he mistookfor detroit. He stated that he waited too long before contacting anyone for help. When he finally called selfridge approach & was being…NTSB CHI84LA163Accident · No injuriesLimited investigationFinal reportWilliam Freeman Glasair · Lambertville, MIThe plt stated that during takeoff, the acft weather vaned into the wind and the left main landing gear went off the rwy. When the acft hit soft plowed dirt after leaving the rwy, it nosed over.NTSB CHI84LA156Accident · No injuriesLimited investigationFinal reportCessna 172D · Bad Axe, MIAfter traveling 100-150 ft on the takeoff roll, the rgt brake seized & the acft veered sharply to the rgt. The acft departed the rwy & went into a muddy area where the nose gear collapsed & the acft nosed down. The plt reported that there were 200 ft long…