Skip to content

NTSB investigations, MI

24 cases where the first occurrence was “Undershoot”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

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' 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" = 390) 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'
    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\" = 390)
  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" = 390)
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 CHI01LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe CFI's delay in iniating remedial action to arrest the sink rate which developed on final approach. Factors associated with the accident were the student pilot failed to maintain a proper glidepath on final approach and the snow bank which the airplane…Jan 20, 2001 · N714UA · Substantial damage NTSB CHI01LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Allegan, MIThe proper glide path not maintained by the pilot. A factor to the accident was the deep snow.Dec 31, 2000 · N63276 · Substantial damage NTSB CHI00LA193Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Manchester, MIthe downdraft experienced during final approach and altitude/clearance from the fence post not being maintained by the pilot. A factor to the accident was the fence post.Jul 1, 2000 · N885D · Substantial damage NTSB CHI98LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer FGS-233 · Ionia, MIthe pilot misjudged the landing approach which resulted in his failure to attain a proper touchdown point. A factor was the trees.Oct 12, 1997 · N5762S · Substantial damage NTSB CHI95LA013Accident · No injuriesLimited investigationFinal reportLearjet 23 · Holland, MIThe copilot's misjudgment of the touchdown point, and the pilot in command's inadequate supervision to avoid the accident.Oct 14, 1994 · N20TA · Substantial damage 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 CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.Jun 10, 1992 · N80490 · Substantial damage NTSB CHI92LA097Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Alpena, MIThe student pilot's failure to attain the proper touchdown point. Related factors are his misjudged approach and failure to take remedial action.Feb 21, 1992 · N1405K · Substantial damage NTSB CHI92LA029Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Howell, MIProper glidepath was not maintained resulting in an undershoot. A factor related to the accident was dark night flying conditions.Nov 17, 1991 · N73475 · Substantial damage NTSB CHI90LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Acme, MIThe student pilot misjudged distance and altitude to the runway, and the instructor pilot (CFI) failed to attain remedial action, which resulted in their failure to attain the proper touchdown point. Factors related to the accident were: the cfi's lack of…Jan 20, 1990 · N34860 · Substantial damage NTSB CHI89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172I · New Era, MIThe pilot's misjudgement of the proper touchdown point.Jun 12, 1989 · N35561 · Substantial damage NTSB CHI88LA058Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIFeb 4, 1988 · N383SP · Substantial damage NTSB CHI86LA208Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIAccording to the plt, at approximately 20 miles south of Ionia county airport, Ionia, Michigan, he used frontal zone lift to climb to 4600 MSL (3800 AGL), and he encountered no further lift. The plt stated that he anticipated an increase in wind gradient…Aug 17, 1986 · N12GH · Substantial damage 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.Sep 29, 1984 · N14420 · Substantial damage NTSB CHI84LA392Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Rapids, MIIn an effort to land at the threshold the acft collided with a fence and landed short of the prepared surface. Runway edge lights were operating but runway end identifier lights were not installed.Sep 16, 1984 · N98017 · Substantial damage NTSB CHI84LA202Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ortonville, MIThe acft landed hard short of the rwy, bounced, & both landing gear collapsed.May 19, 1984 · N455C · Substantial damage NTSB CHI83LA248Accident · No injuriesLimited investigationFinal reportHelio H-391B · Croton, MIThe acft collided with wires on an approach to a lake.Jun 5, 1983 · N4119D · Substantial damage NTSB CHI83LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, MIWhile on a local sight-seeing flt, the plt elected to land at mt Pleasant, MI for lunch. A low pass was made over rwy 09. The plt reported that while he was on a second approach to land, the acft encountered wind gusts and a loss of altitude. The plane's…Apr 24, 1983 · N6155K · Substantial damage NTSB CHI83LA159Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fraser, MIThe aircraft stalled and undershot the runway landing about 100 feet short, where it collided with a ditch and nosed over. The pilot and his wife aboard the aircraft were not injured. The aircraft landed on runway 09 and the wind was from 110 degrees at 15…Apr 1, 1983 · N1517R · Substantial damage NTSB CHI83LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Three Oaks, MIThe instructor (CFI) & his student had started flying at aprx 1900 EST. The purpose was to give the student aprx 3 hrs of night instruction. A refueling stop was made at south bend, IN. According to the student, the CFI stayed in the acft during the…Feb 21, 1983 · N704RX · Substantial damage NTSB CHI82FA326Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Athens, MIThe acft was landing on rwy 27 which has a 350 ft displaced threshold due to 24 ft high power lines on the approach. A witness stated the plt was low & narrowly missed the wires on the first touch & go. During the second approach the plt was noticeably lower…Aug 24, 1982 · N2928H · Destroyed NTSB CHI82DA120Accident · No injuriesFinal reportPiper PA-34 · Gaylord, MIDuring a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank.Apr 14, 1982 · N8691E · Substantial damage NTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…Feb 27, 1982 · N47559 · Substantial damage NTSB CHI82DA020Accident · No injuriesFinal reportCessna 150L · Charlotte, MIAfter returning to the airport, the pilot used full flaps during a crosswind landing. The wind was from 090 degrees, gusting 20 to 25 knots. The pilot stated that he added power when the aircraft stalled at about 10 ft AGL. The plane touched down in snow…Jan 2, 1982 · N1549Q · Substantial damage