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 ERA12CA283Accident · No injuriesData collectionFinal reportCessna 150M · Cedartown, GAThe pilot’s failure to maintain directional control during takeoff.NTSB ERA12LA287Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cross Keys, NJThe pilot's failure to maintain control of the airplane during landing, which resulted in the overstress and subsequent failure of the right main landing gear assembly.NTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.NTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.NTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.NTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.NTSB CEN12CA238Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Youngstown, OHThe pilot's loss of control while landing, which resulted in a ground loop.NTSB WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.NTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB WPR12CA153Accident · Minor injuriesData collectionFinal reportCessna 172 · Johnson Valley, CAThe pilot did not properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane.NTSB ERA12CA269Accident · No injuriesData collectionFinal reportLuscombe 8A · Pittsburgh, PAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA12CA266Accident · No injuriesData collectionFinal reportPiper PA-60-602P · Philadelphia, PAThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB WPR12CA151Accident · No injuriesData collectionFinal reportLake LA-4-200 · Lake Havasu City, AZThe pilot did not maintain directional control during a water touchdown.NTSB CEN12CA226Accident · No injuriesData collectionFinal reportRuiz E RAF 2000 · Anahuac, TXThe student pilot's improper nosewheel and cyclic positioning during the taxi, which resulted in the gyroplane's main rotor contacting the runway surface. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB CEN12CA219Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Emporia, KSThe pilot's loss of directional control while landing, which resulted in a ground loop and impact with a fence.NTSB WPR12CA150Accident · No injuriesData collectionFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot did not maintain directional control of the airplane during the landing roll.NTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12LA209Accident · 1 fatalLimited investigationFinal reportWalling Vans RV-3 · Larchwood, IAThe pilot's failure to maintain directional control of the airplane after landing.NTSB CEN12LA198Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Bloomfield, INThe pilot's failure to land with sufficient runway remaining to stop, which resulted in an unsuccessful aborted landing, inadvertent stall, and collision with terrain.NTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB CEN12CA201Accident · No injuriesData collectionFinal reportJoy Vans RV-6 · McKinney, TXThe pilot did not maintain control of the airplane during takeoff, which resulted in a ground collision with airport construction materials.NTSB WPR12CA145Accident · No injuriesData collectionFinal reportRockwell International 690C · Conrad, MTThe pilot did not maintain directional control of the airplane due to ice and slushy snow on the runway during the landing roll.NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB WPR12CA142Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jean, NVThe student pilot did not maintain directional control during the landing roll.NTSB ERA12CA245Accident · No injuriesData collectionFinal reportAeronca 7AC · Clearwater, FLThe pilot's failure to maintain airplane control during takeoff and the flight instructor's inadequate supervision, which resulted in a runway excursion.NTSB CEN12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Indianapolis, INThe student pilot did not maintain directional control while practicing a soft-field takeoff.NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…NTSB ERA12CA235Accident · No injuriesData collectionFinal reportPiper J3C-65 · Douglas, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's lack of experience in the tailwheel-equipped airplane.NTSB CEN12CA193Accident · No injuriesData collectionFinal reportBellanca 17-30A · Branson, MOThe pilot did not maintain directional control of the airplane while landing with a gusting crosswind.NTSB CEN12CA190Accident · No injuriesData collectionFinal reportCessna A185F · Fort Worth, TXThe pilot did not maintain directional control of the airplane while landing in gusty wind conditions.NTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.NTSB ERA12CA232Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Dover, TNThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a collision with an object and a landing gear collapse during the subsequent landing.NTSB WPR12CA137Accident · No injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe pilot did not properly secure the airplane before starting the engine by manually rotating the propeller, which resulted in the inadvertent movement of the airplane.NTSB WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA185Accident · No injuriesData collectionFinal reportCessna 180H · Belle Chase, LAThe bent tailwheel spring that allowed the tailwheel to caster when the airplane encountered a wind gust on landing roll.NTSB WPR12CA127Accident · No injuriesData collectionFinal reportCessna 172N · Kelso, WAThe pilot did not maintain directional control during the landing flare.NTSB ERA12CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Hollandale, MSThe pilot's failure to maintain directional control while taxiing in gusty wind conditions.NTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.NTSB ANC12IA024Incident · No injuriesIncident investigationFinal reportBombardier Learjet 35A · Anchorage, AKThe flightcrew's loss of visual reference to the runway after encountering severe in-flight icing conditions, which resulted in a loss of control while landing and exceedence of the capabilities of the airplane's windscreen anti-ice systems. Contributing to…NTSB WPR12LA122Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby 1-A · Fallbrook, CAThe pilot did not maintain directional control of the airplane during the takeoff roll.NTSB WPR12CA132Accident · No injuriesData collectionFinal reportCessna 170B · San Jose, CAThe pilot did not maintain directional control during the landing roll.NTSB ERA12CA220Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Beverly, MAThe pilot's loss of airplane control during takeoff, which resulted in a runway excursion.NTSB WPR12CA121Accident · No injuriesData collectionFinal reportSiai-Marchetti SF.260TP · Corona, CAThe pilot did not maintain runway alignment during landing in a gusting crosswind.NTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.NTSB ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.NTSB CEN12LA168Accident · No injuriesLimited investigationFinal reportCessna 180H · Conroe, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed intervention and the pilot’s lack of experience in tailwheel airplanes.NTSB WPR12LA111Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Kalispell, MTA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA114Accident · No injuriesData collectionFinal reportAeronca 7BCM · Woodland, CAThe pilot did not maintain directional control during landing.NTSB CEN12LA176Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Bowling Green, OHThe pilot’s failure to maintain directional control during landing.