NTSB investigations, ID
119 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 8 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 2 |
| 1988 | 8 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 1 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 5 |
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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 SEA08FA042Accident · 2 fatalField investigationFinal reportBeech 200 · Salmon, IDAn in-flight loss of control due to the pilot's failure to remove ice and snow from the airplane prior to takeoff. Contributing to the accident were the pilot's improper preflight preparation/actions, falling snow, and a low ambient temperature.NTSB LAX07LA278Accident · No injuriesLimited investigationFinal reportSkykits Savannah ADV · Lava Hot Spring, IDFailure of the pilot to maintain aircraft control during landing.NTSB SEA07TA214Accident · Serious injuriesFinal reportBell 214ST · McCall, IDThe pilot's inadequate planned approach that led to settling with power. Contributing to the accident was the external load becoming snagged in the water, and the high density altitude.NTSB SEA07CA198Accident · No injuriesData collectionFinal reportCessna 182B · Leadore, IDThe pilot's inadequate compensation for the gusty wind conditions and his failure to maintain aircraft control, which resulted in a loss of control and collision with terrain during the takeoff initial climb. A contributing factor was the gusty wind condition.NTSB SEA07CA125Accident · No injuriesData collectionFinal reportCessna 170B · Fairfield, IDThe pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.NTSB SEA06TA152Accident · No injuriesFinal reportCessna TU206G · Lowman, IDThe pilot's loss of aircraft control due to a downdraft on short final followed by an uncontrolled descent to a hard landing.NTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.NTSB SEA06CA128Accident · No injuriesData collectionFinal reportUnknown Challenger II · Emmett, IDThe pilot's failure to maintain aircraft control, which resulted in an off-airport landing. Contributing factors were the pilot's lack of familiarity with the airplane and the soft terrain.NTSB SEA06LA077Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Clark Fork, IDThe pilot's failure to maintain aircraft control during a go-around. A quartering tailwind was a factor.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.NTSB SEA05LA164Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Driggs, IDThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. The pilot's failure to maintain a proper altitude was a factor.NTSB SEA05LA134Accident · 1 fatalLimited investigationFinal reportJones Long EZ · Marsing, IDThe pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.NTSB SEA05LA129Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Hailey, IDThe pilot's failure to maintain aircraft control while on final approach for undetermined reasons.NTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.NTSB SEA05TA028Accident · Serious injuriesFinal reportChristen Industries A-1 · Terreton, IDThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall and subsequent collision with terrain.NTSB SEA05FA025Accident · 2 fatalField investigationFinal reportCessna 208B · Bellevue, IDThe pilot's failure to maintain aircraft control while on approach for landing in icing conditions. Inadequate airspeed was a factor.NTSB SEA04LA124Accident · No injuriesLimited investigationFinal reportMooney M20R · Hailey, IDThe pilot's improper flare, failure to maintain directional control, and inadequate remedial action, which resulted in the airplane impacting a taxiway sign along the side of the runway. A factor contributing to the accident was the taxiway sign.NTSB SEA04LA110Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL · Mountain Home, IDThe pilot's failure to maintain aircraft control during an undetermined in-flight operational phase resulting in an uncontrolled descent into the terrain. Factors include strong gusty winds in the area of the accident.NTSB SEA03FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Warm Lake, IDThe pilot's failure to maintain adequate airspeed during final approach resulting in a stall/spin. Contributing factors were the rapidly rising terrain and trees.NTSB SEA03CA144Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Burley, IDThe pilot's failure to remove the elevator gust lock prior to flight. Factors include the pilot's inadequate preflight.NTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.NTSB SEA03FA042Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Rexburg, IDThe pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.NTSB SEA01LA043Accident · No injuriesLimited investigationFinal reportS.N.I.A.S SE 3130 Alouette II · Driggs, IDThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB SEA01FA017Accident · 2 fatalField investigationFinal reportCessna 425 · Idaho Falls, IDThe pilot-in-command's failure to maintain adequate airspeed with an asymmetric thrust condition, resulting in a loss of aircraft control. A factor was an asymmetric engine thrust condition, which was present for undetermined reasons.NTSB SEA00LA172Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Boise, IDAircraft control was not maintained during approach for landing.NTSB SEA00LA104Accident · 2 fatalLimited investigationFinal reportLunn RV-6A · Hammett, IDThe pilot's entering an inadvertent stall condition, and the lack of adequate altitude in which to successfully recover before ground impact.NTSB SEA99LA166Accident · 1 fatalLimited investigationFinal reportPitts 11 · Iona, IDThe pilot-in-command's delayed recovery from a snap roll. A contributing factor was the low altitude at which the maneuver was initiated.NTSB SEA99LA159Accident · 2 fatalLimited investigationFinal reportGentry Series 5 Vixen · Naples, IDThe pilot's failure to maintain adequate airspeed during a turn back toward the departure surface, resulting in a stall.NTSB SEA99LA120Accident · 2 fatalLimited investigationFinal reportAnderson Rans S-12 · Bowmont, IDAircraft control was not maintained while maneuvering at low altitude. An inadvertent stall was a factor.NTSB SEA99LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Paul, IDThe pilot's failure to attain adequate airspeed during takeoff and initial climb, resulting in stall/mush and inability of the aircraft to sustain level flight. Factors included high density altitude, a tailwind, an uphill takeoff surface, and crops in the…NTSB SEA99FA116Accident · 4 fatalField investigationFinal reportCessna 182D · Big Creek, IDThe pilot's failure to maintain control of the aircraft during approach. Factors included high density altitude conditions and high terrain, which obstructed view of the runway and limited maneuvering space in the traffic pattern.NTSB SEA99FA176Accident · 2 fatalField investigationFinal reportCessna 152 · Coeur d'Alene, IDThe flight crew's failure to maintain adequate airspeed, resulting in a stall and uncontrolled collision with terrain. A factor was mountainous/hilly terrain.NTSB SEA99LA047Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Emmett, IDThe pilot's failure to maintain aircraft control during a low-altitude maneuver to view a coyote on the ground. A related factor was the pilot's low altitude.NTSB SEA99LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Buhl, IDThe pilot's failure to follow the aircraft's recommended balked landing procedure, resulting in a stall. Factors include the pilot's failure to maintain directional control during the landing flare, the pilot's lack of total experience, and insufficient…NTSB SEA98LA175Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Stanley, IDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA98LA115Accident · No injuriesLimited investigationFinal reportTracy Avid Mark IV · Coeur D'Alene, IDThe pilot's failure to maintain adequate airspeed.NTSB SEA98LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Big Creek, IDThe pilot's failure to maintain airspeed while maneuvering to an emergency landing, resulting in an inadvertent stall/mush into the terrain. A contributing factor was the high density altitude.NTSB SEA98LA102Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cascade, IDThe flight instructor's inadequate remedial action after his dual student attempted a soft field takeoff with inadequate airspeed and premature lift off.NTSB SEA98FA083Accident · 2 fatalField investigationFinal reportPapa 51 Thunder Mustang · Marsing, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB SEA98LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sandpoint, IDLoss of consciousness by the pilot-in-command/flight instructor, resulting in loss of aircraft control and subsequent collision with terrain.NTSB SEA98LA045Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Moreland, IDThe pilot's failure to maintain aircraft control resulting in an inadvertent stall/spin. A factor was his lack of familiarity in the make/model.NTSB SEA98FA042Accident · 6 fatalField investigationFinal reportCessna T303 · Midvale, IDThe pilot's failure to maintain aircraft control.NTSB SEA98FA040Accident · 2 fatalField investigationFinal reportFreije Lancair IV · Garwood, IDThe pilot's failure to maintain aircraft control after entering known adverse weather. Related factors were, the pilot's failure to follow the published IFR departure procedures, low ceilings and snow, and the pilot's lack of recent instrument experience.NTSB SEA98LA019Accident · Serious injuriesLimited investigationFinal reportBlue Denney Kitfox Model 3 · Caldwell, IDThe pilot's failure to maintain adequate airspeed.NTSB SEA97LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Dixie, IDShifting of a briefcase stored behind the pilot's seat to a position where it obstructed movement of the rudder pedals, resulting in loss of directional control capability. A factor was trees adjacent to the airstrip.NTSB SEA97LA200Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk City, IDA horse and children wandered onto the airstrip.NTSB SEA97LA169Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Newdale, IDThe pilot's inadequate preflight/planning preparation which resulted in the aircraft exceeding the maximum gross weight, and inability to climb. A factor was high density altitude.NTSB SEA97FA041Accident · 5 fatalField investigationFinal reportCessna P210N · Cambridge, IDthe pilot's failure to maintain control of the aircraft. Flight into adverse weather and turbulence were factors.NTSB SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.