NTSB investigations, 2006, NE
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
| 1962 | 1 |
|---|---|
| 1964 | 58 |
| 1965 | 67 |
| 1966 | 72 |
| 1967 | 89 |
| 1968 | 80 |
| 1969 | 88 |
| 1970 | 74 |
| 1971 | 93 |
| 1972 | 64 |
| 1973 | 52 |
| 1974 | 71 |
| 1975 | 47 |
| 1976 | 64 |
| 1977 | 52 |
| 1978 | 49 |
| 1979 | 41 |
| 1980 | 36 |
| 1981 | 34 |
| 1982 | 42 |
| 1983 | 39 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 27 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 22 |
| 1990 | 13 |
| 1991 | 24 |
| 1992 | 20 |
| 1993 | 21 |
| 1994 | 20 |
| 1995 | 16 |
| 1996 | 14 |
| 1997 | 14 |
| 1998 | 28 |
| 1999 | 23 |
| 2000 | 13 |
| 2001 | 19 |
| 2002 | 14 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 15 |
| 2006 | 17 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 15 |
| 2010 | 13 |
| 2011 | 7 |
| 2012 | 21 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 10 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 9 |
| 2022 | 14 |
| 2023 | 10 |
| 2024 | 17 |
| 2025 | 11 |
| 2026 | 4 |
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\") = 2006
AND c.\"eventStateOrRegion\" = 'NE' 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") = 2006 AND c."eventStateOrRegion" = 'NE' 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 CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.NTSB NYC06LA223Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Hastings, NEThe airplane's in flight encounter with thunderstorm related turbulence.NTSB CHI06LA255Accident · No injuriesLimited investigationFinal reportCessna A185E · Valentine, NEThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in an inadvertent ground loop by the pilot. A factor contributing to the accident was the gusting crosswind condition.NTSB CHI06CA254Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Alliance, NEThe pilot's inadequate preflight inspection which led to the aircraft tow bar not being removed prior to flight.NTSB DEN06LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Harrisburg, NEThe loss of engine power resulting from mechanical failure of a connecting rod for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA235Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · Gering, NEThe pilot's failure to maintain clearance from the power lines during the aerial application flight. Factors were the low altitude and power lines.NTSB CHI06FA215Accident · No injuriesField investigationFinal reportManarin/Johnson Lancair IVP · Omaha, NEThe selection of an unsuitable landing area by the pilot of the other airplane, and his failure to maintain separation during landing.NTSB CHI06CA237Accident · No injuriesData collectionFinal reportSpittler Rans S-16 · Plattsmouth, NEA loss of engine power due to fuel starvation which resulted from a binding within the fuel servo. A factor associated with the accident was the high vegetation that was encountered during the forced landing.NTSB CHI06CA199Accident · Minor injuriesData collectionFinal reportPorter Mustang II · Ainsworth, NEThe delay in initiating the aborted landing which resulted in inadequate altitude to clear high vegetation off the end of the runway. Factors associated with the accident were the gusty crosswind, inadequate compensation for the wind conditions, and the high…NTSB CHI06CA169Accident · Serious injuriesData collectionFinal reportBeech 35-33 · Lincoln, NEA loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…NTSB CHI06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-22-135 · Nebraska City, NEThe pilot's failure to maintain directional control during the landing rollout and the resulting ground loop. A contributing factor was the excessive tail wheel steering (rudder) input by the pilot.NTSB CHI06CA160Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Gretna, NEA run-on landing encountered by the pilot of the balloon due to the prevailing winds. The unfavorable winds were a contributing factor.NTSB CHI06CA143Accident · No injuriesData collectionFinal reportRobinson R44 · Stapleton, NEThe pilot not maintaining clearance fron the tree during landing. A factor was the tree.NTSB CHI06CA133Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Verdigre, NEThe pilot's decision to land on a wet grass runway that had insufficient length available for landing roll. An additional cause was the pilot's failure to properly retract the flaps during the aborted landing, resulting in diminished climb performance and the…NTSB CHI06IA127Incident · Minor injuriesIncident investigationFinal reportCorporate Jets BAE125-800A · Lincoln, NEThe pilot-in-command's failure to maintain control during the initial roll at onset of the stall due to his improper remedial action related to the stall recovery. A contributing factor was initiation of an intentional stall with residual wing ice…NTSB CHI06LA099Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Omaha, NEAn inadvertent encounter with unforecast mountain wave turbulence during cruise flight. A contributing factor was the mountain wave (terrain induced) turbulence.NTSB CHI06LA071Accident · 1 fatalLimited investigationFinal reportVillarubia RV-6 · Decatur, NEAn inflight collision with the terrain for undetermined reasons.