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 CHI84FA148Accident · No injuriesField investigationFinal reportPiper Aerostar 600 · Pontiac, MIDuring an ILS apch, the acft collided with treetops while it was slightly left of the apch course near the middle marker. The plt continued to fly the acft to the rwy & the plane touched down about 1000 ft beyond the threshold. At touchdown, the acft veered…NTSB CHI84LA145Accident · No injuriesLimited investigationFinal reportCessna 150F · Davison, MIThe PIC stated that although he was flying the acft the right seat plt was controlling the flap settings. The right seatplt set 20 deg for takeoff. After takeoff they noticed that they would not be able to clear trees so they right seat pltadded full flaps…NTSB CHI84FA142Accident · 3 fatalField investigationFinal reportCessna 175 · Portage, MIDuring a return flt to traverse city, MI, the acft was observed flying at 'tree top' & 'roof height'. In the vicinity of the crash site, the acft was observed maneuvering. It entered a dive a tree top level, then made a sweeping 270 deg turn to about 500 ft…NTSB CHI84LU002Accident · Serious injuriesFinal reportBirdman Enterprises Chinook · Mecosta, MIThe acft stalled during a forced landing and the right wing struck the ground. The plt stated that on his first takeoff full power was not obtained and a turn of 180 degrees was initiated to return to the airstrip. The engine failed completely on downwind and…NTSB CHI84LA140Accident · No injuriesLimited investigationFinal reportCessna 182L · New Hudson, MIShortly after leveling off at 3000 ft the cabin of the acft filled with smoke and the acft lost all oil pressure. Shortly after this the engine quit. During the forced landing in a corn field the acft nosed over. During a post accident investigation it was…NTSB CHI84LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe plt stated that this was his first solo flt. During the first takeoff following a touch and go landing the acft wentoff the left side of the rwy and collided with a snowbank. After the collision the acft nosed over.NTSB CHI84LA137Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600 · Detroit, MIThe taxiway collapsed under the acft as the plt prepared for takeoff. The asphalt surface gave way due to sub-surface erosion and a four ft hole resulted. The acfts left main gear was sheared off.NTSB CHI84LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Ignace, MIThe pilot took off into adverse wx conditions & failed to attain sufficient altitude to clear trees. The purpose of the flight was to search for a missing acft.NTSB CHI84LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot initiated flight into adverse wx conditions in order to pick up a heart attack victim. The pilot encountered fog & in an attempt to return to his departure point, collided with the frozen lake.NTSB CHI84LA117Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Troy, MIThe acft landed in soft grassy terrain alongside rwy 27, when the acft nosed over the nose gear collapsed. The plt was not aligned properly because the north side of the rwy lights were not operating and were notamed as being out of service since 2/19/84.NTSB CHI84LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · South Branch, MIThe student plt was on a solo x-country flt. He reported that when he landed, the acft bounced twice. After the 2nd bounce, the nose gear collapsed & the acft nosed over. The plt reported that the grass strip was rough & not well maintained & that the ground…NTSB CHI84LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Menominee, MIThe acft landed in a swamp and nosed over after the engine lost power. Weather conditions were conducive to carburetor icing. The plt reported that he experienced carburetor icing and a power loss two miles short of the arpt of intended landing.NTSB CHI84LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Lansing, MIThe acft veered off the rwy during landing. The plt tried to straighten the acft with rudder pressure but the acft continued off the rwy into a gully of snow.NTSB CHI84LA102Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Bellaire, MIDuring the flare round out, 100 ft from the rwy at 10 ft AGL the acft stalled at 100 KIAS. Aprx 1/8 inch of ice was present on the airfoils. Moderate rhime ice was reported in the clouds along the route of flight. The plt did not activate the de-ice boots…NTSB CHI84LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIDuring a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots.NTSB CHI84LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIThe student plt lost control of the acft on a snowy rwy and collided with a snowbank. The student added power for takeoff after a touch and go landing and the acft veered to the left. The acft was not corrected before a collision witha snowbank occurred. This…NTSB CHI84LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Holland, MIThe acft contacted a snowbank during landing. After the collision the acft nosed over. The plt stated that the winds forced the acft off the centerline of the rwy into the unplowed area of snow.NTSB CHI84LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIThe plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over.NTSB CHI84FA073Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Traverse City, MIPrior to the flt, the plt made a phone call to a relative who lived near the southeast side of long lake & said he would 'pass over in about 10 min.' After he took off, the acft was observed in a low pass over the southeast corner of the lake. The acft then…NTSB CHI84LA065Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Detroit, MIWhile receiving vectors for an ILS apch, the acft encountered rime icing conditions. The left windshield began icing over & would not clear when the plt adjusted the windshield heat from normal to high. Since the autopilot was engaged, he moved to the right…NTSB CHI84LA064Accident · No injuriesLimited investigationFinal reportCessna 421 · Harbor Springs, MIThe plt stated that an overboost occurred on the right eng during the takeoff roll. He pulled off power on both engs but the acft slid off the rwy into a snowbank.NTSB CHI84LA056Accident · No injuriesLimited investigationFinal reportCessna A185F · Bad Axe, MIDuring arrival, the plt was advised by the UNICOM operator that rwy 21 was the active rwy. Soon after landing, a passenger boarded the acft & the plt took off again. He proceeded to make a pattern around the arpt & initiated another landing on rwy 21. The…NTSB CHI84LA057Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Owosso, MIThe acft crashed shortly after takeoff from owasso airport. The plt stated that he noticed the takeoff roll was longer than normal but everything seemed alright until approximately 100 ft AGL when the acft would no longer climb. The acft impacted about 1/2…NTSB CHI84FA053Accident · 3 fatalField investigationFinal reportCessna T210M · White Lk Twnshp, MIAt about 1600, the acft was taken out of a heated hangar & parked on the ramp for refueling. It remained outside until the plt took off at about 1740 EST. During that time, snow was falling & the temp dropped from 34 to 31 deg. The plt initially contacted the…NTSB CHI84FA049Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Dexter, MIAt 2135 EST, the plt called the lansing fss & requested a wx forcast for the detroit city arpt & winds aloft. He was briefed, but he did not file a flt plan, sometime after 2200 EST, he took off form mason, MI on a passenger flt to ann arbor, MI. At 2252, the…NTSB CHI84FA042Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Easton Township, MIThe acft crashed aprx 3 mi from the departure arpt. According to witnesses, it was flying at aprx 200 ft AGL when the right wing dipped & then the acft went nearly straight into the ground. An inspection of the airframe & flt control sys revealed no evidence…NTSB CHI84FA037Accident · 2 fatalField investigationFinal reportCessna 152 II · Decatur, MIThe acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was…NTSB CHI84LA036Accident · No injuriesLimited investigationFinal reportJordan Acey Deucy · Chesaning, MIThis was the first flight of the homebuilt. Shortly after takeoff the eng quit due to inadequate grounding. The plt returned to the field & made a smooth landing. At the end of the roll out the anchor plate for the landing gear truss failed causing the left…NTSB CHI84LA031Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Monroe, MIThe pilot stated he developed a high sink rate during landing which resulted in a hard landing. The pilot departed the left side of the runway and entered a ditch.NTSB CHI84LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Port Huron, MIThe plt stated that shortly after touchdown several deer came out of the nearby woods & stopped on the left side of the rwy. He attempted to slow the acft down while staying on the right side of the rwy but went off the rwy & collided with a raised concrete…NTSB CHI84LA033Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Burnips, MIReportedly, the plt had consumed 4 beers after 2200 EDT, while at the bostwick lake inn, then consumed another beer after he left the inn. At aprx 0330 EDT, he & a passenger took off from an unlit arpt. The plt stated that shortly after takeoff, he became…NTSB CHI84LA029Accident · No injuriesLimited investigationFinal reportCessna U206G · South Fox Isl., MIThe acft collided with a mound alongside the rwy during landing. The rwy is 3500 ft long turf strip with a 20 degree dogleg 1500 ft from the north end. There is a small hill running along both sides of the rwy. The grass rwy was wet and theacft slid sideways.…NTSB CHI84LA021Accident · No injuriesLimited investigationFinal reportPiper J4E · Troy, MIThe acft departed the side of the rwy during landing and nosed over. A private pilot was being accompanied by a commercial pilot whose CFI cirtificate had expired. During landing roll the private pilot began 's' turns for better forward visibility. The…NTSB CHI84LA018Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Dorr, MIDuring landing the basket hit a hill resulting in the basket stopping suddenly & ejecting the plt & passengers from the basket. The plt thought a passenger was still in the basket so she grabbed the valve line & hung on as the Balloon rose approximately 100…NTSB CHI84AA016Accident · 1 fatalFinal reportKemmeyer Sonerai II · Battle Creek, MIThe plt flew the home built acft from Battle Creek to marshall, MI to talk to friends. After about 30 min, he took off without refueling. Shortly after the acft departed, a witness on a golf course heard the sound of the eng. He looked up & saw the acft in…NTSB CHI84LA015Accident · Serious injuriesLimited investigationFinal reportAdams AB · Wyoming, MIThe balloon collided with the ground, bounced, hit a house and a utility pole before being torn enough to come to rest. The hard landing in an 8 kt wind tore the vent line from the pilots hand, he lost the ability to vent the balloon and during the collisions…NTSB CHI84LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ypsilanti, MIThe acft was struck by a truck as it taxied on the ramp after landing. The fire department reported the truck left a 25 ft skid mark as it came out from an area of parked acft and struck N47519.NTSB CHI84LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Portage, MIThe student plt was on his 1st solo flt. He stated that during the 1st landing, the acft turned right while it was still a few feet off the ground. The plt reported that he had a bad landing so he attempted to go around. During the go-around, the acft turned…NTSB CHI84LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Howell, MIThe acft was on its 1st flt after an annual inspection. During takeoff, a partial power loss occurred at aprx 200 ft AGL. The plt initiated a turn back toward the arpt, then elected to land on or near the median of an interstate highway. During the landing, a…NTSB CHI84LA002Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Hastings, MIThe instructor plt (CFI) knew that the acft was getting low on fuel, but he wanted the student to make one more takeoff & landing. When the acft was climbing thru about 200 ft after takeoff, the eng began losing power. The CFI assumed control of the acft &…NTSB CHI84LA001Accident · No injuriesLimited investigationFinal reportCessna 150 · Iron River, MIThe plt reported that the eng lost power during flt due to carburetor ice. He applied carburetor heat, but the eng would not restart. During a forced landing, the acft encounter rough/uneven terrain & subsequently nosed over.NTSB CHI83LA443Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Eaton Rapids, MIThe acft nose gear collapsed during a hard landing. The landing was on a 2600 ft turf strip. The pilot stated that afterthe acft bounced several times during landing the nose gear collapsed. The acft then slid into a post near the edge of the rwy.NTSB CHI83FA445Accident · 1 fatalField investigationFinal reportCessna 182B · Constantine, MIThe non-instrument rated plt was on a x-country flt on a dark night. During the flt, the acft crashed in a corn field. Just prior to the initial impact, there was aprx a 15 deg descending angle cut thru the corn in the direction of flt & a 30 deg angle cut to…NTSB CHI83LA436Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Pontiac, MIWhile returning from a traffic reporting flt, the plt elected to practice an autorotation. He stated that while he was in the process, the eng failed. He reported that he had initiated standard autorotation procedures, but impacted hard during the landing.…NTSB CHI83LU013Accident · Serious injuriesFinal reportKruer Pterodactyl · Wayland, MIThe plt reported that during takeoff, the eng backfired & quit when the ultralight vehicle was aprx 100 ft AGL. He made a right turn to land back on the rwy. However, he stated that a slipping turn was made which 'resulted in a steep angle of attack on…NTSB CHI83LA435Accident · No injuriesLimited investigationFinal reportCessna 172 · Plymouth, MIThe plt reported that during an apch to land on rwy 18, he encountered heavy turbulence & elected to go around. He reported the wind was from 180 deg at 15, gusting 25 KTS. On the 2nd apch, turbulence was encountered again. The acft was fast & began to float…NTSB CHI83FA419Accident · 1 fatalField investigationFinal reportWarren Moneri S · Lapeer, MIThe glider collided with the ground after an unscheduled tow release at about 150 ft AGL.this was the plts first flt in this acft after having the engine removed and the acft recertified as a glider. Ground personnel observed the glider and tow pilot release…NTSB CHI83LA412Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Houghton Hts., MIDuring takeoff, the acft entered a steep right turn & subsequently, the right wing struck a tree & the plane crashed. The acft was being flown by the owner, who did not possess an FAA plt or medical certificate. According to him, the acft entered a 'downdraft…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…NTSB CHI83FA402Accident · 1 fatalField investigationFinal reportBeech 58P · Cassopolis, MIThe acft entered a flat spin while practicing VMC maneuvers. The right fuel valve was in the off position.