NTSB investigations, MI
69 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 9 |
| 1991 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 CHI07CA225Accident · Serious injuriesData collectionFinal reportRyan ST3KR · Coldwater, MIThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/mush condition. A contributing factor was the low altitude at the time of the inadvertent stall.NTSB CHI06CA217Accident · No injuriesData collectionFinal reportVeltman CH701 · Owosso, MIThe pilot's inadequate preflight planning and inadequate compensation for the tailwind condition. Factors included the tailwind and the power lines.NTSB CHI05CA239Accident · No injuriesData collectionFinal reportBeech 36 · Holland, MIThe failure of the pilot to extend the landing gear prior to landing. A factor to the accident was the pilot becoming distracted by his passengers during landing.NTSB CHI05CA175Accident · No injuriesData collectionFinal reportCessna A185F · Elk Lake, MIThe gear retraction not performed by the pilot.NTSB CHI05CA120Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Lakeview, MIThe dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.NTSB CHI04LA015Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Fenton, MIThe intentional low altitude flight maneuvering and the ostentatious display by the pilot. The water was a factor to the accident.NTSB CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.NTSB CHI02FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Foster City, MIThe incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.NTSB CHI02LA121Accident · 2 fatalLimited investigationFinal reportYoder GP-4 · Mount Pleasant, MIThe inadvertent stall/spin by the pilot-in-command.NTSB CHI02LA057Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lake Leelanau, MIThe improper planning/decision in runway selection. The soft runway condition and wet snow were contributing factors.NTSB CHI02LA021Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lambertville, MIThe pilot's improper flare during landing.NTSB CHI02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lapeer, MIthe touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.NTSB CHI01LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Huron, MIThe pilot not maintaing a proper glide path during the simulated forced landing. Factors were flight instructor's inadequate supervision and the wind gusts.NTSB CHI01LA075Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Dryden, MIThe pilots failure to maintain altitude/clearance from the terrain. The dark night was a factor.NTSB CHI00LA310Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Petersburg, MIthe pilots failure to abort the takeoff and obtain/maintain clearance from the corn crop. Factors were the tall, wet, grass runway, and the corn crop.NTSB CHI00LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Near Muskegon, MIthe pilot failed to maintain altitude after inadvertently flying to instrument meteorological conditions. Factors associated with the accident were the low ceilings and visibility, the pilot became disoriented after inadvertently flying into IMC, and the…NTSB CHI99LA249Accident · No injuriesLimited investigationFinal reportCessna 152 · Berrien Springs, MIFailure to obtain a proper climb rate and the delayed remedial action by the certified flight instructor. Contributing factors were the uphill terrain and trees.NTSB CHI99FA227Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · St. Clair Shore, MIUndetermined as the aircraft was not recovered.NTSB CHI97LA234Accident · Minor injuriesLimited investigationFinal reportRutan Defiant · Alma, MIthe pilot did not perform an adequate preflight check and he did not perform the takeoff checklist. Factors included the pilot's inadequate design of the safety latch and the canopy inadvertently deploying.NTSB CHI96LA234Accident · No injuriesLimited investigationFinal reportCessna 172L · Vicksburg, MIthe pilot's premature raising of the flaps during a go-around. The presence of birds was a factor.NTSB CHI96LA115Accident · 1 fatalLimited investigationFinal reportCessna 182H · East Jordan, MIthe pilot's failure to maintain clearance with the terrain during the landing. Factors related to the accident were the snow covered ice pile at the end of the runway and the pilot's perception of the height of the pile.NTSB CHI95LA135Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Napoleon, MIthe pilot's failure to retract the wing flaps prior to takeoff and the subsequent failure of the airplane to climb during takeoff.NTSB CHI94LA226Accident · 2 fatalLimited investigationFinal reportCessna T210M · Beaver Island, MISpatial disorientation of the pilot-in-command due to flight into known instrument meteorological conditions; factors in the accident were the fog and low ceiling.NTSB CHI93LA279Accident · No injuriesLimited investigationFinal reportCessna 150M · Bridgman, MIthe pilot's premature lift-off.NTSB CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..NTSB CHI91LA207Accident · No injuriesLimited investigationFinal reportHughes 300C · Whitehall, MIThe pilot's failure to maintain adequate clearance from the water. A factor was the dark night light condition.NTSB CHI91LA204Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Dexter, MIThe pilot's delay in aborting the landing. A factor in the accident was his excessive speed on final approach.NTSB CHI90DEM09Accident · 1 fatalFinal reportComben Bowers Flybaby IA · Cheboygan, MIUndetermined.NTSB CHI90LA225Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Mottville, MIThe pilot's failure to maintain a proper decent rate during landing and his decision to initiate the flight in high winds conditions.NTSB CHI90FA239Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Clark Lake, MIPoor judgement of the pilot due to consumption of alcohol, and his failure to maintain proper altitude and clearance above water, while performing aerobatic maneuvers.NTSB CHI90FA235Accident · 1 fatalField investigationFinal reportCessna 180 · Howell, MIThe pilot's failure to maintain adequate clearance above terrain while maneuvering during takeoff. A factor in the accident was the pilot's attempt to display the aircraft's performance.NTSB CHI90DEM08Accident · 2 fatalFinal reportCessna 150L · Holland, MIUndetermined. Factors related to the accident were: darkness & impairment of the pilot due to carbon monoxide.NTSB CHI90DEM07Accident · 1 fatalFinal reportPitts SA-1 · East Jordan, MIThe pilot-in-command's failure to maintain altitude during low altitude aerobatics.NTSB CHI90DEM04Accident · 1 fatalFinal reportVanek 300 · Vriesland, MIThe pilot's misjudgment of the altitude. A factor related to the accident was the low ceiling.NTSB CHI90LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Bad Axe, MIFailure of the pilot to abort the takeoff with sufficient runway to stop the aircraft. Contributing to the accident is a lack of total flying experience.NTSB CHI90DEC01Accident · 2 fatalFinal reportMoore Acroduster II SA750 · New Haven, MIThe pilot's the improper execution and/or recovery from an aerobatic maneuver (inverted flat spin), which resulted in a collision with the terrain.NTSB CHI90LA011Accident · 1 fatalLimited investigationFinal reportCessna 152 · Hillsdale, MIPoor judgement of the student pilot by not following his flight instructor's directions on his first supervised solo flight and by not maintaining a safe altitude, which resulted in a collision with the terrain. Related factors were: unauthorized low flight…NTSB CHI89LA185Accident · No injuriesLimited investigationFinal reportCessna C172R · Frankenmuth, MIThe pilot's failure to maintain control of the aircraft during takeoff as a result of a diversion of attention due to a possible engine problem.NTSB CHI89LA126Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Sebewaing, MIPilot's inattentive aircraft handling which resulted in his failure to detect and prevent the aircraft's descent into the wheat field.NTSB CHI89FA061Accident · 1 fatalField investigationFinal reportCessna 150M · Corunna, MIThe failure of the student pilot to maintain sufficient altitude to recover from a practice stall maneuver. A factor related to the accident was: the pilot's visual perception over snow covered terrain.NTSB CHI88LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Plainwell, MIDuring an unauthorized flight of unknown duration, by person(s) unknown, aircraft control was not maintained. The aircraft was observed by a witness to 'wobble' as it approached the runway. The witness then saw the aircraft 'crash' into the grass at the left…NTSB CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…NTSB CHI87DEM09Accident · 2 fatalFinal reportNorth American P-51D · Ludington, MIN3278D was #1 (leader) in a flt of 2 North American P-51 acft. The plt of the 2nd P-51 rprtd that they were on a southerly heading over water about 1/2 mi from the shore when the leader raised his nose & began rolling to the right. Witnesses on the beach…NTSB CHI86FEC07Accident · No injuriesFinal reportPiper PA-36-285 · Imlay City, MIThe pilot stated that takeoff acceleration did not seem normal. He rotated approx 5 mph early and could not climb out. He delayed emergency dumping of the load of insecticide until clearing a drainage ditch. He stated that if he would have dumped at the end…NTSB CHI86FA218Accident · Minor injuriesField investigationFinal reportLearjet 24 · Ypsilanti, MICrew attempted ILS approach with indefinite ceiling and RVR=o in fog. Co-pilot at controls. During missed approach, acft contacted runway where glideslope intersects terrain with sufficient force to shear all three landing gear. Right engine spolled down…NTSB CHI86LA187Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Charlevoix, MIAccording to the pilot,on their first approach they were unable to see the airport at 1300 feet, so they raised the gear and flaps and climbed to 1800 feet, at which time they saw the airport. The pilot decided to make a VFR landing on runway 26 and forgot…NTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…NTSB CHI85FA284Accident · 1 fatalField investigationFinal reportEipper MX Super · Almont, MIWitnesses reported the acft was in an inverted flight aprx 60 to 70 ft AGL before it entered a split 's' maneuver and descended to ground impact. The plt was performing aerobatics in an airshow when the accident occurred. The plt's aerobatic waiver had…NTSB CHI85LA246Accident · Minor injuriesLimited investigationFinal reportAnderson Skybolt · Escanaba, MIPrior to the acdnt, the acft was observed making repeated low passes over the area where it subsequently crashed. Witnesses reported that during a turning maneuver over water, the acft collided with the surface & crashed. A police officer, who responded,…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…