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 BFO94LA116Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Massena, NYThe pilot's improper compensation for wind conditions.NTSB LAX94LA265Accident · No injuriesLimited investigationFinal reportCessna 180 · Elko, NVThe pilot's failure to maintain proper alignment during landing rollout. Factors in the accident were the presence of soft and uneven terrain adjacent to the landing site.NTSB LAX94LA264Accident · No injuriesLimited investigationFinal reportCessna 210A · Mesquite, NVExhaustion of the brake system hydraulic fluid due to an inadequate annual inspection.NTSB BFO94LA114Accident · No injuriesLimited investigationFinal reportCessna 150 · Swanton, VTThe student pilot's failure to maintain directional control.NTSB MIA94LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe pilot's improper handling of the aircraft during the landing. Contributing to the accident was the lack of total experience by the pilot-in-command.NTSB SEA94LA153Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hillsboro, ORThe improper servicing of the skid shock struts.NTSB CHI94LA208Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warren, MNthe pilot's improper use of the parking brake.NTSB IAD94LA109Accident · No injuriesLimited investigationFinal reportbourque experimental Kitfox · Chester, CTThe fracture of the tailwheel assembly for undetermined reasons during the takeoff roll, and the subsequent loss of directional control and collision with a hangar.NTSB FTW94LA201Accident · Minor injuriesLimited investigationFinal reportGamble BD-4 · Leadville, COThe pilot's failure to maintain directional control. Factors were an unreliable airspeed indicator and excessive landing approach airspeed.NTSB BFO94LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250B · Kent, OHThe pilot's failure to maintain directional control.NTSB LAX94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ramona, CAa failure of the pilot to maintain directional control of the airplane. A lack of total experience in tailwheel type airplanes was a factor in the accident.NTSB LAX94LA248Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Wickenburg, AZthe pilot's failure to remove the control lock prior to flight.NTSB CHI94LA199Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clear Lake, MNthe private pilot's failure to maintain directional control during the landing roll. Related factors are the rough/uneven terrain, and excessive brake application.NTSB LAX94LA245Accident · No injuriesLimited investigationFinal reportCessna 180J · Sedona, AZa loss of directional control due to a locked brake from a leaking hydraulic system.NTSB CHI94LA190Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEinadvertant VFR flight into IMC conditions and the pilot's failure to maintain directional control of the airplane. Factors related to the accident were the ground fog and rough terrain encountered.NTSB ANC94LA068Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Bethel, AKThe pilot's failure to maintain directional control during landing.NTSB ATL94LA114Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing. Factors which contributed to the accident were: the wet runway and the pilot's inattentiveness due to fatigue.NTSB SEA94LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Angela, MTDirectional control was not maintained. Factors to the accident were: wet terrain and inadequate aircraft preflight.NTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.NTSB SEA94LA134Accident · Minor injuriesLimited investigationFinal reportKopp Kitfox II · Bremerton, WAThe pilot's inadequate remedial action. Factors include the pilot's failure to maintain directional control, and unfavorable winds.NTSB ANC94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKDirectional control not maintained by the pilot in command. A factor in the accident was the inadvertant ground loop/swerve.NTSB ATL94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22\20 · Kill Devil Hill, NCThe pilot's failure to adequately compensate for the crosswind condition during a landing rollout.NTSB ANC94LA059Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's failure to maintain directional control during takeoff.NTSB SEA94LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Touchet, WAThe pilot's inadequate compensation for wind conditions. The wind gusts were a factor.NTSB NYC94LA095Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Warrenton, VAthe pilot did not maintain directional control of the airplane during an aborted takeoff, which resulted in the airplane veering off the runway and nosing over. A factor in this accident was the pilot's lack of experience on grass strips in this make and…NTSB CHI94LA192Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Noblesville, INthe pilot's excessive use of brakes. Factors related to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB CHI94DTG01Accident · No injuriesFinal reportGrumman G-164-A · La Moure, NDfailure of the pilot to maintain directional control.NTSB LAX94LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Los Banos, CAthe student pilot's inadequate compensation for the existing crosswind conditions and his resultant loss of directional control. A factor in the accident was the student's lack of total flight experience.NTSB ATL94LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Chapel Hill, NCThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during the landing roll. Factors were the crosswinds and gusts prevailing at the airport at the time of the accident.NTSB FTW94LA178Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Antonito, COThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind and the pilot inadvertently becoming lost.NTSB CHI94LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDthe pilot-in-command's not maintaining directional control.NTSB ANC94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pilot Point, AKThe Pilot's failure to maintain control of the airplane during takeoff.NTSB FTW94LA179Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Deming, NMA loss of control on the ground due to the pilot's improper compensation for the crosswind. A factor was the crosswind.NTSB SEA94LA126Accident · No injuriesLimited investigationFinal reportChristen Industries Husky · Ogden, UTThe pilot's inadequate compensation for wind condiitons. The wind gusts were a factor.NTSB FTW94LA160Accident · No injuriesLimited investigationFinal reportCessna 150M · Spring, TXThe pilot's failure to maintain directional control during the attempted takeoff from the touch and go landing. Factors were the inadvertent porpoise and the soft terrain.NTSB ATL94LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Andrews, SCThe failure of the pilot to maintain directional control of the aircraft.NTSB SEA94LA118Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Columbia, CAThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB FTW94LA153Accident · No injuriesLimited investigationFinal reportCessna 120 · Goodyear, AZThe pilot's failure to maintain directional control. A factor was the gusty crosswind.NTSB CHI94LA153Accident · No injuriesLimited investigationFinal reportMaule M-4 · Salina, KSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve. Factors related to the accident were: the crosswind, and the pilot's lack of experience in the make and model of aircraft.NTSB ANC94LA056Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Circle Hot Spri, AKThe pilot-in-command's failure to maintain directional control and his lack of experience in crosswind landings.NTSB LAX94LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAthe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited experience in conventional gear aircraft.NTSB LAX94LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe student pilot's failure to maintain directional control of the aircraft.NTSB FTW94LA148Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Lancaster, TXThe pilot's failure to use tie downs and proper assistance during the hand propping engine start.NTSB CHI94LA150Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Sandwich, ILthe pilot in command's failure to maintain directional control during a crosswind landing and attempted go around.NTSB MIA94LA131Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Crystal River, FLFailure of the pilot-in-command to maintain directional control during the landing roll.NTSB MIA94LA133Accident · No injuriesLimited investigationFinal reportCessna 170A · Boca Raton, FLThe failure of the pilot to maintain directional control.NTSB CHI94LA148Accident · Minor injuriesLimited investigationFinal reportNorth American T-6G · Prairie Du Sac, WIinadequate compensation for wind conditions which resulted in a failure to maintain directional control. Factors associated with the accident were the crosswind conditions and the soft terrain.NTSB SEA94LA114Accident · No injuriesLimited investigationFinal reportCessna 150K · Chehalis, WAThe pilot's inadequate compensation for wind conditions. A factor to the accident was: crosswind.NTSB NYC94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Danbury, CTThe student pilot's inadequate compensattion for wind conditions. The crosswind was a factor.NTSB CHI94LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Willmar, MNthe failure of the pilot in command to maintain directional control during touch and go landings. A factor was the pilot in command's lack of total experience and the snowbank located off the side of the runway.