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 ANC97LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the crosswind.NTSB LAX97LA175Accident · No injuriesLimited investigationFinal reportAeronca 7AC-EC · Truckee, CAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during the landing and go-around. The gusty/crosswind condition and proximity of obstructions (runway sign and rocks) were related factors.NTSB MIA97LA157Accident · No injuriesLimited investigationFinal reportThacker Starduster TOO SA300 · Lake Wales, FLfailure of the tail wheel to lock in the centered detent during the beginning of the takeoff roll, which resulted in the pilot being unable to maintain directional control and the aircraft drifting off the runway and nosing over in the soft ground.NTSB ANC97LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor associated with the accident was: the variable crosswind condition.NTSB NYC97LA086Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, OHThe flight instructor's inadequate supervision and his failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and striking the precision approach path indicator lights.NTSB MIA97LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Key Largo, FLthe pilot's failure to maintain directional control during a crosswind landing, which resulted in an inadvertent ground swerve and collision with bushes and terrain.NTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.NTSB FTW97LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinney, TXthe student pilot's failure to maintain directional control on the ground after recovery from a bounced landing.NTSB ANC97LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Soldotna, AKthe pilot's inadequate compensation for cross conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the variable/gusty/crosswind condition.NTSB CHI97LA107Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180 · Lakeville, MNthe pilot's inadequate compensation for the crosswind.NTSB ANC97LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Delta Junction, AKfailure of the pilot to maintain directional control of the airplane.NTSB IAD97LA066Accident · No injuriesLimited investigationFinal reportGlobe GC-1-A · Wilmington, OHfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a collision with trees. Related factors were: the crosswind, and lack of experience in the make and model of airplane.NTSB ANC97LA057Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Palmer, AKthe pilot's inadequate preflight, and a foreign object (can) that became jammed under the rudder pedal, which resulted in an inadvertent activation of the right brake.NTSB LAX97LA162Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for the crosswind condition, and his failure to maintain directional control during landing. Factors related to the accident were: the crosswind, and the pilot's inadvertent unlocking of the tail wheel during a wheel…NTSB ANC97LA058Accident · No injuriesLimited investigationFinal reportCessna 185F · Manley, AKthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing run. Factors relating to the accident were: frozen terrain, adverse wind condition, and proximity of a snowbank.NTSB SEA97LA087Accident · No injuriesLimited investigationFinal reportCessna A185E · Billings, MTThe flight instructor's inadequate compensation for the wind conditions. The crosswind conditions were a factor.NTSB MIA97LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Pickens, SCfailure of the student pilot to maintain directional control during the takeoff roll from a touch-and-go landing, which resulted in the airplane going off the side of the runway, down an embankment, and into brush/trees.NTSB NYC97LA074Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Waynesboro, VAThe pilot's failure to maintain directional control during landing.NTSB MIA97LA136Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Hollywood, FLthe student pilot's failure to maintain directional control during the landing/go-around, which led to subsequent in-flight collision with a fixed object (approach light/light bar/sign) and terrain. The student's failure to obtain the proper touchdown point…NTSB NYC97LA072Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Vincentown, NJThe pilot's failure to maintain directional control, which resulted in an on ground loss of control. A contributing factor was a crosswind.NTSB LAX97LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper runway alignment.NTSB CHI97LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Olathe, KSthe pilot's improper inflight planning/decision and exceeding the airplane recommended crosswind component. Factors associated with this accident were the weather conditions of a high wind, gusts, and a crosswind.NTSB FTW97LA155Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Silver City, NMThe high wind and the pilot's inadequate compensation for the crosswind conditions. Factors were the crosswind and wind gusts.NTSB MIA97LA117Accident · No injuriesLimited investigationFinal reportNorth American T6G · Wilmington, NCThe pilot's failure to maintain directional control on landing. Factors were: the crosswind and the pilot's lack of experience in type airplane.NTSB CHI97LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Oshkosh, WIthe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper runway alignment, which resulted in a subsequent nose over. The gusty crosswind condition was a related factor.NTSB ANC97TA045Accident · No injuriesFinal reportPiper PA-18 · Noatak, AKfailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground loop and damage to the airplane. Factors associated with the accident were: the ice/snow covered runway, and the pilot's lack of experience in the…NTSB LAX97LA136Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Camarillo, CAThe pilot's failure to adequately compensate for crosswind conditions during landing.NTSB FTW97LA152Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stillwater, OKthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control, which resulted in a ground swerve and collapse of the nose gear. The crosswind was a related factor.NTSB IAD97LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Warrenton, VAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB FTW97LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Glenwood Spgs, COThe pilot's failure to maintain airplane directional control, and his use of excessive rudder control.NTSB FTW97LA143Accident · No injuriesLimited investigationFinal reportCessna 180D · Erie, COThe pilot's failure to maintain airplane directional control. A factor was the crosswind.NTSB CHI97LA092Accident · No injuriesLimited investigationFinal reportChampion 7ECA · South St. Paul, MNThe pilot's inadequate compensation for wind and his failure to maintain adequate obstacle clearance which resulted in collision with a snowbank. The pilot's lack of recent experience, the crosswind, and snowbank are contributing factors.NTSB SEA97LA078Accident · No injuriesLimited investigationFinal reportCessna 177B · Everett, WAfailure of the pilot to maintain directional control of the airplane after landing. Factors relating to the accident include: a blown (failed) nose tire, and soft terrain beside the runway.NTSB SEA97LA073Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arlington, WALanding long (improper touchdown point) and collapse of the main landing gear during an intentional swerve or groundloop. Factors include excessive airspeed on approach.NTSB LAX97LA130Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Victorville, CAfailure of the pilot to maintain directional control of the aircraft during the landing rollout.NTSB SEA97LA081Accident · No injuriesLimited investigationFinal reportNorth American NA-265-40 · Hailey, IDan electrical short in the electrical system, which resulted in a malfunction of the nosewheel steering system and loss of directional control.NTSB IAD97LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Harrison, OHthe student pilot's failure to maintain directional control, and his improper operation of the throttle for regain control, which resulted in the airplane veering off the runway and colliding with a tree.NTSB ANC97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI97LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Kirksville, MOthe pilot failed to adequately compensate for the wind conditions on the runway during landing roll. Factors included the crosswind and gusts.NTSB LAX97LA119Accident · No injuriesLimited investigationFinal reportCessna 172N · Oakland, CAthe student pilot's failure to completely reduce the throttle after landing, and his failure to maintain proper runway alignment.NTSB CHI97LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Two Harbors, MNfailure of the pilot to maintain directional control of the airplane during landing. Factors relating to the accident were: the gusty crosswind condition, and the snowbank.NTSB IAD97FA052Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 · Cleveland, OHThe pilot in command did not maintain control while utilizing the full auto-land system. Factors to this accident were a contaminated runway, a crosswind, and inadequate guidance provided in the aircraft manual.NTSB FTW97IA120Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Abilene, TXThe flightcrew's failure to maintain aircraft control. Factors were the tailwind and a partial nosewheel steering failure.NTSB SEA97LA068Accident · Minor injuriesLimited investigationFinal reportHemingway Varieze · Arlington, WAThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the pilot's lack of total experience in the type of aircraft and the gusty wind conditions.NTSB LAX97LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.NTSB LAX97LA106Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Rubidoux, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB ANC97LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKthe pilot's inadequate compensation of wind conditins, and failure to maintain directional control during the takeoff run. The crosswind was a related factor.NTSB SEA97LA060Accident · No injuriesLimited investigationFinal reportCessna 172N · Delta, UTThe pilot's failure to adequately compensate for the prevailing wind conditions, and his subsequent failure to maintain directional control during the landing roll. Factors contributing to the accident are a sudden shift in the prevailing wind at the time of…NTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.NTSB ATL97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Winston Salem, NCthe pilot's inadequate compensation for wind conditions and failure to maintain directional cntrol of the airplane, which resulted in a ground swerve and collapse of the right main landing gear. The crosswind was a related factor.