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 CHI85LA240Accident · Serious injuriesLimited investigationFinal reportHaney Polliwagon · Lambertville, MIThe plt was unable to flare the acft with full up elevator and the nose gear contacted the rwy during landing. The acft bounced and contacted the rwy again resulting in a gear collapse. The plt stated that the elevator did not provide the same amount of up…NTSB CHI85LA232Accident · No injuriesLimited investigationFinal reportPiper J-3 · Gaylord, MIThe plt attempt to take the float plane across a lake in wind that was from 270 deg at 20 gusting 40 KTS. Subsequently, the acft capsized & was damaged. In a revised statement, the plt reported that he was 'sailing' (letting the wind blow the acft) across the…NTSB CHI85LA233Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Frankenmuth, MIDuring the approach power was added & the aircraft was observed to bounce after touchdown. The acft entered a left turn & from about 50 ft AGL was observed to collide with the ground in a nose down attitude. The flaps were found in the down position.NTSB CHI85LA222Accident · Minor injuriesLimited investigationFinal reportChadwick Stitts SA-3A · Plymouth, MIThe pilot stated that the takeoff was made at too low an airspeed. The acft continued down the rwy at about 20 ft AGL in a nose high attitude. At the end of the rwy the acft pitched up & nosed over.NTSB CHI85LA224Accident · No injuriesLimited investigationFinal reportStearman E-75 · Lake Odessa, MIUpon landing the aircraft veered to the right. Power & left rudder were applied, however, the aircraft continued to the right. Power was reduced but the aircraft continued to the right. The aircraft nosed over after coming in contact with a soft, plowed…NTSB CHI85LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Marshall, MIThe student became disoriented at one of his check points on a x-county flt. With assistance from fss and approach control he arrived at his destination. The student, however, selected the rwy with a tailwind component & was unable to land after two…NTSB CHI85LA207Accident · No injuriesLimited investigationFinal reportMooney M-20G · Bessemer, MIThe pilot felt he had enough fuel for the planned trip. Prior to reaching his destination the engine lost power & would not restart using either fuel tank. The pilot failed to lower the landing gear prior to landing on a road. The acft struck a utility pole…NTSB CHI85LA206Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · New Hudson, MIThe pilot inadvertently attempted to take off with at least 21 deg. Of flaps. The acft climbed to approximately 30-50 8T. AGL and passed over a hangar on the left side of the runway. Once past the hangar the acft began a rapid descent. Post impact fire…NTSB CHI85LA203Accident · No injuriesLimited investigationFinal reportCessna 140A · Owosso, MIThe plt-in-command allowed the passenger in the right seat, a rated plt, to land the acft. This plt lost directional control during the landing roll & the acft ground looped. During the second ground loop the right main landing gear axle separated from the…NTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.NTSB CHI85LA199Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Troy, MIThe plt stated that his intended destination was the Troy-oakland arpt where he intended to land on rwy 27. However, he inadvertently landed on rwy 27 at the big beaver arpt which was aprx 3 mi away. He was expecting to have 3800 ft of rwy, but the rwy at big…NTSB CHI85LA180Accident · No injuriesLimited investigationFinal reportMitchell Monnett Moni · Athens, MIThe plt of the home-built/powered glider initiated a touch-&-go landing. However, he did not retract the spoilers when he began the takeoff portion of the touch-&-go. The acft lifted off into ground effect, but the left wing contacted a rwy light at the…NTSB DCA85IA019Incident · Minor injuriesIncident investigationFinal reportBoeing 747-123 · Detroit, MIThe flt crewmembers of the jumbo jet were preparing to start the engs when flt attendants (f/a's) in the forward cabin detected a faint odor prior to closing door 1L. The source could not be determined, so the door was closed in preparation for a pushback.…NTSB CHI85MA169Accident · 7 fatalMajor investigationFinal reportCessna 310R · St James, MIDuring a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he…NTSB CHI85LA168Accident · No injuriesLimited investigationFinal reportWheat Pitts S-1-S · Marlette, MI100 Yards from end of rwy on final apch plt lost rudder control. During landing roll as airspeed and aileron control effectiveness decreased the acft veered off the side of the rwy. The lower left wing contacted a VASI light. Inspection revealed right side…NTSB CHI85LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Port Huron, MIAfter a practice instrument apch, the plt (PIC) entered the traffic pattern to land on rwy 23. While in the pattern, theair became very turbulent. UNICOM reported the wind was from 270 deg at 20 gusting 35 KTS. On final apch with the flaps fully extended, the…NTSB CHI85FA156Accident · 3 fatalField investigationFinal reportCessna 172N · White Cloud, MIAt about 0250 EST, control tower psnl at the grand rapids arpt heard a 'mayday' call from N23TC, but when they tried to communicate with the acft, there was no response. The call was repeated svrl times. A check at the local arpt revealed there was an acft…NTSB CHI85LA151Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Grand Rapids, MIThe 14 CFR 135 pilot with light load of cargo was taking offof 10000 x 150 ft runway pilot said rt engine lost power he reduced power to ld was 50 ft AGL and bounced on second touchdown acft dept runway at 45 angle nose gear broke off in sod wind was 30 off…NTSB CHI85LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Brighton, MIWhile attempting to execute a go-around with a 90 degree crosswind, velocity 16 kmph, gusting to 28 kmph, the acft apparently stalled just after becoming airborne. It impacted the ground about 300 feet west of the rwy. Witnesses stated that the acft appeared…NTSB CHI85LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Traverse City, MIAccording to the plt, no icing pireps or sigmets were received during his preflt wx briefing. However, the NWS briefer stated that he told him of one PIREP & one SIGMET concerning icing that affected his proposed route of flt. En route to his destination, the…NTSB CHI85FA120Accident · 2 fatalField investigationFinal reportPiper PA-31T · Utica, MIThe pilot attempted a VOR approach and missed. He advised ATC he was going to attempt the NDB & if he could not see the rwy he would go to metro at detroit or pontiac. On the NDB approach the aircraft struck trees 960 ft below the moa. The aircraft flipped…NTSB CHI85LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pontiac, MIThe acft nosed over after a loss of control during landing roll portion of a touch & go lndg. The low flt time student plt was practicing endings solo when control was lost and the acft left the rwy. The plt reported that he was resetting the carb heat &…NTSB CHI85LA115Accident · No injuriesLimited investigationFinal reportMasselink XTC · Hastings, MIThe acft lost power shortly after takeoff on its maiden flt at 600 ft AGL. The plt turned for home but was forced to land in trees short of the arpt. Inspection of the home-built acft, built by the plt, revealed that the choke cable had slipped out of…NTSB CHI85LA112Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pontiac, MIThe acft slid into a snowbank at the end of a lndg roll on an icy rwy with a x-wind. The plt said that he did not use brakes because of the icy condition of the rwy. The x-wind weathervaned the acft to the left and into the snow alongside the rwy.NTSB CHI85LA102Accident · No injuriesLimited investigationFinal reportCessna 421C · Bay City, MIThe acft colloded with a snowbank during lndg. The plt & passg stated that a lndg gear cught in snow piled at an intersection from plowing. The induced drag veered the acft off the rwy to the left.NTSB CHI85LA098Accident · No injuriesLimited investigationFinal reportCessna 140A · Three Rivers, MIThe ski equipped aircraft was taxiing on the frozen surface of the lake when the two bottom bolts that attached the right ski to the gear leg failed the overload failed the two top bolts and the ski failed out and up at a forty five degree angle this…NTSB CHI85LA089Accident · No injuriesLimited investigationFinal reportBeech 58P · Grand Rapids, MIAt 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation…NTSB CHI85LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Troy, MIThe acft collided with a sign during a forced lndg after a loss of power that occurd during initial climb at an alt of 400 ft AGL. The plt stated that the eng began to run rough and with the application of carb heat the eng quit. A post accident eng run-up…NTSB CHI85LA080Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Kalamazoo, MIThe plt reported upon touchdown, the acft contacted a patch of ice causing it to slide sideways resulting in a left main gear collapse. ATC twr witnesses stated the acft appeared fast on final and a hard landing was made.NTSB CHI85LA077Accident · No injuriesLimited investigationFinal reportCessna 402C · Troy, MIThe acft collided with trees during the initial takeoff climb from rwy 27 at oakland-Troy airport, Troy,MI, while on a corporate flt. Investigation revealed that approx 3 to 5 inches of snow had fallen at the arpt during the day & the snow had not been…NTSB CHI85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ypsilanti, MIThe acft collided with a fence & two parked cars during a forced landing while on a personal flt. The plt reported that after a 40 to 50 min ground delay he made a normal climb to 5000 ft MSL where he trimmed the acft & leaned the mixture to 75 percent power.…NTSB CHI85LA082Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Flint, MIDuring a flt in IFR conditions the acft encountered icing. The ice was still on the wings and tail when the acft prepared to land. Extra airspeed was carried on final approach. The acft ballooned as it flared for touchdown. It then stalled and made a hard…NTSB CHI85LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe plt reported a loss of power while in the traffic pattern. During his manuvering to position the acft for landing, the acft stalled & impacted in a field. Investigation did not reveal any fuel/eng malfunction that would have contributed to the accident.NTSB CHI85FA072Accident · No injuriesField investigationFinal reportBeech B-18S · Bellesville, MIThe plt stated that just after lift off the acft veered to the left going off the rwy striking the ground. Investigationrevealed that the plt in the left seat was receiving training & both plts were at the controls. The acft eng & airframe were inspected &…NTSB CHI85FA070Accident · 2 fatalField investigationFinal reportPiper PA-31 · Pontiac, MIThe aircraft departed the airport with one dry air pump inoperative and the other pump reading low. Aircraft control was lost during an instrument approach in IMC approximately 2.5 hours later. Both pump driveshafts were found sheared in the wreckage and both…NTSB CHI85LA060Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Allegan, MIThe plt stated he lost power on takeoff, but elected to takeoff rather than abort. He cleared wires but decided he could not clear trees & made a forced landing in a corn field. Inspection of the acft revealed that the fuel control rod cotter pin was…NTSB CHI85FA059Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Wixom, MIThe acft collided with power lines while on final approach for a landing. The passenger related that the sun was very low on the horizon, and while looking toward the sun & haze, the visibility was limited. As the acft turned on final approach, a large flock…NTSB CHI85LA094Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe plt stated that a slight rudder pedal misalignment caused the acft to run off the rwy & into a ditch during the takeoff roll. He stated that during the first part of the takeoff roll the rudder 'did not respond normally or as expected.' A later…NTSB CHI85FA050Accident · 2 fatalField investigationFinal reportNorth American P-51D · New Haven, MIThe acft, a North American P51D, crashed into a potato field after striking an electrical wire running at a rt angle to the ground track, struck the ground, a building & disintegrated. The plt & owner of the acft was a 50 yr old ex-naval aviator with…NTSB CHI85LA028Accident · Serious injuriesLimited investigationFinal reportSwift GC-1A · Fraser, MIAccording to the plt, he took off on rwy 18 & was climbing thru about 250 ft AGL when the eng lost power & he made a forced landing. However, a co-owner, who was on board, stated that the plt had retarded the throttle, then the acft stopped stopped climbing,…NTSB CHI85LA029Accident · No injuriesLimited investigationFinal reportLight Aero Avid Flyer 1 · Allegan, MIPlt stated he noted a momentary flutter in the right flaperon while in cruise at 80 KTS. He then heard a bang and looking at right wing, observed at least two of the outboard flaperon hinge attachments had broken. The acft then entered a 30-degree right bank…NTSB CHI85LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tecunseh, MIWhile on an aerial application flight, the plt noted a change in engine sound and a slight power loss. During turn to return to the airstrip for precautionary lndg, complete power loss occurred. A forced landing was executed in soft terrain. On lndg roll, the…NTSB CHI85LA026Accident · No injuriesLimited investigationFinal reportBeech G-18S · Belleville, MIAfter reaching 75 KTS on takeoff roll, the acft ground looped to the left, shearing the main landing gear in side overload. Plt stated left gear seemed to be dragging. Investigation revealed no evidence of pre-existing brake/wheel malfunction or failure.NTSB CHI85LA018Accident · No injuriesLimited investigationFinal reportHughes 500 · Grosse Ile, MIPlt attempted to start helicopter with main rotor blades tied down.NTSB CHI85LA017Accident · No injuriesLimited investigationFinal reportCrosetti Glasair - TD · Ypsilanti, MIThe acft had just returned from a flt. Engine run-up and pre-flt checks were normal. On initial climb, eng lost pwr to extent continued flight was not possible. Plt executed forced landing in an open field. Inspection revealed a bird feather lodged against…NTSB CHI85FA005Accident · 1 fatalField investigationFinal reportCessna 310C · Allegan, MIThe non inst non multi-eng rated pvt plt/owner occupied the rt seat & employed the CFI for ferrying the newly purchased acft. From the start, the flt experienced comm difficulties & a compass system malfunction problem. ARTCC transcripts reveal that ATC was…NTSB CHI85FA004Accident · 1 fatalField investigationFinal reportKallansrud/Pitts S-1C · Overisel, MIMishap acft, in company with another acft of same make/model, made preplanned passes over locale of residence prior to departure for short cross-country. After several circles at 500 ft AGL, mishap plt broke out of loose formation into shallow dive; other plt…NTSB CHI85LA011Accident · No injuriesLimited investigationFinal reportMooney M20A · Tecumseh, MIUpon touchdown the landing gear collapsed. Inspection revealed the landing gear actuator handle was cracked aprx 1/2 inch above the actuator torque tube. The crack was through 3/4 of the circumference and there was a 10 deg bend in the tube near the crack.…NTSB CHI85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150F · West Branch, MIThe plt reported that when he arrived at night, he was unable to activate the rwy lights, but decided to land anyway. He touched down long on the 3700 ft rwy & was unable to stop on the remaining area. The acft continued off the end & hit a ditch where the…NTSB CHI84LA409Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIAccording to the CFI the glider was at about 500 ft AGL on base leg when a downdraft caused the acft to descend and touch down 50 ft short of the rwy.