NTSB investigations, 1992
332 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\") = 1992
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") = 1992 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 MIA93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Jacksonville, FLThe pilot-in-command's failure to attain an adequate climb rate during the missed approach in IMC conditions. Contributing to the accident was the pilot's spatial disorientation.NTSB CHI93LA058Accident · No injuriesLimited investigationFinal reportBeech 90 · Dixon, ILThe instructor pilot not maintaining directional control following engine shut down and not performing remedial action of a power reduction to regain directional control, as prescribed by his company's training manual, once the airplane began to yaw/turn to…NTSB SEA93FA046Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Lester, WAUndetermined.NTSB LAX93LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · Oakland, CA1) The pilots failure to compensate for winds during the landing sequence, 2) the improper use of the flight controls by not maintaining directional control of the aircraft,and 3) the pilots failure to maintain an adequate airspeed during the landing phase…NTSB MIA93LA033Accident · Minor injuriesLimited investigationFinal reportMaule M-5-180C · Moultrie, GAThe pilot-in-command's failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control (stall) and subsequent in flight collision with terrain.NTSB CHI93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Kokomo, INFailure to maintain aircraft control, and spatial disorientation of the pilot.NTSB ATL93FA039Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Phenix City, ALThe pilot's failure to maintain control of the aircraft in instrument meteorological conditions. A factor was the pilots lack of total experience in instrument flight conditions.NTSB ATL93LA037Accident · 1 fatalLimited investigationFinal reportDonald Rhodes Moni 110 · Greenville, TNThe pilot's operation of the aircraft beyond its design stress limits.NTSB NYC93LA049Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Elmira, NYAn unstable touchdown which resulted in a rollover, inadequate supervision by the PIC, and failure of the PIC to take control of the helicopter in a timely manner. A factor related to the accident was the left seat pilot's lack of recent experience in…NTSB NYC93FA044Accident · 1 fatalField investigationFinal reportBeech 18T · Cleveland, OHThe improper installation of the elevator by company maintenance personnel and the lack of proper inspections by a company certified mechanic/inspector and the FAA certified mechanic with inspector authorization. A factor in this accident was an…NTSB LAX93FA066Accident · 2 fatalField investigationFinal reportPiper PA-31P · Oceanside, CAThe airplane colliding with the ocean due to unknown reason (s).NTSB SEA93FA035Accident · 2 fatalField investigationFinal reportCessna 421C · Wilsonville, ORThe pilot-in-command's failure to maintain control of the aircraft.NTSB FTW93FA051Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Forney, TXThe pilot's failure to maintain control of the helicopter as a result of his physical impairment due to alcohol. Factors contributing to the accident were: the dark night and the pilot's likely diversion of his attention from operating the helicopter.NTSB LAX93LA063Accident · No injuriesLimited investigationFinal reportHughes 269B · Kahului, HIFailure of the pilot to maintain adequate rotor RPM during downwind flight and adequate altitude to recover the loss of main rotor RPM before settling into the water. Contributing to the accident was the pilot's lack of rotorcraft flight experience.NTSB NYC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Williamson, NYThe pilot failed to provide adequate compensation for the wind conditions. A factor in this accident was the high gusting winds.NTSB ATL93FA030Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Pike Road, ALThe failure of the pilot in command to maintain airspeed during the initial climb, which resulted in an inadvertent stall and collision with the ground. Factors were the inadequate preflight planning and preparation of the pilot in command in that he operated…NTSB CHI93FA042Accident · 2 fatalField investigationFinal reportCessna 150L · Waldron, MOThe pilot's failure to maintain aircraft control.NTSB ATL93LA029Accident · Minor injuriesLimited investigationFinal reportChampion 7AC · Troy, TNThe pilot's inadequate preflight planning, his failure to attain a proper climb rate, and the inadvertent stalling of the aircraft while attempting to avoid high obstructions (trees). Factors were the rough, uneven runway conditions, the high obstructions,…NTSB MIA93LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLThe pilot in command's improper flare on landing which resulted in an in flight loss of control and collision with terrain.NTSB LAX93LA041Accident · 1 fatalLimited investigationFinal reportLitchford Falcon XP · Palm Springs, CAThe pilot's inflight loss of control for reasons related to the improper installation and functioning of the rudder control system, and, the pilot's inadvertent entry into a stall spin.NTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.NTSB ANC93GA020Accident · 2 fatalFinal reportPiper PA-18-150 · Beaver, AKThe pilot-in-command's failure to maintain airspeed which resulted in an inadvertent stall at an altitude inadequate to affect a recovery. Factors which contributed to the accident were: the overweight airplane, and the snow covered mountainous terrain.NTSB ANC93LA014Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Ekwok, AKThe pilot failed to maintain airspeed and inadvertently stalled the airplane. Contributing to the accident were the pilots improper in flight planning/decision, her intentional flight into known adverse weather, and the fog and icing conditions.NTSB FTW93FA033Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Dublin, TXImproper IFR operation by the pilot by descending under instrument meteorological conditions below the minimum altitude and the pilot's failure to maintain control of the airplane while maneuvering for a landing. Factors which contributed to the accident…NTSB BFO93FA001Accident · 1 fatalField investigationFinal reportPiper J5A · Lumberton, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and an uncontrolled descent at an altitude not possible for recovery.NTSB LAX93LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Reno, NVThe pilot's poorly planned approach, inadequate compensation for the existing winds, and failure to maintain airspeed. Contributing to this accident was the pilot's lack of total expereince and inadvertent stall.NTSB NYC93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mt. Gilead, OHPilot incapacitation due to carbon monoxide gas as a result of cracks in the heater muffler. A factor in the accident was the progressive deterioration of the left heater muffler.NTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.NTSB LAX93FA020Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Cottonwood, AZAn inadvertent stall and descent into terrain when the pilot failed to maintain sufficient airspeed and altitude above the ground.NTSB LAX93FA045Accident · 2 fatalField investigationFinal reportBeech D50A · Ely, NV1) The pilots decision to attempt VFR flight into instrument meteorological conditions, which included mountain obscurement and severe mixed icing, and, 2) his failure to maintain control of the aircraft due to a probable aerodynamic stall induced by severe…NTSB DEN93LA007Accident · 1 fatalLimited investigationFinal reportMarcy Kitfox IV · Longmont, COAn inadvertent stall. A factor was: the pilot's lack of familiarity with the airplane.NTSB CHI93LA018Accident · 1 fatalLimited investigationFinal reportAmerican Eagle 101 · New Hudson, MIThe pilot's failure to maintain aircraft control.NTSB CHI93LA021Accident · No injuriesLimited investigationFinal reportCessna C177B · Noblesville, INThe pilot's improper recovery from a bounced landing.NTSB SEA93LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sisters, ORThe pilot's poor inflight decision. Factors include mountainous/hilly terrain, trees, high density altitude, and downdrafts.NTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.NTSB LAX93LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe pilot's inadequate planned approach to the runway, and, his improper use of the flight controls which resulted in an inadvertent accelerated stall/spin.NTSB ATL93FA012Accident · 2 fatalField investigationFinal reportPiper PA-12 · Cedar Springs, GAThe private pilot's failure to maintain airspeed above stalling speed, and his failure to maintain a proper altitude, which resulted in an inadvertent, low altitude stall. A factor was the gusty wind condition at the time of the accident.NTSB ANC93LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Seward, AKThe pilots failure to maintain directional control on the ground. Contributing to the accident was the pilots failure to maintain airspeed during the takeoff climb, his inadequate training, his lack of total experience, and the ditch.NTSB CHI93LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Saline, MIThe pilot's failure to maintain aircraft control and airspeed.NTSB LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.NTSB NYC93LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Grove City, PAThe pilot raised the flaps prematurely, resulting in an inadvertent stall at to low an altitude to allow recovery.NTSB LAX93FA011Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Rosemead, CAThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the prevailing low ceiling and fog.NTSB CHI93LA008Accident · No injuriesLimited investigationFinal reportCessna 150M · Romeo, MIInadequate compensation for wind conditions by the pilot in command and failure to attain directional control of the airplane during landing flare and touchdown.NTSB NYC93FA013Accident · 1 fatalField investigationFinal reportCessna 195 · Shenandoah, PAA loss of control due to pilot incapacitation.NTSB DEN93LA003Accident · Serious injuriesLimited investigationFinal reportO'Connor SNO-BIRD XL · Bryan, TXDelamination of the rudder leading edge and subsequent jamming of the rudder.NTSB ATL93LA007Accident · 1 fatalLimited investigationFinal reportBensen B-8M · Holly Ridge, NCThe pilot's failure to operate the flight controls properly.NTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…NTSB ATL93LA009Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Centre, ALThe pilot's failure to maintain main rotor RPM, which resulted in an in flight loss of control and collision with terrain.NTSB NYC93LA011Accident · Serious injuriesLimited investigationFinal reportAnderson Pitts S-1 · Minersville, PAA loss of control due to a foreign object jamming the elevator flight controls.