NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 CHI07CA136Accident · No injuriesData collectionFinal reportCessna 182P · Traer, IAThe pilot's failure to maintain control of the airplane during landing on the grass airstrip. A contributing factor was the pilot's limited experience operating on grass runways. Additional factors were the runway cone struck during landing and the irrigation…NTSB DFW07CA106Accident · Minor injuriesData collectionFinal reportCessna 152 · Houston, TXThe student pilot's failure to maintain directional control during landing. A contributing factor was the prevailing crosswind.NTSB CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.NTSB CHI07CA137Accident · No injuriesData collectionFinal reportAeronca 7AC · Mason, MIThe pilot's failure to maintain directional control during the landing roll and failure to maintain sufficient airspeed during the aborted landing attempt, leading to an inadvertent stall. An additional factor was the tree.NTSB NYC07CA110Accident · No injuriesData collectionFinal reportLuscombe 8A · Whitefield, NHThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB LAX07CA284Accident · Minor injuriesData collectionFinal reportCessna 150M · Sonoma, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB SEA07CA121Accident · No injuriesData collectionFinal reportCessna 180G · Lopez Island, WAThe pilot's failure to maintain directional control during takeoff. Geese were a factor.NTSB MIA07CA094Accident · Serious injuriesData collectionFinal reportRotor Flight Dynamics Dominator · Mountain City, TNThe pilot's decision to attempt operation of the airplane with a known physical impairment (loss of leg control) which resulted in his loss of aircraft control during takeoff and the airplane nosing over.NTSB MIA07CA090Accident · No injuriesData collectionFinal reportCessna 172R · Lantana, FLThe student pilot's failure to maintain directional control of the airplane during landing roll.NTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…NTSB SEA07CA115Accident · Minor injuriesData collectionFinal reportCessna 180 · Brigham City, UTThe pilot's failure to maintain directional control during the landing roll. Factors include variable winds, and crosswinds, and an abrupt drop-off at the runway shoulder.NTSB DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.NTSB DEN07CA091Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Westminster, MDThe pilot's failure to maintain directional control.NTSB DEN07CA088Accident · No injuriesData collectionFinal reportAcro Sport Acroduster II SA750 · Albuquerque, NMThe pilot's failure to maintain directional control during the landing roll.NTSB ANC07CA034Accident · No injuriesData collectionFinal reportPiper PA-12 · Delta Junction, AKThe damaged and deflated over-sized tire on the main landing gear, which precipitated a loss of directional control during landing.NTSB CHI07CA120Accident · No injuriesData collectionFinal reportChampion 7GCAA · Grand Rapids, MNThe pilot's failure to maintain directional control and his excessive use of brakes during the landing which resulted in a nose-over. The downhill slope was a contributing factor.NTSB ANC07LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Sarasota, FLThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during landing, and collision with objects. Factors associated with the accident were wind gusts and a crosswind.NTSB DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.NTSB ANC07CA030Accident · No injuriesData collectionFinal reportPiper PA-22 · Soldotna, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control, an encounter with a muddy berm, and a nose over. A factor in the accident was a crosswind.NTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.NTSB SEA07CA104Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Concord, CAThe pilot's failure to maintain directional control during landing, resulting in a ground loop/swerve and collapse of the nose landing gear. A contributing factor was the gusty wind condition.NTSB CHI07CA101Accident · No injuriesData collectionFinal reportLuscombe 8A · Chippewa Falls, WIThe pilot intentionally leaving the airplane unoccupied during the engine start, which resulted in the unoccupied airplane traversing into a cornfield. A factor was the rough/uneven cornfield.NTSB NYC07CA097Accident · No injuriesData collectionFinal reportCessna A185F · Ashland, METhe pilot's failure to maintain aircraft control while taxiing, which resulted in a nose over. A factor in this accident was the frozen, slush covered lake.NTSB CHI07CA103Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe pilot's failure to maintain directional control of the airplane during landing. A contributing factor to the accident was the runway marker sign.NTSB LAX07CA128Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Porterville, CAThe pilot's failure to maintain directional control.NTSB DEN07CA084Accident · No injuriesData collectionFinal reportCessna 180C · Santa Fe, NMExceeding the airplane's maximum demonstrated crosswind component during the takeoff roll. A contributing factor was the crosswind.NTSB CHI07LA108Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Wheeling, ILPartial failure of the left engine propeller governor during the takeoff ground roll. Factors included that directional control was not possible by the pilot which subsequently led to a collision with an airport sign.NTSB ANC07LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe student pilot's failure to maintain directional control while taxiing, which resulted in the airplane contacting a snow berm and nosing down. Factors associated with the accident were the snow and ice covered runway, and excessive taxispeed.NTSB LAX07CA124Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Stuart, FLThe pilot's failure to maintain directional control during takeoff.NTSB CHI07CA130Accident · No injuriesData collectionFinal reportBoeing E75N1 · Fostoria, OHThe pilot's inadequate compensation for wind conditions and his subsequent failure to maintain directional control during landing. The crosswind and wind gusts were contributing factors.NTSB SEA07LA087Accident · Serious injuriesLimited investigationFinal reportBurdette RV-3 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll. Factors include an earthen berm near the point where the aircraft departed the side of the runway.NTSB MIA07CA069Accident · No injuriesData collectionFinal reportAeroprakt A-22 · Keenansville, FLThe pilot's failure to maintain directional control during the landing roll on a wet grass runway. A factor associated with the accident was the wet runway.NTSB LAX07CA117Accident · No injuriesData collectionFinal reportEdwards Wag-A-Bond · Jean, NVthe separation of the tail wheel and rudder assembly compression springs that resulted in a loss of directional control during the landing rollout.NTSB LAX07CA116Accident · No injuriesData collectionFinal reportCessna 180D · Winslow, AZthe pilot's failure to maintain directional control during landing.NTSB ATL07CA059Accident · No injuriesData collectionFinal reportStinson 108 · Lawrenceville, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop.NTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.NTSB DEN07LA077Accident · No injuriesLimited investigationFinal reportPiaggio Industrie P180 · Fort Lauderdale, FLThe first officer's loss of directional control during landing causing the left main gear to collapse. Contributing factors in this accident were the flight crew's excessive use of brakes causing the left main tire to blow out, and the captain's inadequate…NTSB SEA07CA078Accident · No injuriesData collectionFinal reportCessna 150A · Davenport, WAThe pilot's failure to maintain directional control while landing, which resulted in a nose over. Wind gusts and the pilot's inadequate compensation for the wind condition were factors.NTSB CHI07LA092Accident · No injuriesLimited investigationFinal reportSocata TB-20 Trinidad · Rhinelander, WIThe failure of the pilot to maintain directional control of the airplane during taxi. A contributing factor was the gusting winds and sign.NTSB NYC07CA082Accident · No injuriesData collectionFinal reportCessna 172P · Sanford, FLThe student pilot's failure to maintain directional control during the landing roll. Factors included a 90-degree crosswind, and the student pilot's improper in-flight decision to land on a runway with the crosswind rather than on an available runway with a…NTSB ATL07CA060Accident · No injuriesData collectionFinal reportMaule M-5 235C · Moultrie, GAThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB LAX07CA112Accident · No injuriesData collectionFinal reportCaywood Long-Ez · El Cajon, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI07CA090Accident · No injuriesData collectionFinal reportCessna 172E · Big Rapids, MIThe student pilot's failure to maintain directional control of the airplane during takeoff which led to the impact with the snow banks adjacent to the runway. The snow banks were contributing factors in the accident.NTSB LAX07CA105Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Groveland, CAthe pilot's failure to maintain directional control.NTSB SEA07LA075Accident · No injuriesLimited investigationFinal reportFound Aircraft Canada FBA-2C2 · Reno, NVThe certified flight instructor's failure to maintain directional control of the airplane during landing, which resulted in a groundloop.NTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.NTSB CHI07CA089Accident · No injuriesData collectionFinal reportCessna 172R · Columbus, OHThe pilot's failure to maintain directional control while landing. Contributing factors to the accident were the wind conditions and the runway sign.NTSB ATL07CA049Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Ocraacoke, NCThe pilot's improper use of the aileron and rudder controls and inadequate compensation for the wind conditions during a crosswind landing resulting in a loss of directional control.NTSB NYC07CA078Accident · No injuriesData collectionFinal reportCessna 172R · Norfolk, VAThe pilot's failure to maintain directional control while landing, which resulted in a collision with a runway sign. A factor was the crosswind.NTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.