NTSB investigations, 1999
263 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\") = 1999
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") = 1999 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 LAX00LA066Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot's decision to takeoff downwind and the subsequent failure to achieve translational lift before contact with the water.NTSB FTW00FA053Accident · 1 fatalField investigationFinal reportMooney M20K · Mcalester, OKThe pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.NTSB LAX00LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gualala, CAThe student pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall/mush and a collision with the ground.NTSB ANC00LA021Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Bethel, AKThe pilot's failure to remove frost from the airplane prior to flight, and an inadvertent stall/mush.NTSB FTW00FA052Accident · 2 fatalField investigationFinal reportBeech D95A · Boyd, TXThe instructor pilot's inadvertent stall/spin.NTSB MIA00GA057Accident · Serious injuriesFinal reportHughes OH-6A · Fort Myers, FLimproper maintenance inspection of the helicopter by unknown maintenance personnel, resulting in a worn control rod bearing being continued in service, and subsequent separation, resulting in an in-flight loss of control and a crash.NTSB FTW00LA048Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Brownsboro, TXThe loss of tail rotor effectiveness as a result of tail rotor vortex ring state.NTSB FTW00LA047Accident · Serious injuriesLimited investigationFinal reportBeech BE-95A · Big Lake, TXthe pilot-in-command's failure to maintain directional control of the airplane during the aborted landing. Contributing factors were the crosswind, turbulence, and the pilot's lack of total experience in the make and model of aircraft.NTSB CHI00LA049Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Georgetown, INthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the gusty tailwind condition and the low altitude at which the helicopter was hovering.NTSB DEN00FA028Accident · No injuriesField investigationFinal reportHughes 369D · Peyton, COan uncontrolled touchdown following entry into a "out-of-ground effect" hover. Factors were loss of tail rotor effectiveness, and the pilot's lack of recent experience in kind of aircraft and total experience in type of aircraft.NTSB CHI00FA042Accident · 2 fatalField investigationFinal reportCessna 210D · Saint Charles, MOthe aircraft control not maintained by the pilot and the pilot exceeded the design limits of the aircraft. The clouds and night conditions were contributing factors.NTSB FTW00LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Springhill, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of aircraft control. Factors were the gusty winds, and the pilot's inadequate weather evaluation.NTSB MIA00FA048Accident · 1 fatalField investigationFinal reportCessna U-3A · Brooksville, MSThe in-flight loss of control for undetermined reasons resulting in the collision with terrain.NTSB CHI00FA039Accident · 2 fatalField investigationFinal reportCessna 310N · Danville, ILAircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…NTSB NYC00FA047Accident · 4 fatalField investigationFinal reportBeech 58TC · Hasbrouck Hts., NJthe failure of the pilot to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin.NTSB DEN00FA025Accident · 1 fatalField investigationFinal reportCessna T210L · Elida, NMThe pilot's failure to maintain aircraft control for reasons undetermined. Factors were icing conditions and instrument failure, as reported by the pilot.NTSB CHI00LA036Accident · No injuriesLimited investigationFinal reportCessna 172M · Ava, MOthe improper in-flight decision made by the pilot. Factors to the accident were the charts/other manuals depicting the incorrect frequency, the dirt bank, and the rocks.NTSB MIA00LA038Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Palm Bch Garden, FLThe sailplane pilot's failure to comply with standard emergency procedures for 'sailplane release failure' upon its occurrence and his maneuvering of the sailplane while still tethered to the tow plane resulting in the inflight loss of control and engine…NTSB LAX00LA050Accident · No injuriesLimited investigationFinal reportRobinson R22 Mariner II · Minden, NVthe result of a foreign object contacting the tail rotor blade(s) while the aircraft was hover taxiing, which caused blade separation with subsequent loss of anti-torque (lateral) control.NTSB LAX00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Surprise, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff from a short and unimproved dirt road, which resulted in an inadvertent stall/mush condition and impact with the ground.NTSB DEN00FA021Accident · 2 fatalField investigationFinal reportPiper PA-18-125 · Afton, WYFailure of the pilot to remove frost from the wings prior to takeoff, causing an inadvertent stall/spin on initial climbout. Factors included exceeding the aircraft's certificated gross weight, and fog conditions.NTSB SEA00FA023Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK. I · Washougal, WAThe pilot's failure to ensure attainment of adequate airspeed prior to initiating a steep turn at low altitude, resulting in an accelerated stall. A factor contributing to the occurrence of the accident was the aircraft's low altitude. Factors contributing to…NTSB NYC00FA039Accident · 3 fatalField investigationFinal reportBeech S35 · Newark, NJThe pilot's failure to maintain aircraft control. Factors in the accident were failure of the horizontal situation indicator for undetermined reasons, and the pilot's use of inappropriate medication.NTSB NYC00LA034Accident · Serious injuriesLimited investigationFinal reportBates Kitfox · Westminster, MDThe pilot's failure to maintain aircraft control while maneuvering.NTSB LAX00LA038Accident · 1 fatalLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Avalon, CAThe pilot's in-flight loss of control due to physical incapacitation from sudden cardiac death secondary to an acute myocardial infarction.NTSB ANC00LA014Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Juneau, AKAn inadvertent stall. Factors in the accident were the instructor pilot's excessive angle of climb, and gusty wind conditions.NTSB FTW00FA035Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · New Orleans, LAthe pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.NTSB DEN00LA019Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · El Paso, TXAn uncommanded flight control input for undetermined reasons resulting in rotor blade contact with the ground and subsequent loss of control.NTSB ANC00LA015Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Dillingham, AKFailure of the pilot to remove frost from the wings prior to flight, and the resulting inadvertent stall/mush.NTSB CHI00LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-34 · East Lynne, MOinadequate airspeed and a subsequent stall. Factors associated with the accident were the tailwind, the pilot's misjudgment of the wind condition, and poor inflight planning.NTSB ATL00LA014Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ridgeland, SCThe pilot's failure to obtain/maintain adequate airspeed during the takeoff/initial climb which resulted in an inadvertent stall and subsequent collision with terrain.NTSB CHI00LA025Accident · No injuriesLimited investigationFinal reportMancini Vans RV-4 · North Platte, NEaircraft control not being maintained by the pilot. A factor to the accident was the crosswind weather condition.NTSB NYC00LA026Accident · Minor injuriesLimited investigationFinal reportBailey Exec 162F · Pottstown, PAThe student pilot's loss of control of the helicopter, his lack of recent experience, his lack of total experience, and his overconfidence in his personal ability. A factor in the accident was the student pilot's disregard of regulations.NTSB MIA00FA019Accident · 1 fatalField investigationFinal reportCessna 152 · Tamarac, FLthe pilot's failure to maintain airspeed resulting in the airplane stalling and entering a spin to the left at an inadequate altitude and his failure to apply spin recovery emergency procedures prior to the airplane impacting the swamp.NTSB NYC00LA022Accident · 1 fatalLimited investigationFinal reportGodbout Exec 162F · Milan, NHThe pilot's failure to maintain proper rotor rpm while maneuvering, which resulted in main rotor blade flapping, and its subsequent impact with the tail boom. A factor was the pilot's lack of experience in maneuvering flight.NTSB NYC00LA019Accident · No injuriesLimited investigationFinal reportParsons Rans S-12 · Gainesville, VAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI00LA008Accident · No injuriesLimited investigationFinal reportCessna 150F · East Troy, WIthe pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.NTSB DEN00FA005Accident · 1 fatalField investigationFinal reportWatkins Christen Eagle · Brigham City, UTThe pilot's inability to maintain aircraft control due to an unknown physical impairment.NTSB NYC00LA012Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Whiting, VTThe pilot's inadequate preflight passenger briefing, which resulted in control interference.NTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.NTSB CHI00FA006Accident · Serious injuriesField investigationFinal reportDassault DA-900B · Holland, MIThe copilot's improper use of the autopilot system while leveling the flight from descent, resulting in an inadvertent pilot-induced pitch oscillation of the airplane. A factor was the flight attendant not wearing a seat belt at the time of the occurrence.NTSB LAX00TA006Accident · No injuriesFinal reportMcDonnell Douglas 369E · Moreno Valley, CAThe failure of the pilot to maintain sufficient forward airspeed to preclude an inadvertent encounter with loss of tail rotor effectiveness, which resulted in a loss of yaw control. The pilot's failure to initiate timely remedial action is a factor.NTSB FTW00LA008Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Bay City, TXThe pilot's inadvertent stall. A factor was the pilot's encounter with the airplane's wake turbulence.NTSB LAX00LA003Accident · Serious injuriesLimited investigationFinal reportGiles G-750 · Salinas, CAthe pilot's failure to maintain an adequate airspeed while maneuvering, which led to a stall/mush condition.NTSB FTW00FA001Accident · 2 fatalField investigationFinal reportCessna P210N · Spicewood, TXThe pilot's delayed application of full throttle during a go-around, which resulted in a slow airspeed and inadvertent stall/spin. A factor was the pilot's habit of only applying partial power during takeoff.NTSB CHI99LA349Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Detroit, MIthe pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.NTSB CHI99LA353Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Gran Marais, MNthe downwind turn, stall, mush, due to the pilot's decision to turn and failure to maintain flying speed.NTSB ATL99FA135Accident · 2 fatalField investigationFinal reportNorth American T-6-SNJ-5 · Nashville, TNThe pilot's failure to maintain flying speed which resulted in a stall and the loss of control. A factor was pilot impairment due to the use of drugs.NTSB DEN99LA169Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Animas, NMA inadvertent stall during initial climb following takeoff. Factor were: high gross weight, high density altitude, inadequate preflight planning and preparation, and soft terrain.NTSB CHI99FA346Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Scott, KSthe failure of the pilot to maintain control of the aircraft. Factors were the pilot's lack of total experience, his lack of familiarity with the airplane, and the stall/spin encountered.