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 CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.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 WPR13LA267Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORThe pilot’s unstabilized approach and use of an excessive speed at touchdown, which resulted in a loss of directional control during the landing and a subsequent runway excursion.NTSB WPR13LA262Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Burlington, WAThe failure of the rudder bar assembly during landing due to a fatigue crack. Contributing to the accident was the failure of maintenance personnel to perform an adequate inspection of the rudder bar assembly.NTSB CEN13CA317Accident · No injuriesData collectionFinal reportStinson 108 · Lebanon, INThe pilot did not maintain control of the airplane during the landing roll.NTSB CEN13LA323Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Hamlin, TXThe pilot's decision to land the airplane with a crosswind that exceeded the airplane's capabilities.NTSB WPR13CA255Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Martin, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA266Accident · No injuriesData collectionFinal reportCessna 172L · Millinocket, METhe student pilot’s failure to maintain directional control during landing.NTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.NTSB WPR13CA259Accident · No injuriesData collectionFinal reportDressen Escape LS · Fruitland, IDThe pilot’s failure to maintain airplane control during the landing roll as a result of the parking brake lever not being positioned in the full off position.NTSB WPR13CA249Accident · No injuriesData collectionFinal reportBeech V35B · Kernville, CAThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions.NTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB WPR13CA241Accident · No injuriesData collectionFinal reportCessna 172M · Truckee, CAThe pilot’s failure to maintain directional control during the landing roll which resulted in a collision with a tree.NTSB CEN13CA306Accident · No injuriesData collectionFinal reportCessna 170B · Danville, INThe pilot not maintaining directional control of the airplane during the landing roll resulting in the ground loop.NTSB DCA13WA097Incident · No injuriesForeign investigationPanama City, PanamaThe Accident Investigation Unit (UPIA) of Panamá has notified the NTSB of an incident involving a B737-700 that occurred on May 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the UPIA investigation under the provisions of ICAO…NTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.NTSB WPR13LA237Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chandler, AZThe failure of the alternator and/or battery, which prevented the operation of the landing gear extension system and resulted in the nose landing gear collapsing during the landing roll.NTSB CEN13CA284Accident · No injuriesData collectionFinal reportStinson 108-1 · Cambridge, MNThe pilot’s loss of directional control while landing with a gusting crosswind.NTSB WPR13CA232Accident · No injuriesData collectionFinal reportCessna 195A · San Carlos, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13CA282Accident · No injuriesData collectionFinal reportCessna 172RG · Abbeville, LAThe pilot's failure to properly secure the airplane before hand starting the engine and the failure of the brass tie down hook.NTSB ANC13CA045Accident · No injuriesData collectionFinal reportPiper PA-18A · Nikiski, AKThe pilot's failure to maintain directional control during landing, resulting in contact with terrain, and a ground loop.NTSB CEN13CA290Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Pella, IAThe pilot's failure to maintain directional control during landing.NTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.NTSB ERA13CA233Accident · Minor injuriesData collectionFinal reportHughes Charles R Zodiac 601XL · Meriden, CTThe pilot's decision to land with a tailwind and his failure to maintain aircraft control during landing.NTSB ANC13CA040Accident · No injuriesData collectionFinal reportMaule M-5-210C · Juneau, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a ground loop.NTSB WPR13LA217Accident · No injuriesLimited investigationFinal reportRobinson R44 II · Pomeroy, WAThe pilot's failure to ensure that the helicopter was properly loaded, which resulted in the helicopter being in excess of its maximum allowable gross weight and led to a loss of main rotor rpm on takeoff. Contributing to the accident were the ground…NTSB WPR13CA220Accident · No injuriesData collectionFinal reportAdolphson CCK-1865 · Bellingham, WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA13CA216Accident · No injuriesData collectionFinal reportCessna 180 · Bethel, METhe pilot’s failure to maintain directional control during landing.NTSB CEN13LA243Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Albuquerque, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13CA247Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Owatonna, MNThe pilot’s loss of directional control during an aborted landing.NTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.NTSB CEN13CA236Accident · No injuriesData collectionFinal reportCessna T182T · Colorado Springs, COThe pilot’s improper recovery from a bounced landing.NTSB CEN13CA234Accident · No injuriesData collectionFinal reportCessna 175A · Albuquerque, NMThe pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.NTSB WPR13CA202Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Mesa, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR13CA200Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the airplane’s subsequent collision with a fence during the go-around attempt.NTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.NTSB CEN13LA231Accident · No injuriesLimited investigationFinal reportNeedham Stoddard-Hamilton TD · Bloomington, INThe improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.NTSB ERA13CA202Accident · Minor injuriesData collectionFinal reportCessna 172N · Summersville, WVThe pilot's failure to maintain directional control of the airplane while landing, which resulted in a runway excursion.NTSB ERA13CA200Accident · No injuriesData collectionFinal reportCessna 152 · Columbus, GAThe student pilot's improper recovery from a bounced landing.NTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.NTSB ERA13LA191Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Hammonton, NJA loss of control during landing due to the failure of the nose landing gear's left trunnion lug.NTSB WPR13LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Phoenix, AZThe student pilot's excessive directional control inputs during the takeoff roll and the flight instructor's delayed and ineffective corrective actions, which resulted in the loss of airplane control.NTSB WPR13CA179Accident · No injuriesData collectionFinal reportAeronca 7CCM · Caldwell, IDThe pilot's loss of directional control after an encounter with a wind gust during takeoff.NTSB WPR13CA173Accident · No injuriesData collectionFinal reportCessna 150 · Brush Praire, WAThe pilot's failure to maintain directional control during the landing flare.NTSB WPR13CA172Accident · No injuriesData collectionFinal reportWaco YMF-3 · Thermal, CAThe pilot’s failure to maintain directional control while landing in a gusting crosswind.NTSB ERA13CA223Accident · No injuriesData collectionFinal reportPiper J3L-65 · Daytona Beach, FLThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion. Contributing to the accident was the pilot’s improper decision to land with a tailwind.NTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA185Accident · No injuriesData collectionFinal reportCessna 172N · Bally, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB ENG13IA020Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-145 · Houston, TXThe uncommanded left deflection of the airplane's nose wheel due to a malfunction of the electrohydraulic servo valve (EHSV) within the nose wheel steering manifold assembly. The reason for the malfunction could not be determined; however, a foreign substance…