NTSB investigations, 2005
228 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
Open the mapLatest 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\") = 2005
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") = 2005 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 LAX06LA073Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Boulder City, NVThe pilot's inadequate preflight inspection and failure to follow the airplane's checklist, which resulted in his failure to remove the gust lock prior to flight.NTSB LAX06CA074Accident · No injuriesData collectionFinal reportAvid Mark IV · California City, CAthe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane on takeoff.NTSB DFW06CA070Accident · No injuriesData collectionFinal reportBeech C23 · Eureka Springs, ARThe pilot's failure to maintain directional control while landing and his delay in aborting the landing.NTSB DFW06CA044Accident · No injuriesData collectionFinal reportChampion 7ECA · Fredericksburg, TXThe pilot's failure to maintain directional control on the landing roll-out. A factor was the crosswind.NTSB NYC06CA051Accident · No injuriesData collectionFinal reportPiper PA-22 · Jamestown, NYThe pilot's failure to maintain directional control during the landing rollout. Factors included the ice on the runway and the soft terrain.NTSB LAX06CA078Accident · No injuriesData collectionFinal reportWaco YMF-5C · Lihue, HIthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the aircraft on landing.NTSB DEN06CA027Accident · No injuriesData collectionFinal reportMaule M-7-235 · Moriarty, NMthe pilot's failure to maintain directional control during the landing. Contributing factors included the pilot's inadequate in-flight decision making and the high velocity, gusty winds.NTSB DEN06CA025Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Los Lunas, NMthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop.NTSB CHI06CA059Accident · No injuriesData collectionFinal reportCessna 150F · Poplar Grove, ILThe student pilot's inadequate recovery from the bounced landing, and not maintaining airplane control during the landing.NTSB ANC06CA012Accident · No injuriesData collectionFinal reportCessna 208 · Brevig Mission, AKThe pilot's inadequate compensation for crosswind conditions, which resulted in the left wing striking the ground while taxiing. A factor in the accident was a crosswind.NTSB NYC06CA043Accident · No injuriesData collectionFinal reportPiper PA-23-250 · State College, PAThe pilot's failure to maintain directional control during the takeoff run. A factor was the snow-covered runway.NTSB SEA06TA028Accident · Serious injuriesFinal reportAerospatiale SA-319B · Escalante, UTThe pilot's inadequate remedial action when ground resonance was encountered during landing. Contributing factors were the rough/uneven terrain and company inadequate maintenance.NTSB ANC06CA011Accident · No injuriesData collectionFinal reportCessna 208B · Newtok, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in the airplane exiting the runway, encountering snow, and the nose gear collapsing. Factors associated with the accident were the gusting wind and the icy runway.NTSB DEN06CA022Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSthe student pilot's improper decision to continue taxiing through the field. Contributing factor's include student pilot's failure to maintain control during the takeoff roll and the drainage ditch masked by snow.NTSB LAX06CA047Accident · No injuriesData collectionFinal reportNorth American P-51D · Minden, NVthe pilot's failure to maintain directional control on landing.NTSB CHI06CA042Accident · No injuriesData collectionFinal reportCessna 310Q · Pierre, SDThe pilot's failure to maintain control of the airplane during the landing roll due to the icy runway. Factors were the compacted snow and ice along the edges of the runway and at the taxiway intersection, and the snow banks adjacent to the runway and taxiway.NTSB ATL06CA020Accident · No injuriesData collectionFinal reportCessna 152 · Sanford, NCThe student pilot's failure to maintain directional control on landing roll out, resulting in the airplane going off the left side of the runway, colliding with a ditch, and nosing over inverted.NTSB SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB DFW06CA035Accident · No injuriesData collectionFinal reportCessna P206 · New Braunfels, TXThe pilot's improper compensation for the existing wind conditions resulting in a loss of control. A contributing factor was the gusty crosswind.NTSB SEA06LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Lopez, WAThe airline transport pilot, who was receiving recurrent training, failed to maintain aircraft control, which was followed by an inadvertent ground loop. A contributing factor was the inadequate supervision by the flight instructor.NTSB ANC06CA010Accident · No injuriesData collectionFinal reportCessna 180H · Anchorage, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane encountering a snow berm, and nosing over. A factor associated with the accident was the snow berm.NTSB LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB DFW06CA029Accident · No injuriesData collectionFinal reportAeronca 7DC · Saginaw, TXThe flight instructor's delayed remedial action. Contributing factors were the gusty winds.NTSB MIA06CA025Accident · No injuriesData collectionFinal reportPiper PA-12 · St. Petersburg, FLThe pilot's failure to maintain directional control during the landing roll resulting in substantial damage during a ground loop.NTSB DEN06CA012Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Watkins, COthe pilot's failure to maintain aircraft control during the landing resulting in a impact with a runway light and ground loop.NTSB DFW06CA026Accident · No injuriesData collectionFinal reportCessna 172N · Sherman, TXThe pilot's failure to maintain directional control during takeoff.NTSB ATL06CA012Accident · No injuriesData collectionFinal reportCessna 150 · Monroesville, ALThe pilot's failure to maintain directional control, which resulted in a loss of control and collision with trees.NTSB NYC06CA021Accident · Serious injuriesData collectionFinal reportCraig Sonerai II LT · Ashland, KYA loss of directional control during an emergency landing. A factor in the accident was an unlatched canopy requiring the pilot to hold it closed to maintain aircraft control.NTSB ATL06CA010Accident · Minor injuriesData collectionFinal reportRobinson Beta II · Lawrenceville, GAThe pilot's improper use of flight controls which resulted in a collision with a fence.NTSB LAX06CA022Accident · No injuriesData collectionFinal reportCessna T188C · Beatty, NVthe pilot's inadequate compensation for gusty wind conditions and failure to maintain directional control of the airplane on the landing roll.NTSB ATL06CA009Accident · Minor injuriesData collectionFinal reportSwing Brian S Quickie Q2 · Beaufort, SCThe pilot's failure to maintain directional control during the landing roll which resulted in a collision with an object.NTSB CHI06CA019Accident · No injuriesData collectionFinal reportPiper PA-12 · Brainerd, MNThe pilot's inadvertent brake application during the takeoff roll, which resulted in a loss of directional control and subsequent ground loop.NTSB CHI06LA086Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · St Marys, KSThe pilot not maintaining directional control of the airplane during the landing and the flight instructor's delayed remedial action. A factor was the standpipe the airplane impacted when the airplane exited the runway.NTSB CHI06CA017Accident · No injuriesData collectionFinal reportBellanca 7ECA · Cuba, MOThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB NYC06CA014Accident · Minor injuriesData collectionFinal reportBeechcraft BE-24R · Esperance, NYThe pilot's failure to maintain directional control during landing.NTSB NYC06CA013Accident · No injuriesData collectionFinal reportCessna 172K · West Milford, NJA loss of aircraft control as a result of the installation of an improper pilot seat which moved during the takeoff roll/run..NTSB MIA06CA011Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with runway signs.NTSB LAX06CA013Accident · Minor injuriesData collectionFinal reportPiper PA-23-160 · Upland, CAthe pilot's failure to maintain directional control during landing.NTSB LAX06LA017Accident · No injuriesLimited investigationFinal reportNorth American T-39A · Mojave, CAThe pilot's failure to maintain aircraft control during the landing roll. A wet runway surface was a factor.NTSB CHI06CA035Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Imperial, NEThe pilot not maintaining airplane control during the takeoff.NTSB ATL06CA005Accident · No injuriesData collectionFinal reportCessna 150M · Morgantown, NCThe student pilot's improper recovery from a bounced landing,resulting in a loss of directional control and nose over.NTSB DFW06CA004Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe pilot's failure to maintain directional control while landing.NTSB CHI06LA006Accident · No injuriesLimited investigationFinal reportBeech 19A · Jackson, MIThe student pilot's inadvertent porpoise during landing, which resulted in a loss of control and a collision with a sign.NTSB ANC06TA002Accident · No injuriesFinal reportAviat A-1B · Fairbanks, AKThe flight instructor's inadequate supervision of the dual student during the landing roll, which resulted in the dual student applying the brakes excessively, and the airplane nosing over. A factor associated with the accident was the excessive braking by…NTSB LAX05CA322Accident · No injuriesData collectionFinal reportCessna 172P · Reno, NVthe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB DEN05CA149Accident · No injuriesData collectionFinal reportCessna 206 · Brigham City, UTthe pilot's improper in-flight planning and decision making and failure to maintain aircraft control during the ground roll.. Contributing to the accident was the soft dirt.NTSB NYC05CA147Accident · No injuriesData collectionFinal reportCessna 182 · Southampton, NYThe pilot's failure to maintain directional control while landing.NTSB IAD05CA140Accident · No injuriesData collectionFinal reportBeech BE-36 · Farmingdale, NYThe pilot's improper recovery from a bounced landing.NTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.