Skip to content

NTSB investigations, MI

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 CHI94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Allendale, MIImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.Oct 6, 1993 · N8339C · Substantial damage NTSB CHI94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Frankfort, MIthe pilot's failure to perform refueling.Oct 5, 1993 · N6862Z · Substantial damage NTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…Oct 3, 1993 · N5522G · Substantial damage NTSB CHI94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Monroe, MIThe pilot's inadequate preflight planning/preparation, when he misjudged the (inadequate) supply of fuel before takeoff, which resulted in fuel exhaustion. Soft terrain in the emergency landing area was a related factor.Oct 2, 1993 · N2759S · Substantial damage NTSB CHI94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cheboygan, MIInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to and inadequate supply of fuel. Factors related to the accident were: the lack of suitable terrain for a forced landing, and trees in the emergency landing area.Oct 2, 1993 · N5695U · Destroyed NTSB CHI93FA378Accident · 2 fatalField investigationFinal reportAero Commander 690A · Lansing, MIwas the pilot-in-command not maintaining aircraft control during the intermittent operation of the electrically operated attitude gyro. Factor's associated with this accident are an fluctuating (intermittent) electrical system inverter and the…Sep 27, 1993 · N242TC · Destroyed NTSB CHI93LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Davison, MIImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.Sep 10, 1993 · N38602 · Substantial damage NTSB CHI93LA337Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Saint James, MIImproper planning/decision by the pilot. Factors related to the accident were: the unfavorable wind, and high obstructions near the end of the runway.Aug 24, 1993 · N479CB · Substantial damage NTSB CHI93LA336Accident · No injuriesLimited investigationFinal reportCessna 172M · Adrian, MIan excessive taxi speed used by the pilot-in-command. A factor related to the accident was loose gravel on the ramp and inadequate airport maintenance by the airport personnel.Aug 22, 1993 · N13923 · Substantial damage NTSB CHI93DEM02Accident · Minor injuriesFinal reportSheats FALCON-XP · Zeeland, MIan inadequate maintenance inspection by the pilot/owner and the separation of the wing skin.Aug 22, 1993 · N534AA · Substantial damage NTSB CHI93DEC01Accident · Minor injuriesFinal reportBradford Pietenpol Skyscout · Eaton Rapids, MIthe pilot's failure to maintain airspeed which resulted in an inadvertant stall. Factors related to the accident were the low altitude and the restricted movement of the carburetor needle.Aug 21, 1993 · N4301D · Substantial damage NTSB CHI93LA321Accident · No injuriesLimited investigationFinal reportR.D. Bell/Pietenpol Aircamper · Pontiac, MIThe pilot in command not maintaining a proper descent rate during the final approach and landing flare phase of flight.Aug 12, 1993 · N194BB · Substantial damage NTSB CHI93LA308Accident · No injuriesLimited investigationFinal reportBeech 19A · Ludington, MIthe pilot's misjudged landing flare.Aug 6, 1993 · N5072T · Substantial damage NTSB CHI93LA301Accident · 1 fatalLimited investigationFinal reportCessna 180 · Naubinway, MIThe pilot's improper flare for landing. Factors associated with the accident are the low clouds and fog, the rough water at the landing site, and the pilot's continued flight into known adverse weather.Aug 1, 1993 · CFPTU · Substantial damage NTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.Jul 28, 1993 · N4518S · Destroyed NTSB CHI93LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Troy, MIIs the pilot not attaining the proper touchdown point, not flying a proper glidepath, and not performing a go around.Jul 28, 1993 · N40023 · Substantial damage NTSB CHI93LA286Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Birmingham, MIAn improper grade of fuel was loaded into the airplane by the owner/operator of the rental airplane, improper planning and/or decision by the pilot, and subsequent vapor lock in the fuel system of the airplane (fuel system - other), which resulted in fuel…Jul 26, 1993 · N1976W · Substantial damage NTSB CHI93LA279Accident · No injuriesLimited investigationFinal reportCessna 150M · Bridgman, MIthe pilot's premature lift-off.Jul 24, 1993 · N66155 · Substantial damage NTSB CHI93LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sparta, MIthe separation of the rear landing light gasket into the air induction path.Jul 24, 1993 · N95478 · Substantial damage NTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.Jul 23, 1993 · N9307N · Substantial damage NTSB CHI93LA271Accident · No injuriesLimited investigationFinal reportBeech A36 · Fowlerville, MIThe pilot-in-command's (CFI) delay in aborting the takeoff.Jul 22, 1993 · N211BB · Substantial damage NTSB CHI93LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe student pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.Jul 22, 1993 · N64988 · Substantial damage NTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.Jul 21, 1993 · N91705 · Substantial damage NTSB CHI93LA259Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Vassar, MIThe pilot's inadequate compensation for the crosswind.Jul 15, 1993 · N2695Z · Substantial damage NTSB CHI93LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Senter, MIThe pilot-in-command's inadequate pre-flight planning. Factors relating to this accident are fuel exhaustion, unsuitable terrain on which to make an emergency landing, as well as an inadvertent stall.Jul 10, 1993 · N1630H · Substantial damage NTSB CHI93IA248Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Detroit, MIthe failure of a navigation system (#1 INS) for reason or reasons undetermined.Jul 10, 1993 · N158US · No damage NTSB CHI93FA247Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Houghton, MIThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall/mush. Intentional buzzing was a factor.Jul 9, 1993 · N6279A · Destroyed NTSB CHI93FA234Accident · 1 fatalField investigationFinal reportCessna 210D · Salem, MIthe pilot's physical impairment.Jun 28, 1993 · N3899Y · Destroyed NTSB CHI93LA230Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Ionia, MIThe pilot in command's failure to maintain the proper glidepath.Jun 26, 1993 · N4101M · Substantial damage NTSB CHI93FA225Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elwell, MIImproper use of the fuel selector by the pilot, which resulted in fuel starvation.Jun 26, 1993 · N7779P · Substantial damage NTSB CHI93LA207Accident · No injuriesLimited investigationFinal reportRobert L. Kennedy Avid Flyer · White Pigeon, MIThe pilot in command's inability to attain proper touch down point. The improperly adjusted idle setting which resulted in the loss of engine power was also a cause.Jun 13, 1993 · N138RK · Substantial damage NTSB CHI93LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · St. James, MIThe pilot landed too long on a wet runway.Jun 8, 1993 · N73630 · Substantial damage NTSB CHI93FA193Accident · 1 fatalField investigationFinal reportBeech E18S · Ypsilanti, MIThe pilot-in-command's inadequate preflight preparation, false indication (on/off) of attitude indicator, and attitude indicator switched off. Factors were fog, low ceiling, the pilot-in-command's improper use of the attitude indicator, and his lack of total…Jun 8, 1993 · N51FG · Destroyed NTSB CHI93DEM01Accident · No injuriesFinal reportAmato Corben JR. ACE · Traverse City, MIinadequate lubrication of the tailwheel bearings and inadequate preflight by the pilot/owner which resulted in a seized tailwheel.Jun 3, 1993 · N17BA · Substantial damage NTSB CHI93LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Plainwell, MIThe pilot-in-command's initiating hand starting of the airplane unattended by a qualified person.May 16, 1993 · N8657B · Substantial damage NTSB CHI93LA174Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Springport, MIA partial loss of engine power for undetermined reasons.May 16, 1993 · N35HM · Substantial damage NTSB CHI93FA171Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hubbardston, MIThe pilot's failure to maintain airspeed due to alcohol impairment while maneuvering at low altitude.May 14, 1993 · N4563R · Destroyed NTSB CHI93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Houghton Lake, MIThe pilot operating the airplane with a known deficiency.May 9, 1993 · N7303M · Destroyed NTSB CHI93LA160Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Muskegon, MIThe pilot-in-command's misjudging the flare.May 5, 1993 · N254AT · Substantial damage NTSB CHI93LA145Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Port Huron, MIfailure of the landing gear actuator cable.Apr 22, 1993 · N654N · Substantial damage NTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.Mar 30, 1993 · N7732K · Substantial damage NTSB CHI93LA123Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Topinabee, MIthe total loss of engine power due to failure of the oil line to the oil pressure gauge. A factor relating to the accident was no suitable terrain on which to make a forced landing.Mar 28, 1993 · N4017X · Substantial damage NTSB CHI93FA118Accident · 1 fatalField investigationFinal reportCessna 182N · Ludington, MIthe pilot's improper instrument procedures. Related factors are the below approach minima weather conditions, fog and dark night.Mar 26, 1993 · N8945G · Destroyed NTSB CHI93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mason, MIThe pilot-in-command's failure to maintain directional control.Mar 17, 1993 · N2440T · Substantial damage NTSB CHI93FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Grand Haven, MIundetermined.Mar 15, 1993 · N15206 · Destroyed NTSB CHI93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIThe student pilot's failure to maintain directional control during the takeoff roll.Mar 7, 1993 · N67475 · Substantial damage NTSB CHI93LA105Accident · No injuriesLimited investigationFinal reportCessna 172M · Romeo, MIThe pilot's failure to maintain directional control.Mar 6, 1993 · N20043 · Substantial damage NTSB CHI93LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Manistique, MIAn excessive taxi speed.Mar 2, 1993 · N8275L · Substantial damage NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.Feb 25, 1993 · N46460 · Substantial damage NTSB CHI93LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Canton, MIThe student pilot's failure to maintain directional control.Feb 25, 1993 · N9297U · Substantial damage