NTSB investigations, 2002
245 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 332 |
|---|---|
| 1983 | 466 |
| 1984 | 438 |
| 1985 | 425 |
| 1986 | 370 |
| 1987 | 348 |
| 1988 | 369 |
| 1989 | 320 |
| 1990 | 359 |
| 1991 | 354 |
| 1992 | 332 |
| 1993 | 304 |
| 1994 | 323 |
| 1995 | 280 |
| 1996 | 263 |
| 1997 | 264 |
| 1998 | 281 |
| 1999 | 263 |
| 2000 | 274 |
| 2001 | 248 |
| 2002 | 245 |
| 2003 | 279 |
| 2004 | 237 |
| 2005 | 281 |
| 2006 | 249 |
| 2007 | 299 |
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\") = 2002
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\" = 250)
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") = 2002 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" = 250) 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 FTW03LA072Accident · No injuriesLimited investigationFinal reportBell 206-L4 · High Island 471The pilot's attempt to takeoff during known adverse weather conditions and failure to maintain control of the helicopter while maneuvering. Contributing factors were the gusty and high wind conditions.NTSB DEN03FA028Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Steamboat Spgs, COthe pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density…NTSB LAX03LA055Accident · 1 fatalLimited investigationFinal reportLipscomb Lancair 235 · Payson, AZthe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.NTSB FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.NTSB FTW03FA064Accident · 1 fatalField investigationFinal reportBeech BE-58 · Egypt, ARThe pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.NTSB ANC03GA020Accident · 1 fatalFinal reportAviat A-1B · King Salmon, AKThe pilot's failure to maintain adequate airspeed which resulted in an in-flight collision with terrain.NTSB CHI03FA041Accident · 1 fatalField investigationFinal reportCessna 208B · Rockford, ILThe pilot's failure to maintain control of the airplane during the ILS approach. Factors associated with the accident were the low ceilings, high winds, crosswind, and wind shear conditions that existed.NTSB LAX03LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fallon, NVThe pilot's failure to maintain control of the airplane during a low altitude maneuver. Contributing factors were the inadequate passenger briefing regarding the flight controls and the passenger's inadvertent use of the rudder.NTSB CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.NTSB ATL03FA023Accident · 2 fatalField investigationFinal reportCessna 150L · Arecibo, PRThe pilots failure to follow the normal takeoff checklist (Wing Flaps-Up) and failure to maintain airspeed after takeoff that resulted in an inadvertent stall.NTSB LAX03FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Phelan, CAthe student pilot's failure to maintain an adequate airspeed while maneuvering that lead to a stall spin and impact with flat desert terrain.NTSB DEN03LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350BA · Monticello, UTthe pilot's failure to maintain rotor rpm. A related factor was the presence of an object in the path during the touchdown.NTSB DEN03LA022Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Creede, COthe pilot's inadequate compensation for wind. Contributing factors are the crosswind and the pilot's lack of experience.NTSB ATL03LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain airspeed during an approach to land that resulted in an inflight collision with the runway. A factor was the crosswind condition.NTSB CHI03CA022Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Albion, MIA failure by the pilot to maintain sufficient airspeed while maneuvering. Contributing factors were the resulting stall/spin, the relatively low altitude and the soft terrain encountered.NTSB SEA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · La Grande, ORInadequate supervision and the premature raising of flaps before a positive climb was established.NTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.NTSB FTW03LA045Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Carrizo Springs, TXThe pilot's failure to maintain control of the helicopter after encountering dynamic rollover. A contributing factor was the deer pulling the aircraft unevenly.NTSB DEN03LA015Accident · No injuriesLimited investigationFinal reportCessna 150F · Logan, UTThe pilot's premature flare and his failure to maintain airspeed, resulting in a stall. A contributing factor was the dusk light conditions.NTSB LAX03LA026Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Chino, CAthe pilot's failure to understand his IFR clearance, which resulted in a diversion of his attention during the initial climb, and his failure to maintain control of the aircraft.NTSB CHI03LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Wheatfield, INThe pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.NTSB ANC03LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to adequately remove frost/ice from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb.NTSB IAD03LA015Accident · No injuriesLimited investigationFinal reportBell 206L1 · Albany, KYThe pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.NTSB FTW03LA038Accident · No injuriesLimited investigationFinal reportAgusta A109E · Fort Worth, TXThe pilot's attempted running takeoff with the power controls in the improper position.NTSB FTW03FA037Accident · 1 fatalField investigationFinal reportCessna 152 · Justin, TXThe pilot's failure to maintain airspeed which resulted in a stall.NTSB FTW03FA036Accident · 2 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Taos, NMThe pilot's inadvertent flight into mountain wave weather conditions while IMC, resulting in a loss of aircraft control.NTSB LAX03LA022Accident · Minor injuriesLimited investigationFinal reportLewis Barnett J4B · Vacaville, CAAn in-flight loss of control for undetermined reasons.NTSB FTW03FA027Accident · 3 fatalField investigationFinal reportAero Commander 500-B · Rayville, LAThe pilot-in-command's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB FTW03FA024Accident · 1 fatalField investigationFinal reportPiper PA-31T · Hobbs, NMThe pilot's loss of control while in instrument meteorological conditions during initial takeoff climb. Contributing factors were the prevailing clouds and fog.NTSB MIA03LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sebring, FLThe student pilot's premature rotation and failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall, an uncontrolled descent, and an impact with the ground.NTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.NTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.NTSB DEN03LA011Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Fort Collins, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airspeed resulting in a stall.NTSB LAX03FA013Accident · 3 fatalField investigationFinal reportPiper Aerostar 601 · Agua Dulce, CAthe pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush. The pilot's selection of the wrong runway for departure, considering the uphill gradient, the wind direction, and a takeoff path into rising terrain are…NTSB FTW03LA018Accident · No injuriesLimited investigationFinal reportCarriere RW-152 Scorpion II · Opelousas, LAThe pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.NTSB CHI03LA013Accident · 1 fatalLimited investigationFinal reportWondrasek Rans S-10 Sakota · Missouri Valley, IAThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A factor was the low altitude.NTSB FTW03LA015Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Edinburg, TXThe loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.NTSB LAX03FA008Accident · 1 fatalField investigationFinal reportCessna 150F · Julian, CAan in-flight loss of control for undetermined reasons.NTSB CHI03LA009Accident · Minor injuriesLimited investigationFinal reportDavis Early Bird Jenny · Scottsburg, INThe pilot not maintaining aircraft control. Factors to the accident included the pilot's lack of familiarity with the airplane, which resulted in an inadvertent stall/spin at a low altitude.NTSB ATL03FA002Accident · 1 fatalField investigationFinal reportBeech K35 · Jellico, TNThe pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.NTSB MIA03LA002Accident · 2 fatalLimited investigationFinal reportGolden RV6A · Tuskegee, ALthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB MIA03LA001Accident · 1 fatalLimited investigationFinal reportBowers Velocity SR6E · Valkaria, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB FTW03FA003Accident · 1 fatalField investigationFinal reportSocata TB-20 · Texarkana, ARThe inadvertamt stall by the student pilot, and the inadequate supervision by the flight instructor.NTSB CHI03FA003Accident · 1 fatalField investigationFinal reportPiper PA-18A · Garden City, KSThe inadequate preflight planning/preparation and visual flight rules flight into instrument meteorological conditions by the pilot. The clouds, mist, and night conditions were contributing factors.NTSB NYC03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Edgartown, MAThe pilot's inadequate in-flight evaluation of the landing facilities wind conditions, and inadequate airspeed resulting in a stall/mush. A factor related to the accident was the tailwind condition.NTSB CHI03LA001Accident · No injuriesLimited investigationFinal reportMooney M20J · Chicago, ILThe pilot's inadequate compensation for wind, and his failure to maintain directional control.NTSB NYC02LA198Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Circleville, OHThe pilot's failure to maintain adequate airspeed during the course reversal, which resulted in an inadvertent stall/spin.NTSB IAD02LA097Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Front Royal, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the airplane's proximity to the ground when the spin commenced.NTSB LAX02LA297Accident · Minor injuriesLimited investigationFinal reportPaige Kolb MK III · Fresno, CAthe student pilot's excessive rotation and failure to obtain/maintain adequate airspeed during takeoff, resulting in a stall.