NTSB investigations
4,591 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.\"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."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 ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.NTSB WPR11CA106Accident · No injuriesData collectionFinal reportCessna 180 · Prescott, AZThe pilot's loss of airplane control during the landing roll.NTSB CEN11CA165Accident · No injuriesData collectionFinal reportCulver Glenn Kitfox III · Terlingua, TXThe pilot's loss of directional control on takeoff.NTSB ERA11CA123Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Jasper, ALThe pilot's loss of directional control on a wet runway during takeoff from a touch and go landing resulting in a runway excursion.NTSB CEN11CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Corsicana, TXThe student pilot’s failure to maintain directional control during landing.NTSB CEN11CA158Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with terrain.NTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…NTSB ERA11LA116Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Stuart, FLThe student pilot's inadvertent activation of the collective control, which allowed the helicopter to become airborne and impact the ramp.NTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.NTSB WPR11CA100Accident · No injuriesData collectionFinal reportCessna 180 · Fullerton, CAThe pilot’s failure to maintain directional control during landing.NTSB WPR11CA099Accident · No injuriesData collectionFinal reportDiamond DA20C1 · Spanish Fork, UTThe pilot’s failure to maintain directional control during landing.NTSB WPR11CA098Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Austin, NVThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR11FA093Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Phoenix, AZThe pilot did not maintain directional control during the landing roll. Contributing to the accident was low nosewheel tire pressure.NTSB WPR11CA091Accident · No injuriesData collectionFinal reportMaule M-4-180V · Elko, NVThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA11CA109Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lancaster, SCThe pilot's failure to maintain directional control during an attempted go-around maneuver after landing.NTSB CEN11LA142Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · McKinney, TXThe pilot's loss of directional control during landing.NTSB CEN11CA143Accident · No injuriesData collectionFinal reportRardin William I Kitfox III · Carlisle, ARFailure of the left main landing gear strut due to a pre-existing crack in the weld joint.NTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR11CA086Accident · No injuriesData collectionFinal reportGiorgio Anthony J RV4 · Torrance, CAThe pilot's inadequate landing flare that resulted in a hard landing and a ground loop.NTSB WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.NTSB CEN11CA140Accident · No injuriesData collectionFinal reportRockwell International 114A · North Lima, OHThe pilot’s failure to maintain directional control during the landing touchdown.NTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.NTSB WPR11LA081Accident · No injuriesLimited investigationFinal reportApollo AS-III · Poipu, HIThe pilot's lack of compliance with manufacturer's guidance for care and handling of the aircraft combined with incomplete preflight inspections, which resulted in an undetected material failure of the nose cone.NTSB CEN11CA126Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Hemphill, TXThe student pilot’s improper decision to carry an unauthorized passenger and the passenger’s loss of control of the helicopter during take-off.NTSB ANC11LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Saint Michael, AKThe loss of directional control during landing due to a flat nose wheel tire, resulting in a runway excursion and collision with trees.NTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.NTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.NTSB WPR11CA060Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Warner Springs, CAThe certified flight instructor's inadequate compensation for the crosswind and delayed remedial action during landing, which resulted in a ground loop.NTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.NTSB ERA11WA073Accident · Minor injuriesForeign investigationSwearingen SA227 · Andahuaylas, PeruNTSB WPR11LA044Accident · No injuriesLimited investigationFinal reportPiper PA30 · Tucson, AZThe pilot's impairment by an undiagnosed medical condition, which resulted in a loss of directional control and subsequent collision with a building during the landing roll. Contributing to the accident was the pilot's decision to fly when he was not feeling…NTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.NTSB ERA11CA053Accident · No injuriesData collectionFinal reportLuscombe 8A · Hot Springs, VAThe pilot's inadequate compensation for the crosswind during landing.NTSB WPR11CA037Accident · No injuriesData collectionFinal reportCessna 172S · Port Townsend, WAThe pilot's improper flare/touchdown while landing, resulting in a loss of directional control and a runway excursion.NTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.NTSB CEN11CA121Accident · No injuriesData collectionFinal reportPiper J3C-65 · Cypress, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA11CA039Accident · No injuriesData collectionFinal reportCessna 172P · Tampa, FLThe student pilot's failure to maintain directional control during a short-field takeoff.NTSB WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.NTSB WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB WPR11CA028Accident · No injuriesData collectionFinal reportCessna 195 · Wells, NVThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB ERA11IA026Incident · No injuriesIncident investigationFinal reportShort Bros. & Harland Shorts SC7 Skyvan · Fort Lauderdale, FLThe flightcrew’s failure to maintain directional control while initiating an engine reverse after landing.NTSB ERA11CA035Accident · No injuriesData collectionFinal reportBoeing PT17 · Fayetteville, WVThe pilot's failure to maintain directional control during the takeoff roll.NTSB ANC11CA003Accident · No injuriesData collectionFinal reportPiper PA-12 · Merrill Field Airport, AKThe certificated flight instructor's failure to apply the correct remedial actions to maintain directional control during the takeoff roll.NTSB CEN11CA021Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Almyra, ARThe pilot’s improper touchdown point and delayed decision to execute a go-around, which resulted in a runway overrun and collision with terrain.NTSB WPR11CA014Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Palm Springs, CAThe pilot's failure to maintain directional control during landing, resulting in a ground loop.NTSB CEN11CA026Accident · No injuriesData collectionFinal reportCessna 180 · Farmington, NMThe failure of the pilot and the flight instructor to maintain directional control of the airplane during a training maneuver.