NTSB investigations, MI
82 cases where the sequence of events included Loss of control on ground.
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN14LA387Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Flushing, MIThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…NTSB CEN14CA335Accident · No injuriesData collectionFinal reportCessna 172M · Holland, MIThe pilot's improper recovery from a bounced landing resulting in a loss of directional control.NTSB CEN14CA237Accident · No injuriesData collectionFinal reportMooney M20F · Dowling, MIThe pilot's failure to maintain control during landing.NTSB CEN14LA210Accident · No injuriesLimited investigationFinal reportRockwell International 114 · Sturgis, MIA cracked nose landing gear pulley, which resulted in the binding of the nosewheel steering system.NTSB CEN14IA172Incident · No injuriesIncident investigationFinal reportCessna 560XL · Traverse City, MIThe inoperative galley drain tube heater, which allowed water within the tube to freeze and led to its failure; the tube’s failure allowed water to drain onto the rudder cables and freeze and resulted in the rudder binding during landing.NTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.NTSB CEN14LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Oscoda, MIThe student pilot’s loss of control during landing in gusting wind conditions. Contributing to the accident was the pilot’s decision to land with gusting wind.NTSB CEN13CA479Accident · Minor injuriesData collectionFinal reportKerr Matthew Starduster TOO · Frankenmuth, MIThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and subsequent impact with a corn field.NTSB CEN13CA335Accident · No injuriesData collectionFinal reportCessna 172S · Ann Arbor, MIThe pilot’s failure to make a go-around in a timely manner and his loss of control during landing.NTSB CEN13CA202Accident · No injuriesData collectionFinal reportCessna 172L · Pontiac, MIThe pilot's failure to maintain airplane control after an unexplained increase in engine power while taxiing.NTSB CEN13CA185Accident · Minor injuriesData collectionFinal reportPiper PA22 · Baraga, MIThe pilot’s failure to maintain directional control during taxi.NTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.NTSB CEN13FA038Accident · No injuriesField investigationFinal reportPiaggio P180 · Boyne City, MIThe select/bypass valve's failure to seal correctly because of improper shimming, which resulted in an uncommanded and uncontrollable left turn during landing. Contributing to the accident was the overhaul facility's improper overhaul of the steering manifold.NTSB CEN12CA305Accident · No injuriesData collectionFinal reportCessna A185F · Crystal Falls, MIThe pilot's abrupt maneuver to avoid deer that unexpectedly ran into the airplane's path during the landing roll.NTSB CEN12LA066Accident · Minor injuriesLimited investigationFinal reportPiaggio Aero Industries P180 · Flint, MIThe captain's failure to maintain directional control during landing with one engine inoperative. Contributing to the accident was an improperly installed clevis pin in the left engine power lever, the crew’s delay in accurately identifying their heading, and…NTSB CEN12LA013Accident · No injuriesLimited investigationFinal reportWilhelm Calidus · Thompsonville, MIThe pilot 's inability to maintain control of the gyrocraft during the landing roll for undetermined reasons.NTSB CEN11LA642Accident · No injuriesLimited investigationFinal reportPiper PA16 · Muskegan, MIThe pilot's loss of directional control during the takeoff roll and the flight instructor's inability to apply remedial action due to the opposite corrective control inputs by the pilot.NTSB CEN11LA419Accident · No injuriesLimited investigationFinal reportVanDenburg Pietenpol Air Camper · Gwinn, MIThe pilot’s loss of directional control during the landing roll, which resulted in a ground loop.NTSB CEN11CA276Accident · No injuriesData collectionFinal reportCessna 182P · Troy, MIThe pilot's inadequate compensation for wind conditions and subsequent loss of control.NTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.NTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.NTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.NTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.NTSB CEN10CA155Accident · No injuriesData collectionFinal reportSchulke Avid Magnum · Lowell, MIThe pilot's inability to maintain directional control while landing on a slush-covered runway due to inadequate maintenance of the airplane brakes by maintenance personnel.NTSB CEN09CA583Accident · No injuriesData collectionFinal reportSierra E5A Replica · Port Huron, MIThe pilot's failure to maintain aircraft control during landing.NTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.NTSB CEN09CA545Accident · Minor injuriesData collectionFinal reportDekkinga Vans RV-7A · Jenison, MIThe pilot's failure to maintain aircraft control during the landing.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB CEN09CA426Accident · No injuriesData collectionFinal reportCessna A188B · South Haven, MIThe pilot's failure to maintain directional control during landing.NTSB CEN09LA319Accident · No injuriesLimited investigationFinal reportMileski Zenair · New Hudson, MIThe pilot's improper flare which resulted in a hard landing and subsequent failure of the nose landing gear.NTSB CEN09LA291Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe · Brighton, MIThe pilot's failure to attain the proper touchdown point, and his failure to initiate a go-around.NTSB CHI08CA094Accident · No injuriesData collectionFinal reportCessna 182 · Traverse City, MIThe unstabalized approach performed by the student pilot and the go-around not performed by the student pilot. Additional causes were the inadequate recovery from a bounced landing and the directional control not obtained by the student pilot. Contributing…