NTSB investigations, 1994
213 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 372 |
|---|---|
| 1983 | 374 |
| 1984 | 329 |
| 1985 | 295 |
| 1986 | 315 |
| 1987 | 331 |
| 1988 | 295 |
| 1989 | 235 |
| 1990 | 278 |
| 1991 | 244 |
| 1992 | 217 |
| 1993 | 232 |
| 1994 | 213 |
| 1995 | 210 |
| 1996 | 221 |
| 1997 | 219 |
| 1998 | 224 |
| 1999 | 247 |
| 2000 | 229 |
| 2001 | 215 |
| 2002 | 204 |
| 2003 | 240 |
| 2004 | 217 |
| 2005 | 228 |
| 2006 | 213 |
| 2007 | 232 |
Where
Latest cases
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 year(c.\"eventDate\") = 1994
AND 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 year(c."eventDate") = 1994 AND 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 FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.NTSB CHI95LA063Accident · Minor injuriesLimited investigationFinal reportHoover Bushby MM1 · Chesterfield, MOthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of recent total experience.NTSB SEA95LA032Accident · Minor injuriesLimited investigationFinal reportPitts S-2B · Afton, WYThe pilot's failure to maintain directional control, and his inadequate remedial action. Factors include snow covered terrain at the edge of the runway.NTSB BFO95LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDSeparation of the steering linkages on the nosegear which resulted in the pilot being unable to maintain directional control during landing and subsequent on ground collision with a ditch.NTSB LAX95LA059Accident · No injuriesLimited investigationFinal reportCessna 185A · Long Beach, CAthe pilot's failure to maintain directional control of the aircraft both during the landing and the attempted rejected landing maneuver.NTSB MIA95LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe student pilots failure to follow the checklist and assure the door was closed prior to takeoff. Contributing to the accident was the student's diverted attention during the takeoff roll.NTSB ATL95LA029Accident · No injuriesLimited investigationFinal reportCessna 172F · Carrollton, GAThe pilot's inadvertent collision with trees, adjacent to the taxiway, while attempting to avoid a deer that crossed the taxiway.NTSB LAX95LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Corona, CAthe pilot's failure to maintain directional control due to his improper use of the rudder and brakes.NTSB FTW95LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKThe pilot's improper recovery from a bounced landing. Factors were the improper flare and the resultant loss of directional control.NTSB CHI95LA057Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Scott City, KSthe pilot's failure to attain compensation for wind conditions. A factor was the crosswind condition.NTSB ATL95LA026Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe pilot's failure to maintain directional control during a crosswind takeoff.NTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.NTSB ANC95LA013Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's inadequate compensation for crosswind. Crosswind conditions and an icy runway surface were factors in the accident.NTSB FTW95LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COThe pilot's loss of directional control.NTSB FTW95LA043Accident · No injuriesLimited investigationFinal reportCessna 206E · San Benito, TXThe pilot's improper attempt to make an off airport landing at night and the inadvertent ground loop. A factor was the dark night light condition.NTSB ANC95LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's inadequate compensation for crosswind conditions. A crosswind and icy runway conditions were factors in the accident.NTSB CHI95LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Zeeland, MIthe pilot's loss of directional control during touch and go landings. Factors were the crosswind and the pilot's lack of total experience.NTSB CHI95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rochelle, ILthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the student pilot's improper use of the brakes.NTSB BFO95LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bucyrus, OHThe pilot's faliure to maintain directional control during the takeoff roll.NTSB LAX95LA025Accident · No injuriesLimited investigationFinal reportCessna 172F · Tonopah, NVthe pilot's excessive taxi speed and improper remedial action after the nose gear began to shimmy. The nose gear shimmy (nose gear vibration) and the berm were factors in this accident.NTSB LAX95LA028Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Mariposa, CAthe unqualified student pilot's improper use of the brakes and his failure to maintain directional control of the aircraft. The pilot's lack of total experience is a factor in this accident.NTSB LAX95LA021Accident · No injuriesLimited investigationFinal reportNorth American-Barene P-51-D · Victorville, CAthe pilot's failure to maintain directional control during a crosswind landing.NTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.NTSB MIA95LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, resulting in an on-ground loss of control, and collision with terrain.NTSB CHI95LA015Accident · No injuriesLimited investigationFinal reportQuestair Venture · Wheeling, ILThe inadvertent deployment of the nosewheel steering. A factor in this accident was the inadequate design of the rudder pedal pivot point height above the cockpit floor by the design personnel.NTSB LAX95LA010Accident · No injuriesLimited investigationFinal reportBeech C-23 · Kahului, HIthe student pilot's improper recovery from a bounced landing, improper in-flight decision, and his failure to attain the proper climb airspeed during the initial takeoff resulting in an inadvertent stall. The student pilot's lack of total experience,…NTSB NYC95LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Fitchburg, MAThe pilot's failure to adequately compensate for the crosswind condition during landing, which resulted in a ground loop and the subsequent wing tip collision with the runway.NTSB MIA95LA006Accident · No injuriesLimited investigationFinal reportCessna 172-F · Clearwater, FLThe student pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident was the pilot's lack of total experience.NTSB LAX95LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Lone Pine, CAThe pilot's failure to abort the takeoff, resulting in a premature lift-off. A factor in the accident was the failure of the steering linkage.NTSB FTW95LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of directional control on the ground and the pilot's inadvertent ground loop. A factor was the failure by the pilot of the conflicting traffic on the runway to maintain proper traffic separation.NTSB FTW95LA015Accident · No injuriesLimited investigationFinal reportCessna 185 · Abbeville, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB MIA95LA003Accident · No injuriesLimited investigationFinal reportPitts S1C · Plant City, FLThe failure of the pilot in command to maintain directional control during landing resulting in the aircraft running off the side of the runway and nosing over in soft terrain.NTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.NTSB SEA95LA001Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Billings, MTInadequate compensation for wind conditions. Factors to the accident were: crosswind and inadequate remedial action.NTSB ATL95LA002Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Covington, TNThe pilot's failure to maintain directional control during landing.NTSB ATL95LA001Accident · No injuriesLimited investigationFinal reportBeech V35B · Siler City, NCThe pilot's failure to maintain directional control during landing roll.NTSB FTW94LA318Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control.NTSB FTW94LA308Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Monte Vista, COThe pilot's failure to maintain directional. Factors were the cross wind conditions, and the pilot's poor evaluation of the weather.NTSB CHI94LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainwell, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of total experience.NTSB ATL94LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Linden, TNThe pilot's improper use of the rudder which resulted in a loss of directional control.NTSB CHI94LA337Accident · 1 fatalLimited investigationFinal reportPiper PA-20 · Greenville, MIIncapacitation of the pilot due to a seizure and/or loss of consciousness. A factor related to the accident was: the pilot's failure to properly report his medical information on his FAA medical application.NTSB FTW94LA305Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Nacogdoches, TXThe pilot's inadequate compensation for crosswind during landing rollout. A factor was the variable crosswind.NTSB CHI94LA339Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, KSthe pilot's failure to maintain directional control during an aborted takeoff. A factor related to the accident was the delay in aborting the takeoffNTSB FTW94LA301Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Russellville, ARThe pilot's inadequate compensation for the crosswind during the takeoff ground roll. A factor was the crosswind.NTSB ANC94LA142Accident · No injuriesLimited investigationFinal reportde Havilland DHC2 · Whittier, AKThe pilot's inadequate in-flight planning and inadequate compensation for the wind conditions. An initial tail wind and later a crosswind were factors in the accident.NTSB SEA94LA240Accident · No injuriesLimited investigationFinal reportCessna 180G · Cut Bank, MTInadequate compensation for wind conditions. A factor to the accident was wind gusts.NTSB FTW94LA298Accident · No injuriesLimited investigationFinal reportCessna 172M · Oil Trough, ARThe pilot's loss of aircraft directional control during the landing roll. A factor was the wet grass landing surface.NTSB SEA94LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Nampa, IDDirectional control was not maintained. A factor to the accident was: inadequate supervision.NTSB ANC94LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKA failure of the pilot to adequately compensate for crosswind conditions. A crosswind and rough/uneven terrain were factors in the accident.NTSB MIA94LA209Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Fort Pierce, FLThe pilot's inadequate compensation for wind conditions and premature lift-off. The crosswind was a factor.