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 CHI83LA397Accident · Minor injuriesLimited investigationFinal reportCarter MONNETT-MONI · Port Huron, MIWhile turning crosswind after takeoff the eng quit. The plt was unable to restart the eng & the acft collided with trees. The plt stated the acft's ignition system was the cause of the eng failure.NTSB CHI83LA395Accident · No injuriesLimited investigationFinal reportCessna 150H · Allegan, MIThe acft collided with a guard rail during a precautionary landing in IMC weather. During the flt wx cond deteriorated and the plt became concerned about collision with structures(towers) in the area and elected to land on a fairground. Braking was poor on…NTSB CHI83LA401Accident · No injuriesLimited investigationFinal reportPiper PA28-180C · Ann Arbor, MIThe acft veered to the left and hit a rwy light during landing. The weather was VMC with a wind from 320 degrees at 10 KTS. The active rwy was 27. The ATC specialist in the tower said 'the acft appeared to dive toward the rwy' and 'to hit very hard.' After…NTSB CHI83LA392Accident · Minor injuriesLimited investigationFinal reportAyres S2R-R1820 · Essexville, MIWhile on a swath run, the acft collided with a power line & crashed in a corn field. The plt received a head injury during the accident & was unable to recall details of the occurrence. According to witnesses, he was on a northerly run & was crossing under…NTSB CHI83LA391Accident · No injuriesLimited investigationFinal reportDemeter Hummer B · Linden, MIThe ultralight acft crashed after takeoff when the engine failed at about 100 ft AGL. The acft climbed to about 100 ft AGL at a distance of about 240 ft from the end of the rwy. At this point the engine quit and the pilot started a 180 degree turn toward an…NTSB CHI83LA380Accident · No injuriesLimited investigationFinal reportCessna C-152 · Hamtramck, MIWhile en route, the eng lost power & the plt restarted the eng. After flying aprx 4 mi further, the eng lost power again, and again, the plt obtained a restart. After a 3rd loss of power, the plt was making a forced landing when the acft collided with an…NTSB CHI83LA378Accident · No injuriesLimited investigationFinal reportCessna T210M · Troy, MIThe acft collided with trees during a forced landing. The pilot stated he had used all the fuel in one tank. He continued flt to Troy-oakland advising detroit of his fuel state. Detroit approach vectored him to the arpt but the pilot claimed he could not…NTSB CHI83FA381Accident · 2 fatalField investigationFinal reportBeech G18S · Evart, MIThe acft collided with a utility pole and a large tree during a forced landing after a power loss on takeoff. Witnesses heard the acft backfiring and the ground run was excessively long. Immediately after takeoff the acft went through the tops of pine trees.…NTSB CHI83FU008Accident · 1 fatalFinal reportEipper Quicksilver MX · Shelby Township, MIThe ultralight was flying low over a gravel pit and suddenly pulled up and went into a dive. The acft engine was runningthroughout the maneuver according to witnesses. The acft did not pull out of the dive and the acft dove into the water. One witness thought…NTSB CHI83LA368Accident · No injuriesLimited investigationFinal reportBeech A36 · Marine City, MIThe acft ran off the end of the rwy during landing. The pilot had called UNICOM for wind information but had received noanswer. The pilot decided by smoke drift to land to the north. The winds at the arpt were from th south. The pilot landed about half way…NTSB CHI83LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Baroda, MIThe acft collided with wires during a spraying operation. During the forced landing following the wire strike the acft nosed over. The pilot said chemical spill from powerline strike obscured his vision through windshield and made the forced landing…NTSB CHI83FA359Accident · 2 fatalField investigationFinal reportPiper PA-28-180D · Bay City, MIAfter an overshoot landing attempt the pilot initiated a go-around the acft overan the end of the runway, traveled for about 330 ft and colided with a auto mobile. The roof ofthe auto was sheared off causing 2 fatal and 4 serious injuries.NTSB CHI83FA347Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Muskegon, MIThe acft collided with trees after performing an aerobatic maneuver at low altitude. Witnesses near the scene said the acft was flying low; most heard the engine running. Some said that at the top of a loop the engine sounded like it stopped. On the descent…NTSB CHI83LA345Accident · No injuriesLimited investigationFinal reportCessna 172 · Naubinway, MIThe acft struck a stop sign and nosed over while attempting to make an emergency landing following fuel exhaustion.NTSB CHI83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe acft bounced during landing and collapsed the nose gear. The student pilot was practicing landings and had been successful on 4. The fifth in the series was intended to be the last one. The pilots recommendation for prevention was to go around as soon as…NTSB CHI83LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Charlotte, MIDuring the takeoff portion of a night touch-and-go, the acft collided with a deer that ran into the acft.NTSB CHI83LA328Accident · No injuriesLimited investigationFinal reportCessna 182Q · Turner, MIThe plt reported that during a landing, the acft touched down at about the midpoint of a 2140 ft, grass rwy. When he applied braking action, the acft skidded on the grass surface & the plt was unable to stop on the landing area. After departing the rwy, the…NTSB CHI83LA318Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Utica, MIThe student pilot made a delayed decision to land and landed within a few ft of wires without seeing them. The ground crew tried to hold him but the balloon still had too much lift. The student then saw the wires and tried to go over thembut the collision…NTSB CHI83LA317Accident · No injuriesLimited investigationFinal reportCessna 210L · Traverse City, MIThe plt reported that when the landing gear handle was moved to the up position, the hydraulic pump continued to operate. Subsequently, the circuit breaker for the pump was pulled to keep the motor from overheating. Several attempts to lower the gear with the…NTSB CHI83LA313Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanwood, MIThe acft was damaged during landing from a tire failure. During landing the plt heard a report and took off again. He performed a minimum speed landing and during landing the tire rim dug into the surface causing sudden stoppage. The tirefailure had resulted…NTSB CHI83LA312Accident · Serious injuriesLimited investigationFinal reportJ. Roberts Pitts Special · Grand Haven, MIAfter a touch-and-go landing, the acft was climbing thru aprx 100 ft AGL when the eng abruptly lost power. A straight ahead landing was not feasible. While the plt was maneuvering to land, the acft impacted in a right wing low, nose down attitude. An…NTSB CHI83LA320Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mason, MIThe student & instructor plt (CFI) were practicing landings in the student's acft, which was equipped with brakes only on the left side. Reportedly, the student flared high during a landing & the CFI added power to recover. After touchdown, the roll-out was…NTSB CHI83LA315Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-36 · Ionia, MIThe glider struck the ground on the nose during the appraoac. The plt stated that nose pitch oscillations were due to his overcontrolling the glider because of his lack of experience in the glider's pitch sensitivity.NTSB CHI83LA322Accident · No injuriesLimited investigationFinal reportCessna 172 · Alpena, MIDuring a landing, the student plt did not use the flaps as he was taught. As a result, the landing occurred further down the rwy & at a higher speed. During the landing, the acft bounced, then touched down nose 1st & bounced 2 more times. The student found…NTSB CHI83LA309Accident · No injuriesLimited investigationFinal reportCessna 172M · Holland, MIThe acft ran off the end of the runway and collided with trees during landing. This runway is 3075 feet long. The wind was calm and the pilot failed to use flaps. The pilot was making a simulated engine failure-power off-landing. He said when it became…NTSB CHI83LA314Accident · No injuriesLimited investigationFinal reportFlug-Und Fahrzeugwerke Diamant · Frankfort, MIThe plt reported that during a winch tow takeoff the right wing caught in tall grass & soft sand, & the glider ground-looped.NTSB CHI83LA305Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Berrien Springs, MIThe plt reported that when he landed, the wind was variable from west to north at 12 to 15 KTS. He stated that after touchdown, he held the tail up in the slip stream. Reportedly, directional control was good until the acft entered an area that was not…NTSB CHI83LA307Accident · No injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Leslie, MIThe acft landed hard and bounced. The acft drifted left off the rwy and nosed over in a plowed area. The landing was on rwy 18 and the wind was from 270 degrees at 8 KTS. The student pilot said he needed more dual time in crosswind landings. He had 11 hours…NTSB CHI83LA283Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Alma, MIThe acft collided with the VASI lights during landing. The pilot was landing on rwy 27 with winds from 210 degrees at 12 KTS. He reported gusty winds but gave no estimated velocity of the gusts. He said he touched down on the right main gear with the left…NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB CHI83LA265Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Flint, MIAfter takeoff, the plt leveled the Balloon, and a short time later, he collapsed to the floor of the gondola & had difficulty breathing. The Balloon began descending. Subsequently, it hit the porch of a house & was damaged. The plt died from acute myocardial…NTSB CHI83LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fraser, MIThe eng lost power on takeoff & the acft struck trees as the plt was attempting to return to the aprt. The center electrodes of the spark plugs were worn & covered with carbon. None of the plugs would fire above 55 PSI when put in a champion fire testor.…NTSB CHI83LA259Accident · No injuriesLimited investigationFinal reportCessna 172 · Gaylord, MIThe plt initially departed grayling, MI with intermediate stops in alba, Gaylord, alba again, & finally terminating at grayling. The plt stated he landed short at alba. He also stated that while practicing landings at Gaylord he ran off the side of the rwy.…NTSB CHI83LA250Accident · Minor injuriesLimited investigationFinal reportBell 47G5A · Detroit, MIThe pilot stated that he was assigned a community affairs project to fly a 'ronald mcdonald' clown to a nearby restaurant for a magic show. During the hover in the landing area the rotor blades struck a light pole. The helicopter pitched forward and landed on…NTSB CHI83LA247Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIThe acft made a forced landing when the engine quit during the turn to final approach. Just prior to engine failure the pilot stated that he changed the fuel selector to what he believed to be the both tanks position but he actually turned it to the off…NTSB CHI83FU003Accident · Serious injuriesFinal reportSunburst 1 · Fraser, MIA witness reported that this ultralight was 1 of 3 that took off on rwy 18, then turned 180 deg to a northerly heading. He reported that the ultralight was in level flt at aprx 200 ft when it suddenly pitched nose down, then it nosed up. At about that time,…NTSB CHI83LA248Accident · No injuriesLimited investigationFinal reportHelio H-391B · Croton, MIThe acft collided with wires on an approach to a lake.NTSB CHI83LA236Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Jackson, MIThe plt stated the eng quit at about 100-200 ft AGL after takeoff. He executed a descending right turn to remain within the arpt boundary & the acft struck the ground. The upper portion of the magneto mount flange was broken & the magneto was hanging by the…NTSB CHI83LA229Accident · No injuriesLimited investigationFinal reportCessna 152 · Holland, MIWhile the student plt was taking off with a left crosswind, he reportedly became distracted when he became aware that he was applying incorrect aileron deflection for wind correction. He stated that he corrected the ailerons, but in the meantime, the acft…NTSB CHI83LA226Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Lansing, MIThe plt was participating in the national 15 meter championship meet. During a triangular course, he ran out of thermal activity & selected a field for a landing. From the air, he thought he had selected an alfalfa field with a 5 to 6 inch growth. However, he…NTSB CHI83LA221Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit, MIThe acft made a forced landing off airport and collapsed the rt main landing gear during a landing on a street after theengine quit. Investigation revealed that the acft was filled with fuel for 2 afternoon flights and not refueled afterwards. During the…NTSB CHI83FA220Accident · Serious injuriesField investigationFinal reportSchaffer-Provencher UW · Stockbridge, MIThe balloon landed downslope at about 7 KTS in a rip/drag landing without ground assistance. One of the two passengers was on the downslope side of the basket facing the direction of landing. She lost her grip on the top rail of the basketduring touchdown and…NTSB CHI83LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ironwood, MIThe acft drifted to the right on the rwy during a crosswind landing and collided with a rwy light.NTSB CHI83LA215Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Grandville, MIReportedly, the plt increased the bank angle during a turn to align the acft on final apch, then the plane lost speed & stalled. Subsequently, the acft impacted the ground aprx 480 ft southwest of the rwy threshold. Aprx 10 mi east at grand rapids, MI, the…NTSB CHI83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Spring Arbor, MIThe acft made a forced landing off the arpt when the engine quit during takeoff climb. The acft had about 1/2 a tank of fuel in both right and left tank before takeoff. The plt was using the right tank for takeoff. The plt had done a 180 degree left turn on…NTSB CHI83LA208Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Ceresco, MIThe plt reported that the acft was normal until he was on final apch to land. The acft began to loose too much altitude, so he advanced the throttle, then the eng lost power. Subsequently, the acft hit the top of a tree short of the rwy, then crashed. An exam…NTSB CHI83LA212Accident · No injuriesLimited investigationFinal reportCessna A185F · Eaton Rapids, MIThe acft nosed over during landing at the plt's private strip the plt stated that he took off for a 15 minute local flt and during landing he touched down in a soft area. The wheels bogged in and the acft nosed over. He had taken off to thenorth and landed to…NTSB CHI83LA202Accident · No injuriesLimited investigationFinal reportCessna P210N · Lansing, MIThe acft overran the rwy and slid on wet grass into a ditch. The rwy was 2432 ft long and the wind was from 180 degrees at 12 KTS gusting to 29 KTS. The plt said that just prior to touchdown the airspeed seemed to increase and the acft floated farther down…NTSB CHI83LA199Accident · No injuriesLimited investigationFinal reportBeech B-60 · Detroit, MIThe acft collided with another parked and unoccupied acft while parking. The tail of the moving Beechcraft was damaged substantially. Damage to the parked acft was minor. The weather was VMC but a light rain was falling.NTSB CHI83LA195Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Gaylord, MIThe acft nosed over immediately upon landing on a turf rwy. An inspection of the rwy revealed two skid marks in the turf about 75 ft long and 900 ft from the approach end of rwy 36.