NTSB investigations, 1999, ID
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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 SEA00LA025Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Boise, IDFailure of the forward gear door lock pin. An inoperative landing gear door and inadequate maintenance inspection of the aircraft were factors.NTSB SEA00LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · Garden Valley, IDAn improper in-flight decision by the pilot-in-command to attempt a landing at a confined-area airstrip which was beyond his piloting capabilities, and his subsequent failure to take adequate remedial action upon encountering a downdraft. Related factors were…NTSB SEA00FA015Accident · No injuriesField investigationFinal reportKaman K-1200 · Emida, IDFailure of the splined engine adaptor as a result of torsional overstress. Factors include a worn freewheeling clutch assembly.NTSB SEA00TA013Accident · Serious injuriesFinal reportHiller UH-12E · Stites, IDInadequate inspection of the control rotor cuff by a company mechanic and subsequent fatigue fracture of the cuff, resulting in an inflight separation of the control rotor blade. Factors contributing to the accident were: inadequate quality control during…NTSB SEA00FA012Accident · 4 fatalField investigationFinal reportCessna U206F · Challis, IDAircraft control was not maintained. The pilot's improper decision to abort the landing and flight into a box canyon were factors.NTSB SEA00LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Mackay, IDThe pilot's failure to land at the proper touchdown point. Factors include a wind gust, a grass runway, and a drop-off into rough terrain at the end of the runway.NTSB SEA00LA009Accident · No injuriesLimited investigationFinal reportCessna 182B · Atlanta, IDDirectional control not maintained by the pilot in command.NTSB SEA00LA004Accident · No injuriesLimited investigationFinal reportThomson Vans RV-6 · Emmett, IDThe pilot's improper fuel management, resulting in fuel starvation. A factor was the aircraft's low altitude at the time engine power was lost.NTSB SEA00LA002Accident · No injuriesLimited investigationFinal reportBeech F33A · Idaho Falls, IDThe pilot's failure to adequately compensate for wind conditions. Factors include gusty, turbulent, variable crosswinds, and a fence in the vicinity of the runway.NTSB SEA99LA170Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Coolin, IDThe pilot's failure to adequately compensate for wind conditions. Factors include variable, gusty crosswinds, and trees along the sides of the runway.NTSB SEA99LA167Accident · No injuriesLimited investigationFinal reportCessna 182S · Kamiah, IDThe pilot's excessive airspeed on final approach, his inadequate remedial action, and his failure to attain the proper touchdown point during landing. Factors included a short, confined landing area and a tailwind.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 SEA99LA162Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Burley, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a taxiway marking sign located adjacent to the runway.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 SEA99LA156Accident · No injuriesLimited investigationFinal reportCessna 182M · Sandpoint, IDThe pilot's improper flare. Factors include a runway that sloped uphill, and the pilot's failure to familiarize himself with the destination airstrip prior to departure.NTSB SEA99LA153Accident · No injuriesLimited investigationFinal reportCessna 210B · Dixie, IDInadequate airspeed and clearance was not maintained. Mountainous conditions, trees, and an inadequately planned approach were factors.NTSB SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.NTSB SEA99LA137Accident · No injuriesLimited investigationFinal reportCessna 180J · Council, IDThe pilot's inadequate recovery from a bounced landing. Gusting wind conditions and a dirt bank adjacent to the runway edge were factors.NTSB SEA99LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's improper remedial action (continued takeoff). Contributing factors were the tree and control interference (inadvertent brake activation) by the passenger..NTSB SEA99LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Middleton, IDThe pilot's failure to maintain clearance from an object. Power lines were a factor.NTSB SEA99LA127Accident · No injuriesLimited investigationFinal reportBeech D17S · Arco, IDFuel starvation which resulted in a loss of power. The pilot's improper management of fuel was a factor.NTSB SEA99LA125Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · American Falls, IDA loss of engine power for undetermined reasons, and overload of the (right) main landing gear. A contributing factor was the rough terrain.NTSB SEA99LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Glenns Ferry, IDThe pilot's failure to maintain directional control during the attempted takeoff. A related factor was the pilot's lack of recent experience.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 SEA99LA124Accident · No injuriesLimited investigationFinal reportNavion B · Stanley, IDAn improperly planned approach and gusting wind conditions. A tailwind 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 SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.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 SEA99LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · New Plymouth, IDLoss of engine power due to failure of the supercharger impeller. A contributing factor was the ditch.NTSB SEA99LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Garden Valley, IDLoss of engine power due to fuel exhaustion because the pilot failed to refuel the airplane. A ditch in the landing area was a contributing factor in the accident.NTSB SEA99LA099Accident · Minor injuriesLimited investigationFinal reportWhithington Kitfox 1200 · Caldwell, IDThe pilot's failure to maintain clearance from obstacles along his departure path. Factors include the pilot's incorrect positioning of the flaps prior to takeoff, and a transmission wire and trees along the aircraft's flight path.NTSB SEA99LA096Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Nampa, IDDirectional control was not maintained. Diverted attention was a factor.NTSB SEA99LA089Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Tetonia, IDA failure of the right magneto drive gear shaft. Factors include the absence of any suitable terrain on which to perform an emergency landing, and the rough/uneven condition of the terrain on which the pilot was forced to land.NTSB SEA99LA079Accident · No injuriesLimited investigationFinal reportSnow S2C · Paul, IDThe pilot's inaccurate weight and balance calculations, and his delay in jettisoning the load which resulted in his failure to clear rising terrain. Contributing to the accident was the high density altitude, and the pilot's intentional operation with known…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 SEA99LA075Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDFuel exhaustion. Carburetor contamination and rough terrain were factors.NTSB SEA99LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · Buhl, IDAn inadequate recovery from a bounced landing. Gusting wind conditions were a factor.NTSB SEA99LA063Accident · No injuriesLimited investigationFinal reportLake LA-4 · Coeur D'Alene, IDThe fatigue failure of a repair weld on one of the engine pylon mount straps and the resultant reduction in directional control. Factors include an inadequate repair of the strap, variable wind speeds and sudden wind shifts.NTSB SEA99LA059Accident · No injuriesLimited investigationFinal reportCessna 172D · Glenns Ferry, IDThe failure of both pilots to see-and-avoid wires crossing the river. Factors included: transmission wires; inattention of both pilots to the aircraft's flight path; and the pilots' low-altitude flight.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 SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.NTSB SEA99LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Hailey, IDThe pilot's failure to maintain aircraft control after touchdown. Factors contributing to the accident were a snow bank along the runway edge and a crosswind.NTSB SEA99LA039Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cascade, IDUnsuitable terrain for landing was selected. Snow covered airstrip was a factor.NTSB SEA99FA037Accident · No injuriesField investigationFinal reportHiller UH-12E · Yellow Pine, IDAltitude deviation during aerial taxi for undetermined reasons.NTSB SEA99LA036Accident · No injuriesLimited investigationFinal reportPiper J-5A · Rexburg, IDThe pilot's failure to maintain clearance from power lines.NTSB SEA99LA031Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Tensed, IDThe pilot-in-command's inadequate fuel management which resulted in fuel exhaustion. Contributing factors were the absence of cautionary markings on the fuel gauge, and high trees at the accident site.