NTSB investigations, 1990
359 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\") = 1990
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") = 1990 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 MIA91FA058Accident · Serious injuriesField investigationFinal reportCessna 310 · New Smyrna Bch, FLThe pilot-in-command/mechanic reversal of the aileron control cables on the sprocket during installation. This resulted in an in flight loss of control on takeoff, uncontrolled descent, and in flight collision with terrain.NTSB LAX91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yucca Valley, CAThe pilot's improper use of the flaps. Contributing to this accident was the loss of control during tailwind landing, and his tailwind and the pilot's inadequate inflight planning.NTSB CHI91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MIThe pilot-in-command (CFI)'s inadequate supervision of the dual student.NTSB LAX91LA053Accident · 2 fatalLimited investigationFinal reportCessna T210N · Douglas, AZAn inflight loss of control of the airplane due to the pilot's physical impairment from the consumption of alcohol. A factor which contributed to the accident was an inoperative vacuum system.NTSB MIA91LA047Accident · No injuriesLimited investigationFinal reportCASA C-212-200 · San Juan, PRLoss of control while flaring to land due to undetermined reasons.NTSB NYC91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJImproper recovery from a bounced landings.NTSB NYC91LA049Accident · No injuriesLimited investigationFinal reportRobinson R22 · West Kingston, RIThe pilot's failure to maintain directional control. Contributing was the malfunction of the pedal assembly.NTSB NYC91LA048Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Nw Philadelphia, OHThe failure of the pilot to maintain airspeed during an attempted go-around which resulted in an inadvertent stall. Factors related to the accident were: improper use of the mixture control and carburetor heat.NTSB LAX91LA055Accident · 1 fatalLimited investigationFinal reportCessna 150G · Fresno, CAThe pilots intentional flight into known adverse weather conditions and his failure to maintain control of the aircraft. Factors in the accident were: the foggy weather conditions; spatial disorientation; and the pilot's over confidence in his own personal…NTSB CHI91LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Austin, MNThe pilot-in-command (student)'s failure to properly evaluate and compensate for gusty wind condiitons and to maintain directional of the aircraft during initial climb. Contributing was the student pilot's lack of total experience and wind gusts.NTSB MIA91LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Jacksonville, FLFailure to maintain aircraft control after intentional flight into known adverse weather conditions.NTSB ANC91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kongikank, AKThe pilot in command's failure to maintain airspeed during approach resulting in an inadverrtent stall annd uncontrolled descent into the ground.NTSB ATL91FA025Accident · 1 fatalField investigationFinal reportCessna 150J · Ripley, TNPerforming a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.NTSB SEA91LA030Accident · 1 fatalLimited investigationFinal reportRobinson Wenoso · Olympia, WAThe inadvertant stall/spin and loss of aircraft control by the pilot in command while performing aerobatic maneuvers.NTSB BFO91LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Mitchellville, MDFailure of the student pilot to maintain control of the aircraft, and inadequate supervision by the instructor pilot (CFI). Factors related to the accident were: inadequate preflight of the aircraft by the pilot(s) and in-flight opening of the door.NTSB CHI91LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Portage, WIDelayed go-around and stall encountered. Contributing factors were a snow bank, proper alignment not attained, and raising the flaps not performed by the PIC.NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.NTSB SEA91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Seattle, WAThe pilot's failure to maintain airspeed while on an instrument approach under instrument meteorlogical conditions, resulting in the aircraft stalling and enter a spin.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.NTSB CHI91FA033Accident · 2 fatalField investigationFinal reportCessna 150K · Valley Center, KSContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: darkness, adverse weather conditions, and the…NTSB DEN91LA023Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Clifton, TXInadvertent stall. Factors were: tailwind, wrong runway selected, and failure to raise flaps.NTSB ANC91FA014Accident · 1 fatalField investigationFinal reportCessna 170 · 40 W Of Clear, AKThe non-instrument rated pilot-in-command's loss of control while attempting to operate under visual flight rule while in instrument meteorological conditions. Contributing to the accident was the whiteout condition created by the vast expanse of white lake…NTSB LAX91FA037Accident · 1 fatalField investigationFinal reportRobinson R22Beta · Simi Valley, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the tailboom and cockpit.NTSB FTW91LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Mount Ida, ARThe pilot in command's failure to compensate for the adverse wind conditions which resulted in a loss of control on touchdown. A factor was the gusty crosswind.NTSB FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.NTSB NYC91FA034Accident · 2 fatalField investigationFinal reportCessna 172M · Perham, METhe pilot initiating flight into known icing conditions which resulted in an accumulation of airframe ice and a failure to maintain airspeed. The contributing factor was the existing icing conditions.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB SEA91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Kamiah, IDThe pilot's inadequate compensation for the wind conditions.NTSB FTW91FA016Accident · 1 fatalField investigationFinal reportMBB BO 105CB4 · Cameron, LAThe company's maintenance personnel's failure to install the cyclic interconnect tube and their failure to inspect the helicopter prior to flight.NTSB NYC91LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Caldwell, NJPremature rotation and an inadvertent stall. Factors include lack of total experience in this type of aircraft.NTSB CHI91DCQ01Accident · 1 fatalFinal reportRobert Bressler Pitts S-1E · St. Francis, KSThe failure of the pilot to maintain aircraft control.NTSB FTW91DRG01Accident · 1 fatalFinal reportTaylor Titch MK III · Seguin, TXThe pilot lost control at low level. Factors were the pilot attempting aerobatic maneuvers with insuffient altitude for recovery.NTSB LAX91LA034Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-B · Kahului, HIThe pilot's inadvertent deactivation of the helicopter's hydraulic boost system and his improper remedial action thereafter to the inflight situations which he created. A contributing factor was related to the manufacturer's inadequate location and design…NTSB LAX91LA029Accident · No injuriesLimited investigationFinal reportCessna 150F · San Diego, CAThe failure of the student pilot to maintain an adequate airspeed while maneuvering in the traffic pattern; maintain control of the aircraft and the inadvertent stall mush. A factor in the accident was the pilot's limited total expereince.NTSB MIA91GA025Accident · 3 fatalFinal reportBeech A-90 · Crestview, FLThe pilot-in-command/cfi improper supervision of the dual student. This resulted in an in flight loss of control, and collision with terrain for failure to maintain minimum control airspeed (VMC) while conducting a simulated emergency procedure.NTSB DEN91FA017Accident · 4 fatalField investigationFinal reportCessna T210L · Aspen, COImproper planning/decision by the pilot and his failure to maintain adequate airspeed, while turning over high terrain beside the airport, which resulted in an inadvertent stall. Factors related to the accident were: excessive gross weight of the aircraft,…NTSB ATL91IA016Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Memphis, TNThe pilot's failure to follow approved procedures for troubleshooting inflight maintenance problems and improperly used the flight and engine controls.NTSB MIA91IA022Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · San Juan, PRThe improper use of aileron trim and the improper preparation for auto pilot disconnect by the flight crew combined with excessive forces applied by the aileron trim system resulting in a departure from controlled flight. Contributing factors to the incident…NTSB NYC91DNC02Accident · Serious injuriesFinal reportMarier Early Bird Jenny · Concord, NHThe failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall spin. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB CHI91DEM01Accident · 1 fatalFinal reportErcoupe 415C · Shelby, MIThe pilot's continued flight into IMC.NTSB FTW91LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Abilene, TXPilot's failure to compensate for gusty wind condition.NTSB LAX91FA020Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Solana Beach, CAThe inadvertent stall/spin. Factors in the accident were: the pilot's decision to allow the reporter passenger to fly the aircraft in a critical flight situation, his decision to allow the aircraft to descend to an altitude too low to allow for contingencies,…NTSB CHI91LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Greenfield, INA stall/spin encountered due to an improper go-around.NTSB MIA91LA019Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ormond Beach, FLFailure of the pilot to maintain proper airspeed during the approach to land.NTSB DEN91FA010Accident · 2 fatalField investigationFinal reportPiper PA-38-125 · Levelland, TXInadvertent stall/spin at an altitude insufficient to effect recovery.NTSB BFO91LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Amelia, VAThe pilot's improper in-flight planning/decision and his intere uphill runway and tailwind.NTSB ATL91FA005Accident · 1 fatalField investigationFinal reportPitts Special S-1 · Ocala, FLThe pilot experiencced spatial disorientation, lost control of the airplane during a spin maneuver and collided with the ground.NTSB MIA91FA011Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Everglades City, FLThe pilot's failure to maintain altitude and his spatial disorientation during a night takeoff over water.NTSB DEN91FA005Accident · Serious injuriesField investigationFinal reportBeech P35 · Aurora, COInadvertent stall. Factors were his decision to disregard in-flight weather advisories, continued flight into known adverse weather, and icing conditions and the flight into the known adverse weather.NTSB BFO91LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Indian Head, MDThe student pilot's failure to maintain adequate aircraft control during the landing flare/touchdown. Contributing factors are his lack of total flight experience and his improper technique when raising flaps during an attempted go-around.