NTSB investigations, 1991
354 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
Latest 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\") = 1991
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") = 1991 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 CHI92LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Huntington, INPilot factor in that he failed to maintain flying speed in a turn which resulted in an inadvertent stall. Factors related to the accident are; icing conditions, hazardous weather advisory disregarded, flight into known adverse weather, and overconfidence in…NTSB NYC92FA053Accident · 3 fatalClass 1 · FieldFinal reportBeech 1900C · Block Island, RIThe instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…NTSB NYC92FA052Accident · 2 fatalField investigationFinal reportAeronca 7AC · Salisbury, CTThe pilot's failure to maintain airspeed while performing low altitude aerobatic maneuvers, resulting in a stall with insufficient altitude to recover. Factors related to the accident were the pilot's overconfidence in his ability to perform these maneuvers,…NTSB MIA92FA053Accident · Serious injuriesField investigationFinal reportCessna 172RG · Melbourne, FLThe flight instructor pilot in command's failure to maintain airspeed while demonstrating a power off approach to the student and his improper retraction of the wing flaps during go around from the approach resulting in an inadvertent stall and inflight loss…NTSB LAX92LA070Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Happy Camp, CAThe excessive nature of the maneuvers attempted by the pilot at a low altitude during the takeoff initial climb, the failure of the pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall, and inadequate altitude to perfrom…NTSB DEN92FA020Accident · 3 fatalField investigationFinal reportGrumman American AA-5A · Monte Vista, COAn inadvertent stall by the pilot in command at an altitude insufficient to effect recovery. Factors were: aircraft gross weight above maximum; physical impairment of the pilot; lack of total experience; lack of recent experience; and lack of experience in…NTSB MIA92FA051Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Rainbow Lake, FLThe pilot in command's improper inflight decision to divert her attention to other activities not related to the conduct of the flight. Contributing to the accident was the exceeding of the design limits of the airplane leading to a wing failure.NTSB LAX92FA067Accident · 2 fatalField investigationFinal reportCessna 152 · Ventura, CAThe failure of the pilot to maintain adequate altitude above the ground to recover from an inadvertent stall. Contributing to the accident was the pilot's handling of the aircraft specifically an excessive angle of attack which resulted in reduced airspeed…NTSB DEN92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Yuma, COThe pilot's failure to maintain aircraft control. Factors were: an improper flare and lack of total flight time.NTSB LAX92FA065Accident · 2 fatalField investigationFinal reportBeech 58P · Flagstaff, AZ**This report was modified on 4/21/2016. Please see the public docket for this accident for additional information.** the pilot's failure to maintain airspeed at low altitude, which resulted in a stall and loss of airplane control during a circling approach…NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.NTSB FTW92LA049Accident · Minor injuriesLimited investigationFinal reportKinkade E.5 Vans RV-4 · Alpine, TXInadvertent stall.NTSB FTW92FA048Accident · 1 fatalField investigationFinal reportCessna 182 · Santa Teresa, NMThe pilot's failure to maintain control. Factors were the dark night, pilot's apprehension, pilot's lack of instrument experience, spatial disorientation, poor instrument location, visual perception and inadequate cockpit lighting.NTSB SEA92LA028Accident · Serious injuriesLimited investigationFinal reportCessna C-172G · Jackson, MTLoss of control due to the pilot's failure to maintain proper airspeed. Factors relating to the accident were the improper flap setting, the high density altitude, mountainous terrain, lack of experience by the pilot, and downdrafft winds.NTSB ANC92FA083Accident · 1 fatalField investigationFinal reportPiper PA-31T3, T1040 · Ninilchik, AKUndetermined.NTSB NYC92LA046Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lockport, NYAn inadvertent stall during an attempted go-around by the second pilot. Factors related to the accident were improper use of the flight controls by both pilots and the second pilot's attempted control of the airplane.NTSB NYC92FA044Accident · 3 fatalField investigationFinal reportMBB BO-105CBS · De Ruyter, NYAn inflight collision with terrain after the pilot experienced spatial disorientation. Factors related to the accident were the night conditions, and the lack of visual cues.NTSB CHI92LA048Accident · 1 fatalLimited investigationFinal reportBeech A36 · Rensselaer, INThe pilot's improper aircraft handling which resulted in an inadvertent stall and descent. Factors related to the accident were the obscuration & icing conditions.NTSB MIA92LA041Accident · Minor injuriesLimited investigationFinal reportLogan GN-1 · Quincy, FLThe pilot's improper recovery from a bounced landing that caused the loss of control in flight. A contributing factor was the pilot's lack of total experience.NTSB CHI92FA037Accident · No injuriesField investigationFinal reportBeech G-18S · West Chicago, ILA result of the pilot in command's not maintaining directional control, an improper inflight decision, and improper remedial action once the loss of directional control was recognized by the pilot. Factors contributing to this accident are inadequate cargo…NTSB ANC92LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKThe certified flight instructor's (CFI) delay in initiating the go around. Contributing to the accident was the snow berm and dark night light condition.NTSB DEN92LA010Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Watkins, COFailure to maintain directional control of the airplane during landing flare. A factor was the crosswind condition that existed at the time of the accident.NTSB LAX92LA046Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Fremont, CAThe pilot-in-command's failure to maintain an airspeed above the stall speed. His over confidence in his personal ability, lack of familiarity with the aircraft, and his inadequate training in acrobatic flight were factors in the accident.NTSB FTW92FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Angleton, TXThe pilot's failure to maintain aircraft control. Factors were his lack of total instrument time, his VFR flight into instrument conditions and spatial disorientation.NTSB FTW92FA022Accident · 2 fatalField investigationFinal reportCessna 310C · Waller, TXThe loss of directional control as result of the velocity minimum control airspeed not being maintained. A factor was that the maneuver was initiated at an inadequate altitude too low for the pilot to recover.NTSB NYC92LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-36 · Erwinna, PAThe pilot rotated the glider prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were the pilot's total lack of experience in gliders, no experience in this type of glider, and improper trim…NTSB CHI92FA028Accident · 1 fatalField investigationFinal reportPiper PA28-236 · Valley Center, KSThe pilot's spatial disorientation, his loss of aircraft control, and his exceeding the aircraft's design limits. Factors in the accident were the pilot's disregard for directives and procedures, and his continued flight into known adverse weather.NTSB SEA92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe loss of control on takeoff by the pilot due to the improper flap setting, the premature liftoff and his failure to attain proper climb airspeed after takeoff.NTSB NYC92DGM01Accident · 1 fatalFinal reportWillkins-Wayne VARI-VIGGEN · Erie, PAThe pilot lost control of the airplane at too low an altitude to recover. Factors related to the accident were the pilot's low time and experience in this type of airplane.NTSB LAX92LA041Accident · Serious injuriesLimited investigationFinal reportBell 206B · Hilo, HIThe inadvertent encounter with a loss of tail rotor effectiveness phenomena and the resultant pilot inflight loss of control.NTSB SEA92FA016Accident · 1 fatalField investigationFinal reportBell 206B · Salt Lake City, UTThe pilot failed to maintain directional control. Factors to the accident were: inadeqaute remedial action, over confidence in personal ability, and lack of recent expereince.NTSB ANC92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's loss of control during final approach when his attention was diverted to trying to operate the vernier throttle. Contributing to the accident was the pilot's lack of familiarity with the aircraft and his failure to maintain directional control of…NTSB ANC92LA014Accident · No injuriesLimited investigationFinal reportCessna 170 · Whiskey Gulch, AKThe pilot's failure to maintain an airspeed above stalling during maneuvering flight. A factor relating to the accident was operating at an altitude inadequate in which to effect recovery.NTSB LAX92LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft after it settled back onto the runway following a premature takeoff rotation. A factor in the accident was the lack of total experience of the pilot.NTSB CHI92FA022Accident · 2 fatalField investigationFinal reportRockwell AC 690B · Milton, KSIncapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.NTSB LAX92LA031Accident · No injuriesLimited investigationFinal reportCessna T210L · Van Nuys, CAThe inadvertent loss of control during the initial climb after takeoff that resulted from the collapse of the rudder pedal because of a worn locking pin hole in the rudder pedal stowing system, which allowed the pin to disengage.NTSB NYC92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Beekmantown, NYAn inadvertent stall due to the pilot's decision to prematurely retract the wing flaps. A factor related to the accident was the lack of altitude for recovery.NTSB NYC92LA021Accident · No injuriesLimited investigationFinal reportRobinson R22B · Millville, NJThe pilot's failure to maintain control of the helicopter. A factor related to the accident was the pilot's improper compensation for wind conditions.NTSB ATL92FA019Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Darden, TNThe pilot's failure to maintain control of the airplane. The pilot exceeded the design limits of the airframe.NTSB MIA92LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper flare & failure to recover from a ballooned landing.NTSB CHI92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bellaire, MIThe pilot's improper remedial action after ballooning during a landing flare. Factors associated with the accident are gusty crosswinds and the pilot's lack of total experience.NTSB LAX92LA026Accident · 2 fatalLimited investigationFinal reportGlassair III · Scottsdale, AZThe certified flight instructors decision to fly into known forecast weather conditions specifically prohibited by the airplane's owner's manual and decision to allow an unqualified pilot with limited instrument flight experience to occupy the left seat…NTSB LAX92LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Chiriaco Summit, CAThe delayed actions of the pilot-in-command in selecting a go-around ND subsequent loss of directional control which resulted in the airplane drifting off the runway centerline and colliding with terrain. Contributing to the accident was failure of the pilot…NTSB MIA92FA017Accident · Serious injuriesField investigationFinal reportCessna 152 · Valkaria, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented and an in-flight collision with terrain. Contributing to the accident was the pilot's decision to operate the airplane with known…NTSB ANC92LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain airspeed.NTSB ANC92LA010Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-6 · Chevak, AKThe high crosswind condition, the pilot in commands inability to compensate for the wind conditions, and his failure to follow company procedures and the procedures recommended in the aircraft flight manual. Factor relating to the accident was the captain's…NTSB FTW92LA013Accident · No injuriesLimited investigationFinal reportCessna 150M · Matagorda, TXThe pilot's failure to maintain adequate flying speed during the attempted takeoff.NTSB NYC92LA013Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov Lark I-28-B2 · Blairstown, NJAn improperly planned approach which resulted in an inadvertent stall with insufficient altitude for recovery. A factor related to the accident was improper use of the flight controls by the pilot.NTSB LAX92LA019Accident · 1 fatalLimited investigationFinal reportCessna 120 · Olancha, CAFailure of the pilot to maintain adequate airspeed resulting in an inadvertent stall while on final approach. Factors were the high density altitude and the pilot's poor approach planning.NTSB ANC92LA007Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Scammon Bay, AKThe pilot's failure to maintain airspeed during the aborted landing. Contributing to the accident was the unfavorable wind.