NTSB investigations, MI
136 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 10 |
| 1986 | 10 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 9 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 8 |
| 1997 | 5 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 10 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 2 |
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\" = 220)
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" = 220) 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 CHI07CA110Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Brighton, MIThe student pilot's failure to maintain proper glidepath to the runway. Contributing factors to the accident included the passenger vehicle, the rising embankment, and the airport perimeter fence.NTSB CHI07CA119Accident · No injuriesData collectionFinal reportJohnson-Whittman Tailwind JW9L · Saginaw, MIThe pilot's failure to maintain the proper glidepath and clearance from a fence while on final approach.NTSB CHI06CA198Accident · Minor injuriesData collectionFinal reportSargent Bushby Mustang II · Troy, MIThe pilot's delayed decision to go-around leading to the impact with the fence during the go-around. A factor was the fence.NTSB CHI06CA203Accident · No injuriesData collectionFinal reportCessna 182 · Napoleon, MIThe pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.NTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB CHI04LA065Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Sturgis, MIThe failure to maintain obstacle clearance during an intentional low altitude maneuver and the ostentatious display by the pilot-in-command. A factor to the accident was the tree.NTSB CHI04LA061Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Prairieville, MIThe pilot's failure to maintain altitude/clearance from the transmission wires during final approach. Factors to the accident were the unmarked transmission wires and their support poles.NTSB CHI04LA047Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58JT · Ypsilanti, MIThe pilot became disoriented and attempted to land the helicopter at the wrong ramp resulting in his failure to maintain obstacle clearance during the approach. The light poles were a factor to the accident.NTSB CHI03LA303Accident · No injuriesLimited investigationFinal reportCessna 172G · Greenville, MIThe pilot's inadequate takeoff procedure with the use of 20 degrees of flaps. Contributing factors were the interrelated effects of high aircraft weight, the density altitude, and the relative humidity. An additional factor was the trees.NTSB CHI03LA282Accident · 1 fatalLimited investigationFinal reportCessna 140 · Edwardsburg, MIThe pilot not maintaining altitude/clearance from the power line during his low level cruise. Factors were the power transmission line, the lake, and low altitude flight.NTSB CHI03LA278Accident · 1 fatalLimited investigationFinal reportAyres S2R-G6 · Breckenridge, MIThe pilot's failure to maintain clearance from the powerlines during the aerial application pass rendering the airplane uncontrollable. The powerlines were a factor.NTSB CHI03LA224Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Highland, MIFailure of the pilot to maintain a proper descent rate. Contributing factors were the pilot's failure to maintain clearance from the trees, the reported high winds and gusts, the trees, the power lines and the house.NTSB CHI03LA205Accident · No injuriesLimited investigationFinal reportCessna 182Q · Empire, MIThe pilot's failure to abort the takeoff. A contributing factor to the accident included the pilot not utilizing all available engine power during the entire takeoff. Additional factors were the improper wing flap setting and the cherry-tree orchard.NTSB CHI03FA149Accident · 1 fatalField investigationFinal reportCessna 172S · Sidnaw, MIThe improper short/soft field landing procedure by the pilot and his lack of recent experience in type of operation. Contributing factors were the short/soft field runway, the trees and his delay in aborting the takeoff.NTSB CHI03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Blaney Park, MIThe pilot's failure to maintain clearance with the tree line. Factors contributing to this accident were the wind gusts and the trees.NTSB CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.NTSB CHI03LA084Accident · No injuriesLimited investigationFinal reportBell 430 · Highland, MIThe pilot's failure to maintain clearance to the roadway sign. Contributing factors were the failure of the tail rotor gearbox, the roadway sign and the low lighting conditions (night).NTSB CHI02FA262Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Newaygo, MIThe altitude/clearance disregarded by the pilot and his ostentatious display. The wire and low altitude flight were a contributing factor.NTSB CHI02LA256Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Coopersville, MIThe pilot's failure to maintain clearance from the transmission wires. Additional factors were the transmission wires and the sunglare.NTSB CHI01LA310Accident · No injuriesLimited investigationFinal reportMooney M20K · Croswell, MIThe pilots failure to abort the takeoff. Factors were the pole and the trees.NTSB CHI01LA269Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Mackinac Island, MIThe pilot's failure to maintain proper glidepath during the landing approach resulting in the pilot not maintaining clearance from the trees. Factors were the haze, the gusty winds, and the trees.NTSB CHI01FA083Accident · 2 fatalField investigationFinal reportSwearingen SA227-AT · Beaver Island, MIThe flightcrew not maintaining altitude/clearance during the circling instrument approach. Factors were the pilot in command initiating the flight without proper weather reporting facilities at the destination, the flightcrew not flying to an alternate…NTSB CHI01FA025Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Gaylord, MIThe pilot not maintaining proper glideslope and localizer alignment during the precision instrument approach, the pilot continuing flight below the decision height, the pilot not performing a missed approach, and the pilot not maintaining altitude/clearance…NTSB CHI01FA024Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Sparta, MIThe pilot's failure to maintain proper runway alignment on departure and his failure to maintain clearance from the trees. The pilot's attempted flight into known adverse weather, his lack of instrument experience, the fog, and the trees were contributing…NTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.NTSB CHI00LA206Accident · 1 fatalLimited investigationFinal reportMead Kolb Firestar II · Gwinn, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the tree and the high density altitude.NTSB CHI00FA139Accident · 1 fatalField investigationFinal reportWsk Pzl Mielec M-18A · Muskegon, MIthe pilot's failure to maintain clearance from the trees. Factors relating to this accident were the low altitude and the trees.NTSB CHI00LA015Accident · Serious injuriesLimited investigationFinal reportWelch Murphy Rebel · Saint Johns, MIthe pilot not maintaining altitude and clearance. Factors were the trees, the flap control not fully engaged, and the pilot's lack of total experience in the kind of airplane flown.NTSB CHI99FA332Accident · 1 fatalField investigationFinal reportPiper PA-12 · Neguanee, MIthe pilot failed to maintain clearance from the tower.NTSB CHI99LA225Accident · No injuriesLimited investigationFinal reportMooney M20J · Harbor Springs, MIthe pilot's inadequate compensation for the wind conditions and his failure to maintain clearance with the trees. Factors associated with the accident were the gusty winds, wind shear, and the trees.NTSB CHI99FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Drummond Island, MIthe altitude/clearance not obtained/maintained and the inadequate planning/decision by the pilot-in-command. The exceeded aircraft performance was an additional cause. The unfavorable wind and trees were contributing factors.NTSB CHI99FA072Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Pellston, MIthe pilot's failure to maintain proper altitude/clearance on the approach and his flight into known icing conditions. Factors relating to this accident were the pilot flying with known equipment deficiencies, the pilot's physical impairment (alcohol), the…NTSB CHI99FA047Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Waterford, MIthe pilot's descent below the decision height for the instrument approach.NTSB CHI99LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · Genesee, MIthe pilot's failure to maintain directional control and the subsequent failure to attain clearance with the trees during takeoff. Factors associated with the accident were the trees, dark night conditions, and fog which resulted in the lack of visual…NTSB CHI99LA001Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Bad Axe, MIThe pilot's failure to maintain adequate altitude/clearance from the wires.NTSB CHI98FA274Accident · 1 fatalField investigationFinal reportCessna 172M · Brooklyn, MIThe proper touchdown point was not attained and the visual lookout not being maintained by the pilot-in-command. Contributing factors to the accident were the unmarked static and transmission wires.NTSB CHI98LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas a delayed go-around maneuver by the pilot. Factors associated with this accident were the pilot misjudging his final approach altitude and glide path, having inadequate altitude to clear the trees at the end of the runway, and inadequate training on how…NTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…NTSB CHI97LA304Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Brooklyn, MIfailure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.NTSB CHI97LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Gregory, MIThe pilot's improper planning/decision. The tailwind and location of trees were related factors.NTSB CHI97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas the pilot not maintaining sufficient altitude to clear obstructions. A factor associated with the accident was the pilot was inattentive to the airplane's altitude.NTSB CHI97LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Flushing, MIthe pilot's misjudgment of distance and speed on final approach, his failure to attain the proper touchdown point for landing, and his delay in initiating a go-around (aborted landing). Factors related to the accident were: darkness, and the proximity of…NTSB CHI97LA019Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-235 · Hubbard Lake, MIthe pilot's inadequate compensation for wind conditions, and failure to maintain proper alignment with the airstreip during the go-around (aborted landing). The crosswind and proximity of trees were related factors.NTSB CHI97LA016Accident · 1 fatalLimited investigationFinal reportHughes 369 · Vestaburg, MIfailure of the pilot to maintain clearance with the wires.NTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.