NTSB investigations, MI
36 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 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\" = 320)
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" = 320) 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 CHI08CA058Accident · No injuriesData collectionFinal reportCessna 172F · Crystal Falls, MIThe rough, unsuitable terrain encountered during the landing which resulted in the total failure of the nose landing gear.NTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.NTSB CHI03LA194Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Roscommon, MIThe pilot's failure to maintain aircraft control during a water landing. A factor contributing to the accident was the rough water.NTSB CHI03LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe student pilot failed to maintain directional control during landing roll. Additional factors include the student pilot's lack of total flight experience, the CFI's inadequate supervision, and the ice and snow on the runway.NTSB CHI02CA202Accident · Minor injuriesData collectionFinal reportEckstein RV-6A · Mattawan, MIFailure by the pilot in command to attain a proper touchdown point considering the available runway length. The rough, uneven runway surface and the soft area at the far end of the runway were contributing factors.NTSB CHI02CA191Accident · No injuriesData collectionFinal reportCessna 150H · Mecosta, MIThe airplane encountered unsuitable terrain and the pilot applied excessive braking during the aborted takeoff. A factor contributing to the accident was the sandy terrain.NTSB CHI02CA184Accident · No injuriesData collectionFinal reportPiper PA-34 · Lowell, MIThe probable cause of this accident was a failure to properly compensate for the current wind conditions. Excessive use of brakes was a contributing factor.NTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.NTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB CHI00LA155Accident · No injuriesLimited investigationFinal reportEdgerly S-12 · Hartford, MIrestricted directional control. Factors relating to this accident were the rough, uneven runway, and the trees.NTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.NTSB CHI99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hancock, MIthe pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…NTSB CHI98LA345Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Grosse Ile, MIthe pilot in command (CFI)'s diverted attention and his failure to select landing gear extension.NTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.NTSB CHI96LA058Accident · No injuriesLimited investigationFinal reportCessna 150B · Grant, MIthe pilot's selection of unsuitable terrain and the weak ice-covered runway.NTSB CHI93LA160Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Muskegon, MIThe pilot-in-command's misjudging the flare.NTSB CHI92LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, MIThe pilot's inadequate planning and decision-making.NTSB CHI92LA242Accident · No injuriesLimited investigationFinal reportCessna 182R · Litchfield, MIThe pilot-in-command's failure to use all available runway and his not aborting the takeoff when the wing contacted the corn. A factor was the corn along side the runway.NTSB CHI92LA076Accident · No injuriesLimited investigationFinal reportCessna 414 · Gaylord, MIDirectional control was not maintained by the pilot. Factors related to the accident were: airport snow removal had not been performed by the airport personnel, a dark night with falling snow and the snowbank on the runway.NTSB CHI89LA108Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cedar, MIPilot in command attempting to land with too high an aispeed and with insufficient runway remaining to allow either a go around or the ability to bring the airplane to a stop in the space remaining.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.NTSB CHI88DEM10Accident · No injuriesFinal reportGrumman G-164B · Schoolcraft, MIThe pilot failed to maintain directional control while maneuvering the aircraft to avoid an obstacle during the landing roll. The aircraft's right wing impacted a corn crop and the aircraft swerved/ground looped to the right and skidded to a stop, nose down.…NTSB CHI88LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIWhile taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank.NTSB CHI87IA163Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Detroit, MIA northwest airlines Boeing 757, operating as flight 336, scraped the tail cone area of the fuselage on the runway when the pilot failed to maintain sufficient ground clearance during rotation and takeoff from Detroit, Michigan. The Boeing 757 flight…NTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.NTSB CHI87LA077Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bridgman, MIPlt was attempting to takeoff from a soft field. The gear caught a rise in the field and acft settled back to the soft ground tearing off the nose wheel and damaging both wings.NTSB CHI87LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Gaylord, MIThe plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being…NTSB CHI87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Detroit, MIUpon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…NTSB CHI84LA407Accident · No injuriesLimited investigationFinal reportCessna 150M · Clio, MIThe airport consists of three sod strips none of which contains rwy lights. The CFI and student departed the arpt for a local night flight. The CFI stated that upon returning to the arpt he called the arpt office on the UNICOM freq and requested the night…NTSB CHI84LA309Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle · Osseo, MIThe plt stated that the thermals dissipated & he had to make an off arpt landing. The landing was made in a field of tall grass & the left wing contacted the grass first resulting in a 90 deg ground loop. The aft fuselage section separated.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 CHI83LA314Accident · No injuriesLimited investigationFinal reportFlug-Und Fahrzeugwerke Diamant · Frankfort, MIThe plt reported that during a winch tow takeoff the right wing caught in tall grass & soft sand, & the glider ground-looped.NTSB CHI83FA220Accident · Serious injuriesField investigationFinal reportSchaffer-Provencher UW · Stockbridge, MIThe balloon landed downslope at about 7 KTS in a rip/drag landing without ground assistance. One of the two passengers was on the downslope side of the basket facing the direction of landing. She lost her grip on the top rail of the basketduring touchdown and…NTSB CHI83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrisville, MIThe plt reported that during a touch-and-go landing on a snow covered rwy, the acft hit a chunk of frozen snow. Reportedly, he had departed from the same rwy & had been making touch-and-go landing, but did not see the obstruction.NTSB CHI82DA297Accident · No injuriesFinal reportLake LA-4-200 · Standard Rock, MIAfter landing on a Lake to fish, the water got rough, so the pilot attempted a takeoff. During the takeoff run, the left float hit a wave and broke off. The takeoff was aborted without further damage.