NTSB investigations, 2003
240 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\") = 2003
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") = 2003 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 SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.NTSB LAX04CA082Accident · No injuriesData collectionFinal reportCessna 172N · Angels Camp, CAthe CFI's inadequate compensation for a crosswind condition, which resulted in the loss of directional control. The crosswind and wind gusts were factors.NTSB CHI04LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Wellington, KSThe pilot not maintaining directional control during the landing roll. Factors were the dry grass and the concrete box he encountered during his excursion off the runway.NTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.NTSB CHI04LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mountain Grove, MOImproper use of the brakes during landing by the pilot, resulting in failure of the left main landing gear tire and a loss of directional control. Contributing factors were the failure of the main landing gear, as well as the grass and the ditch adjacent to…NTSB FTW04LA049Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Amarillo, TXThe leakage of the left brake master cylinder cap, which resulted in the loss of hydraulic fluid and the failure of the left brake.NTSB MIA04FA035Accident · 2 fatalField investigationFinal reportCessna U206G · Thonotosassa, FLThe pilot's failure to retract the landing gear prior to landing on the water, resulting in a loss of control, and the airplane nosing over.NTSB LAX04CA070Accident · No injuriesData collectionFinal reportLuscombe 8E · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB SEA04LA028Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent group loop and the collapse of the right main landing gear.NTSB MIA04CA034Accident · No injuriesData collectionFinal reportWaco 4MF 5 · Marathon, FLThe pilot's loss of directional control during landing rollout in a crosswind resulting in the airplane ground looping and incurring damage to the left wing.NTSB LAX04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gilbert, AZthe pilot's failure to maintain control of the airplane during the landing touchdown in soft terrain. A contributing factor was the pilot's selection of unsuitable terrain for landing.NTSB LAX04CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Prescott, AZthe failure of the pilot to maintain directional control of the tail wheel equipped airplane during landing, which resulted in a ground loop.NTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.NTSB DEN04LA029Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Elbert, COthe pilot's failure to maintain directional control of the airplane. A contributing factor was his inexperience in aircraft type.NTSB LAX04LA058Accident · No injuriesLimited investigationFinal reportCessna 525 · San Diego, CAThe pilot's failure to maintain directional control and to initiate a timely go-around when visual contact with the runway was lost.NTSB LAX04LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Nogales, AZThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.NTSB ATL04CA041Accident · No injuriesData collectionFinal reportGlobe Swift GC1B · Southern Pines, NCThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop and the collapse of the landing gear.NTSB CHI04LA038Accident · No injuriesLimited investigationFinal reportCessna 340A · Poplar Bluff, MOFailure to maintain directional control during landing. Collapse of the nose landing gear, the muddy grass/turf and the berm were contributing factors.NTSB ATL04LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Hickory, NCThe CFI inadequate supervision, and failure to maintain directional control during the attempted touch-and-go landing.NTSB CHI04LA034Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Superior, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the ditch that the airplane contacted.NTSB LAX04LA044Accident · Minor injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Pacoima, CAThe student pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a sign and an unoccupied airplane.NTSB DEN04LA021Accident · No injuriesLimited investigationFinal reportCessna T210N · Johnstown, COThe pilot's failure to maintain directional control during the landing roll. Factors contributing to the accident were the gusting crosswinds.NTSB NYC04CA031Accident · No injuriesData collectionFinal reportPiper PA-18 · Westfield, MAThe pilot's failure to maintain aircraft control while landing.NTSB NYC04LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Montauk, NYThe pilot's loss of control after performing an evasive maneuver to avoid a deer crossing the unlit runway, which resulted in a collision with trees. Factors related to the accident were the nighttime conditions, the inoperative runway lighting system, and…NTSB ANC04LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight, and the student pilot's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the failure to the student…NTSB LAX04CA036Accident · No injuriesData collectionFinal reportR. James Thorne Nieuport 12 · Chandler, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB FTW04LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Amarillo, TXThe pilot's inadequate compensation for wind condition. Contributing factors were the pilot's lack of total experience in the make and model of aircraft, and the crosswind.NTSB DEN04LA022Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Truth or Conseq, NMthe pilot's inadequate flare and his failure to maintain directional control. A contributing factor was the night light conditions.NTSB LAX04LA033Accident · Serious injuriesLimited investigationFinal reportDavidson-Thorpe T-18 · Coalinga, CAthe pilot's improper recovery from a bounced landing, and hi failure to maintain directional control during landing rollout.NTSB CHI04LA024Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakota, NDThe student pilot not maintaining directional control during takeoff roll on a solo instructional flight. The factor to the accident was the wind gusts.NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB DEN04LA020Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA227BC · Rawlins, WYthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the pilot's improper in-flight planning/decision, the icy, snow covered runway and the snow bank.NTSB ATL04LA032Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lawrenceburg, TNThe pilot's failure to maintain directional control on landing rollout resulting in the airplane veering to the right and collapsing the left main landing gear with a side load.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.NTSB LAX04CA026Accident · No injuriesData collectionFinal reportPiper PA-20 · Petaluma, CAthe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control that resulted in a ground loop.NTSB LAX04CA023Accident · No injuriesData collectionFinal reportCessna 172M · Montague, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB NYC04LA015Accident · No injuriesLimited investigationFinal reportHarris BRC 540C · Leesburg, VAThe pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.NTSB NYC04LA012Accident · Serious injuriesLimited investigationFinal reportPreiss Vans RV-9A · Deshler, OHThe pilot's improper bounced landing recovery. Factor were the pilot's excessive airspeed at touchdown, and his improper use of the wing flaps, by lowering them at touchdown.NTSB SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.NTSB ATL04LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe student pilot's failure to maintain directional control on landing roll resulting in a collision with a ditch, and subsequent nose over.NTSB CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…NTSB LAX04LA103Accident · No injuriesLimited investigationFinal reportMooney 20F · Scottsdale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC04LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ketchikan, AKThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an inadvertent stall and a ground loop. A factor contributing to the accident was the loss of directional control on the ground.NTSB NYC04CA002Accident · No injuriesData collectionFinal reportLake LA250 · Laconia, NHThe pilot's improper starting procedure. A factor in the accident was the pilot's lack of recent experience in make and model airplane.NTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.NTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.NTSB ATL04IA002Incident · No injuriesIncident investigationFinal reportNorth American T6G · Clayton, GAThe pilot's inadequate compensation for wind conditions that resulted in his failure to maintain directional control during landing roll. A factor was gusting tailwinds.NTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.