NTSB investigations, 1993
304 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\") = 1993
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") = 1993 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 ATL94LA035Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mobile, ALAn inadequate major repair by company maintenance personnel who failed to install the cotter pin which secured the retaining nut of the right main rotor hub teeter pin.NTSB LAX94LA083Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Scottsdale, AZA failure of the pilot-in-command to adequately conduct a preflight inspection and properly secure a fuselage cowling panel that struck a tail rotor blade, resulting in a subsequent failure of the tail rotor drive system. Factors in this accident were an…NTSB CHI94FA050Accident · 3 fatalField investigationFinal reportMitsubishi MU-300 · Goodland, KSThe pilot-in-command's inadvertent stall of the airplane. A factor associated with the accident is the pilot-in-command's poor IFR procedures.NTSB ANC94LA025Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7AC · Circle City, AKThe pilot in commands intentional flight into known adverse weather conditions which lead to an inadvertent aerodynamic stall of the aircraft. Factors contributing to the accident were the ice fog and the icing conditions.NTSB LAX94LA069Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Chandler, AZThe flight instructor's failure to properly follow the aircraft ballasting procedures that resulted in a loss of control when the helicopter's center of gravity limits were exceeded. Inadequate supervision of the training flight was a factor in the accident.NTSB NYC94LA034Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's inability to control the airplane due to alcoholic impairment.NTSB NYC94LA031Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Millbrook, NYThe student pilot's failure to maintain direction control which resulted in an inflight collision with trees. Factors were the student pilot's improper recovery from a bounced landing and his inexperience.NTSB NYC94FA033Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · New Haven, CTThe pilot's failure to maintain control of the airplane during a night approach in adverse weather conditions. Factors which contributed to the accident were the weather conditions and dark night. In addition, the radar controller's vectoring of the pilot to…NTSB MIA94FA034Accident · 1 fatalField investigationFinal reportCessna 150J · Delray Beach, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented, and subsequent in-flight collision with the ocean. Contributing to the accident was the dark night with no visible horizon.NTSB LAX94FA065Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Payson, AZImproper in-flight planning/decision by the pilot, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: pilot impairment from improper use of prescription drugs (not approved for…NTSB LAX94LA064Accident · No injuriesLimited investigationFinal reportBraegger GL Nieuport 17 · Chandler, AZwas the pilot's improper handling of the airplane, and his failure to maintain control during his first attempted takeoff. Contributing factors were the pilot's inadvertent porpoising on the runway, and his lack of familiarity with the airplane's flight…NTSB ANC94LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Napakiak, AKThe pilot-in-command's failure to maintain proper approach airspeed.NTSB NYC94FA028Accident · 2 fatalField investigationFinal reportPiper PA-31T · Norwich, OHThe pilot's loss of aircraft control for an unknown reason, and subsequent flight that exceeded the design stress limits of the airplane, which resulted in an in-flight airframe breakup.NTSB CHI94LA043Accident · Serious injuriesLimited investigationFinal reportCleveland Piel Emeraude CP-304 · Warrensburg, MOthe intentional entry of a stall/spin by the student pilot.NTSB MIA94FA031Accident · 1 fatalField investigationFinal reportMooney M20E · Jacksonville, FLFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall. A factor related to the accident was: the lack of altitude for recovery from a stall.NTSB MIA94FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Daytona Beach, FLLoss of aircraft control for an undetermined reason.NTSB LAX94FA278Accident · 2 fatalField investigationFinal reportMooney M20K · June Lake, CAThe pilot allowed the airplane to exceed its design limits (airspeed and/or stress limits) after inadvertently entering a descent. Factors relating to the accident were: darkness (night or late dusk), the pilot's failure to assure adequate…NTSB CHI94LA040Accident · Minor injuriesLimited investigationFinal reportSteven Ulrich Challenger II · Escanaba, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.NTSB FTW94LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's improper flare.NTSB LAX94LA060Accident · Serious injuriesLimited investigationFinal reportAlbrecht Polywagon · Vacaville, CAthe pilot's failure to maintain control of the aircraft during a go-around. Factors in the accident were the wind shear conditions and the pilot's failure to adequately balance the fuel load during the flight.NTSB LAX94FA058Accident · 3 fatalField investigationFinal reportSiai-Marchetti F-260 · Santa Monica, CAthe dual student pilot's failure to maintain minimum air speed in flight which resulted in an inadvertent stall/spin. Contributing to the accident was the improper weight and balance, inadequate altitude, and inadequate supervision.NTSB FTW94FA038Accident · 2 fatalField investigationFinal reportCessna T303 · Rogers, ARThe pilot's continued flight into known adverse weather conditions, and the ensuing inadvertent stall. Factors were the icing conditions, the fog, the drizzle, the dark night light conditions, and the pilot's disregard for the forecasted weather conditions.NTSB BFO94FA017Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Ravenna, OHThe pilot attempted to fly the airplane with known deficiencies in the attitude indicator and became spatially disoriented during the takeoff climb. Factors in the accident were the low ceiling, night conditions, and an inaccurate attitude indicator.NTSB LAX94FA056Accident · 2 fatalField investigationFinal reportCessna 172M · Julian, CAThe pilot's failure to maintain aircraft control. Factors in this accident were: 1) the dark night and lack of ambient light which resulted in the pilot inadvertently flying from visual meteorological conditions into instrument meteorological conditions; 2)…NTSB ATL94LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kinston, NCWas the student pilot's failure to maintain aircraft control during the go around. A factor was the wind gusts which occurred at the time of the accident.NTSB ATL94LA019Accident · Serious injuriesLimited investigationFinal reportBell-Carson 47G-SUPER C-4 · Eufaula, ALThe pilot's failure to maintain aircraft control. A factor was the pilot's limited helicopter flight experience.NTSB MIA94LA021Accident · Serious injuriesLimited investigationFinal reportVacey MK-1 · Altoona, FLThe pilot-in-command's failure to maintain airspeed (VS) on initial takeoff climb while maneuvering to avoid power lines, resulting in an in-flight loss of control (stall) and subsequent in-flight collision with terrain.NTSB BFO94LA023Accident · 1 fatalLimited investigationFinal reportQuicksilver MX · Montville, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin.NTSB LAX94FA048Accident · 4 fatalField investigationFinal reportBeech V-35 · Shaver Lake, CAAn in-flight breakup of the airplane following the pilot's continued VFR flight into IMC conditions during which directional control of the airplane was not maintained, and the design limits of the airplane were exceeded. The pilot's inadequate evaluation of…NTSB BFO94FA005Accident · 2 fatalField investigationFinal reportCessna 152 · Walkersville, MDImproper planning/decision by the instructor pilot (CFI) by teaching stalls and slow flight to a pre-solo student on a dark night, and the instructor's failure to maintain (or regain) control of the airplane, due to spatial disorientation. Factor's related to…NTSB SEA94GA024Accident · Minor injuriesFinal reportCessna 182R · Salt Lake City, UTThe pilot in command's maintaining inadequate altitude while crossing over the ground track of the landing Boeing 757. A factor contributing to the accident was wake turbulence.NTSB FTW94FA028Accident · 3 fatalField investigationFinal reportCessna 182P · Marlow, OKAn inoperative vacuum system, an inoperative turn & bank indicator, and an inoperative directional gyro, which resulted in an inability of the pilot to control the airplane after it encountered instrument meteorological conditions (IMC). Factors related to…NTSB SEA94LA026Accident · 1 fatalLimited investigationFinal reportBird RAF-2000 · Redmond, UTThe pilot in command's exceeding the proper climb rate. A factor contibuting to the accident was the pilot's lack of experience in make/model.NTSB FTW94FA025Accident · 2 fatalField investigationFinal reportCessna 152 · Van Horn, TXWas the pilot's attempt to perform aerobatics at low altitude and the inadvertent stall. A factor was the pilot's ostentatious display.NTSB CHI94MA032Accident · 5 fatalMajor investigationFinal reportCessna 421B · Greensburg, INan inadvertent stall by the pilot in command. Factors associated with the accident are the icing conditions and low ceilings.NTSB NYC94FA025Accident · 1 fatalField investigationFinal reportMooney M20K · Blue Ash, OHThe pilot's inadequate inflight decision to conduct flight into known icing conditions and his failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were icing conditions and the pilot's failure to follow the preflight briefing…NTSB FTW94LA022Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Gulf Of MexicoThe pilot in command's inadequate preflight inspection in that he failed to remove a tie down rope. A factor was the pilot's self-induced pressure.NTSB CHI94LA027Accident · No injuriesLimited investigationFinal reportCessna 170B · Maple Plain, MNThe pilot's improper compensation for wind conditions, failure to maintain runway alignment, and failure to maintain adequate airspeed during the aborted landing. Factors related to the accident were: high obstructions and the adverse wind conditions.NTSB FTW94LA019Accident · Minor injuriesLimited investigationFinal reportBell 206B · High Island 467Were the pilot's inadequate preflight inspection and his failure to remove all of the aircraft tie-downs.NTSB NYC94LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Bowling Green, OHThe flight instructor's inadequate supervision of an attempted go-around by the student pilot which resulted in a loss of control and subsequent impact with the terrain. Factors were noncompliance with published procedures.NTSB NYC94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Griswold, CTThe pilot's inadequate compensation for wind conditions during takeoff, and the subsequent loss of control and collision with trees. A factor related to the accident were the adverse winds.NTSB FTW94LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Woodville, TXFailure of the pilot in command to maintain control of the aircraft during an aborted landing.NTSB NYC94LA013Accident · Serious injuriesLimited investigationFinal reportCessna C-150 · Cynthiana, KYThe pilot's abrupt control of the airplane on short final to the runway, with the flaps retracted, which resulted in an inadvertent stall and the subsequent collision with the trees. A factor in this accident was the poor judgement of the student pilot to go…NTSB SEA94FA018Accident · 1 fatalField investigationFinal reportCessna 172K · North Bend, ORLoss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.NTSB ATL94FA007Accident · 4 fatalField investigationFinal reportBeech S-35 · Carrollton, GAWas the pilot's failure to maintain control of the airplane during a missed approach which resulted in a stall. A factor was the pilot's failure to follow IFR procedures.NTSB CHI94LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Belleville, MIwas wind information not used by the pilot-in-command and a resultant exceeding of the airplane's performance capabilities.NTSB NYC94FA011Accident · 2 fatalField investigationFinal reportCessna 310Q · Tiro, OHLoss of aircraft control for an undetermined reason, and subsequent flight that resulted in the stress limits of the airplane being exceeded and airframe failure.NTSB ATL94LA005Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Maryville, TNFailure of the pilot to maintain airspeed control, which resulted in a low altitude stall.NTSB NYC94LA009Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Skaneateles, NYThe pilot's inadequate preflight preparation which failed to adequately secure cargo, resulting control interference. A factor was the overgross weight condition of the airplane.NTSB FTW94LA011Accident · No injuriesLimited investigationFinal reportCessna 172F · Co. Springs, COAn encounter with wake turbulence during the landing flare. A factor was lack of total pilot experience.