NTSB investigations, 2006
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
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\") = 2006
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") = 2006 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 DFW07CA048Accident · No injuriesData collectionFinal reportCessna 172S · Spicewood, TXThe pilot's failure to compensate for the existing wind conditions resulting in a loss of directional control. Factors were the gusty crosswind and the muddy terrain.NTSB LAX07LA081Accident · No injuriesLimited investigationFinal reportCessna 140 · Van Nuys, CAFailure of the pilot under instruction to maintain directional control of the airplane and the flight instructor's inadequate supervision.NTSB DFW07CA046Accident · No injuriesData collectionFinal reportCessna 172M · Houston, TXThe pilot's failure to compensate for the existing wind conditions during the landing roll resulting in a loss of control. A contributing factor was the crosswind.NTSB SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.NTSB SEA07CA033Accident · Minor injuriesData collectionFinal reportExtra Flugzeugbau EA 300/L · Boulder City, NVThe pilot-in-command's failure to maintain directional control of the airplane during takeoff.NTSB SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.NTSB CHI07LA034Accident · No injuriesLimited investigationFinal reportCessna 172R · Lake in the Hil, ILThe directional control not maintained/obtained by the pilot, and the lack of recent experience by the pilot. The snow bank was a contributing factor.NTSB MIA07CA025Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Miami, FLThe failure of the pilot to maintain directional control during the landing roll resulting in a ground loop, and subsequent wing contact with the runway.NTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.NTSB DEN07LA030Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Steamboat Springs, COThe inadequate design of the engine mount, which caused an uncommanded left turn, loss of directional control, and impact with snow-covered terrain. Contributing to the accident was the low nose gear tire pressure.NTSB CHI07CA030Accident · No injuriesData collectionFinal reportAviat A-1B · St Louis, MOThe pilot's failure to maintain directional control during landing which resulted in the wing striking the ground during the inadvertent ground loop.NTSB SEA07LA023Accident · No injuriesLimited investigationFinal reportCessna 180K · Woods Cross, UTThe pilot's failure to maintain directional control during the takeoff roll. Factors include a ditch near the side of the runway.NTSB ATL07CA022Accident · No injuriesData collectionFinal reportCessna 172N · Reidsville, NCThe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an on ground collision with trees.NTSB CHI07CA029Accident · No injuriesData collectionFinal reportCessna 150J · South Haven, MIThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the ditch.NTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.NTSB CHI07CA031Accident · No injuriesData collectionFinal reportCessna 120 · Perryville, MOThe pilot's failure to maintain directional control during landing which resulted in an overload of the tailwheel attachment structure in the fuselage.NTSB DFW07CA028Accident · No injuriesData collectionFinal reportCessna 172N · Spring, TXLoss of directional control for undetermined reasons.NTSB LAX07CA042Accident · No injuriesData collectionFinal reportPippert Zenith CH-701 · Yerington, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain both directional and pitch control.NTSB ATL07CA020Accident · No injuriesData collectionFinal reportCessna 190 · Chattanooga, TNThe pilot's failure to maintain directional control on takeoff resulting in a collapse of the left main landing gear when the airplane swerved. A factor in the accident was wake turbulence from a landing airplane.NTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.NTSB MIA07TA017Accident · Minor injuriesFinal reportEurocopter AS 350 BA · Ft. Myers, FLThe pilot's failure to maintain aircraft control during engine start. Contributing to the accident was the pilot's improper advancement of the fuel control lever.NTSB CHI07LA024Accident · 1 fatalLimited investigationFinal reportMaule MX-7-180B · Edenville, MIThe pilot's loss of control during landing on a lake resulting in the amphibian aircraft flipping over inverted.NTSB DEN07CA023Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Fe, NMthe pilot's failure to maintain directional control during the landing roll, and his failure to maintain airspeed which resulted in a stall and hard landing.NTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.NTSB LAX07CA030Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Glendale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…NTSB CHI07CA014Accident · No injuriesData collectionFinal reportBellanca 7ECA · Eden Prairie, MNThe pilot not maintaining directional control of the tailwheel airplane during the landing roll. A factor was the runway sign that was impacted.NTSB DFW07CA015Accident · No injuriesData collectionFinal reportMaule M5 · New Braunfels, TXThe failure of the right main landing gear attachment during the landing roll, which resulted in a ground loop. A contributing factor was a crosswind.NTSB DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.NTSB ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.NTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB DFW07CA013Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Fredricksburg, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB ATL07CA008Accident · No injuriesData collectionFinal reportCessna CE-180-A · Statesville, NCThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with the runway.NTSB SEA07LA011Accident · No injuriesLimited investigationFinal reportSorensen Searey · Marysville, WAThe pilot's failure to identify an unsafe condition (strong tidal currents) prior to a water landing, which resulted in the airplane nosing over when the pilot was unable to maintain aircraft control.NTSB LAX07CA006Accident · No injuriesData collectionFinal reportHarry D. Miller Midget Mustang 1 · Reno, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB SEA07LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lebanon, ORThe pilot's failure to maintain directional control during the landing roll, resulting in the aircraft departing the runway and impacting a Visual Approach Slope Indicator (VASI) standard. The VASI standard near the side of the runway was a factor.NTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.NTSB SEA07CA003Accident · No injuriesData collectionFinal reportCessna T182T · Spokane, WAThe pilot's excessive braking which resulted in a loss of aircraft control during the landing roll. A taxiway sign was a factor.NTSB DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.NTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.NTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.NTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.NTSB ATL06CA132Accident · No injuriesData collectionFinal reportCessna 180K · Mooresville, NCThe pilot's failure to maintain directional control during the takeoff roll which resulted in a ground loop.NTSB CHI06CA272Accident · No injuriesData collectionFinal reportBoeing A75N1 · Garrettsville, OHThe pilot's failure to maintain directional control during the takeoff roll. The bush and tree were factors to the accident.NTSB LAX06CA303Accident · No injuriesData collectionFinal reportCleberg Sportsman 2+2 GS-2 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB CHI06FA269Accident · 1 fatalField investigationFinal reportCessna 182Q · Cumberland, WIThe pilot's inadvertent attempt to land on water with the wheels down and his failure to verify the gear position prior to landing. Contributing factors were the inoperative gear system due to the open gear selector circuit breaker, which tripped for…NTSB SEA06CA186Accident · No injuriesData collectionFinal reportCessna 152 · Pembroke Pine, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the runway sign.NTSB SEA06CA187Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's failure to adequately compensate for wind conditions during the landing roll. A drainage ditch and wind were contributing factors.NTSB SEA06LA184Accident · 1 fatalLimited investigationFinal reportShimer One Design · Lake Wales, FLThe loss of control for an undetermined reason during the landing roll.