NTSB investigations, 1989
320 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\") = 1989
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") = 1989 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 MIA90FA046Accident · 1 fatalField investigationFinal reportCessna 172N · Meridian, MSIn flight loss of control by the pilot while flying in instrument meteorological conditions. Contributing factor(s) was: the pilot's apprehension toward instrument flying and the adverse weather conditions that existed at the time.NTSB LAX90FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Santa Rosa, CAThe pilot's improper preflight planning/decision which resulted in the loss of tail rotor effectiveness. Contributing to the accident was the pilot allowing the maximum gross weight of the aircraft to be exceeded, and the tailwind.NTSB CHI90LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jenison, MIThe pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.NTSB ANC90LA022Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKImproper compensation for wind conditions by the pilot, which resulted in loss of aircraft control during takeoff, and subsequent impact with the water. The weather conditions were contributing factors.NTSB FTW90FA046Accident · Serious injuriesField investigationFinal reportBell 206L-1 · S Marsh Is 7The pilot's failure to recognize and correct a situation involving loss of tail rotor effectiveness, resulting in loss of aircraft control.NTSB MIA90LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Orlando, FLThe pilot's loss of control of the aircraft due to a loss of consciousness brought on by reactive hypoglycemia.NTSB DEN90LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Firestone, COPremature liftoff by the pilot which resulted in insufficient airspeed.NTSB ATL90LA043Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norcross, GAThe student pilot's improper execution of the landing procedure resulting in dynamic roll-over of the helicopter.NTSB ANC90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKFailure of the non-certificated Pilot to remove ice/frost from the wing(s) prior to flight. His lack of training and qualification were probable contributing factors.NTSB MKC90FA038Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Lynch, NEAirspeed was not maintained by the pilot resulting in a stall/spin.NTSB DEN90FA033Accident · 2 fatalField investigationFinal reportBeech B35-A33 · Castle Rock, COThe pilot's loss of control as a result of spatial disorientation. Factors related to the accident were: the adverse weather conditions.NTSB CHI90LA042Accident · No injuriesLimited investigationFinal reportBeech V35 · Cable, WIThe pilot's failure to adequately compensate for crosswind conditions. Contributing to the accident was the gusty, crosswind conditions which existed.NTSB CHI90FA040Accident · 4 fatalField investigationFinal reportCessna 172M · Linden, MIThe failure of the pilot to maintain sufficient speed for flight. A factor associated with the accident was the pilot's operation of the airplane above the maximum allowable gross weight.NTSB FTW90LA039Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stephenville, TXThe pilot's failure to maintain adequate airspeed during a go-around which resulted in a stall.NTSB MIA90LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLThe student pilot not obtaining the current wind information which resulted in selecting the wrong runway for landing; improper recovery from a bounced landing. Contributing factor(s) was: the student pilot's lack of experience and the tailwind conditions.NTSB LAX90LA042Accident · Minor injuriesLimited investigationFinal reportBell 47G-II · Rialto, CAThe pilot's loss of directional control and subsequent overcontrol while hovering. Contributing to the accident were the gusty wind conditions and the pilot's inexperience.NTSB DEN90FA030Accident · 2 fatalField investigationFinal reportBeech F-90 · Lincoln, NMLoss of control due to pilot disorientation while conducting a non precision instrument approach. Contributing to the accident was the pilot's lack of instrument and multiengine experience, and the existing adverse weather.NTSB MIA90FA033Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Orlando, FLLoss of aircraft control during takeoff for an unknown reason which resulted in a collision with the ground.NTSB CHI90DEE03Accident · 1 fatalFinal reportNelsen-David Sonerai II/EV · Huntley, ILPilot-in-command's failure to maintain airspeed during a turn at low altitude, resulting in an inadvertent stall and impact with terrain, lack of recent total experience and lack of total experience in type of aircraft.NTSB FTW90LA034Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Shawnee, OKFailure of the pilot to maintain adequate airspeed during the turn after takeoff, which resulted in a stall. The obstructions (trees) were a factor.NTSB ANC90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Eek, AKThe pilot's inadequate preflight planning/preparation and his failure to assure the removal of ice or frost from the wings. The excess gross weight and uneven terrain were considered to be contributing factors.NTSB FTW90FA032Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Arlington, TXThe pilot-in-command's loss of control in flight because of spatial disorientation. A factor was the dark night.NTSB FTW90FA037Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · La Junta, TXThe pilot's delayed remedial action to recover from the spin and his misjudging of altitude.NTSB CHI90FA026Accident · 1 fatalField investigationFinal reportCessna 172D · Mt Morris, ILVFR flight into IMC and spatial disorientation of the pilot. Contributing to the accident were the meteorological conditions and the overconfidence and lack of experience of the pilot.NTSB DEN90LA023Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Bryce Canyon, UTThe pilot's failure to attain adequate climb speed. Contributing factors were: inadequate preflight planning in that the pilot did not adequately consider the high density altitude effect on the airplane's climb performance.NTSB CHI90LA023Accident · No injuriesLimited investigationFinal reportPiper 601P · Cincinnati, OHThe pilot failed to maintain adequate airspeed while maneuvering to circle and land, which resulted in an inadvertent stall. Factors related to the accident were: the excessive maneuver (steep turn) and terrain conditions (road and curb) short of the runway.NTSB LAX90FA025Accident · 2 fatalField investigationFinal reportCessna 172 · Safford, AZThe pilot failed to maintain an airspeed above the aircraft's stall speed as he turned away from ascending terrain. The aircraft's inadequate performance resulting from improper grade of fuel and high density altitude and the pilot's lack of experience in…NTSB ATL90DKG01Accident · Serious injuriesFinal reportPond Midget Mustang · Cordele, GAImproper handling of the aircraft by the pilot, which resulted in his loss of control. His lack of experience in this type of aircraft was a related factor.NTSB MIA90LA023Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Loxahatchee, FLFailure of the pilot to maintain rotor RPM after pulling up from a swath run. A related factor was the presence of trees.NTSB CHI90DEG01Accident · 2 fatalFinal reportMccomb RV-4 · Eaton, OHPoor in-flight planning/decision by the pilot which resulted in spatial disorientation and an inadvertent spiral. Factors related to the accident were: the dark night and instrument lights not installed.NTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.NTSB BFO90FA003Accident · 2 fatalField investigationFinal reportCessna 177 · Mchenry, MDThe pilot's failure to obtain adequate takeoff airspeed as a result of an improper flap setting. Contributing factors were a takeoff with a tailwind, an upsloping runway, and high density altitude.NTSB ATL90LA018Accident · No injuriesLimited investigationFinal reportBeech A23A · Roopville, GAThe pilot's disregard for a tailwind during landing, his delay in executing a go around when he noted excessive speed during the landing roll, and improper go around procedures.NTSB ATL90FA017Accident · 1 fatalField investigationFinal reportCessna 150M · Carrollton, OHThe pilot failed to maintain adequate airspeed while maneuvering, which led to an inadvertent stall/spin. Contributing to the accident were the pilot's apparent desire to show off, and the low altitude at which he chose to perform the maneuver.NTSB NYC90LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Friendsville, PAThe pilot failed to maintain airspeed and stalled the aircraft.NTSB MIA90LA018Accident · Minor injuriesLimited investigationFinal reportBell 47G · West Palm Beach, FLThe pilot's inadequate compensation for wind conditions. Factors related to the accident were: the unfavorable and gusty wind conditions.NTSB CHI90LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Ravenna, OHThe pilot's failure to maintain aircraft control and airspeed which resulted in a stall. Factors related to the accident include the pilot overshooting the approach & landing due to misjudging his airspeed & distance, and a delayed go-around.NTSB FTW90DRG01Accident · Serious injuriesFinal reportFunk, D.D. B85C · San Antonio, TXFailure of the pilot to maintain airspeed, which resulted in a stall. The unfavorable/gusty wind condition was a related factor.NTSB MKC90LA018Accident · No injuriesLimited investigationFinal reportPierce MP-2 · Caledonia, MNThe pilots loss of control during recovery from bounced landing.NTSB FTW90LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Thibodaux, LAStudent pilot's failure to obtain or maintain airspeed during an aborted landing, which resulted in an inadvertent stall/mush. His failure to maintain runway alignment and the ditch were related factors.NTSB ATL90GA010Accident · Serious injuriesFinal reportHiller UH-12D · Mentor, OHImproper in-flight planning/decision by the pilot. Factors related to the accident were: the pilot's improper compensation for wind conditions and trees.NTSB MKC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charles City, IAThe pilot-in-command's failure to maintain adequate control of the aircraft during the landing phase coupled with the cfi's inadequate supervision during the instructional flight. The cfi's lack of familiarity with the accident aircraft was a contributing…NTSB ANC90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKFailure of the pilot to maintain of the aircraft while maneuvering.NTSB LAX90DUG01Accident · 1 fatalFinal reportMannon-Underwood JEANIE'S Teenie · Hemet, CAInadvertent stall experienced by the pilot and his lack of experience.NTSB DEN90LA009Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Del Norte, COThe failure of the pilot to maintain airspeed during climb resulting in an inadvertent stall.NTSB LAX90LA009Accident · Minor injuriesLimited investigationFinal reportLuscombe 8C · Casa Grande, AZPilot's inadequate compensation for adverse winds. Factors related to the accident were: the adverse wind conditions.NTSB LAX90DUJ04Accident · 1 fatalFinal reportRand Engineering KR-II · Eloy, AZThe failure of the pilot to maintain control of the aircraft, and his failure to discontinue the approach when it became evident that the gusting cross winds were exceeding the ability of the aircraft.NTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…NTSB FTW90LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195 · San Antonio, TXPilot's improper recovery from a bounced landing and subsequent stall of the aircraft.NTSB ATL90FA007Accident · 2 fatalField investigationFinal reportVultee BT-13 · Axis, ALThe aircraft inadvertently entered a stall, when the pilot/passenger had a heart attack. A factor related to the accident was: lack of altitude for the pilot-in-command to recover from the stall.