NTSB investigations, 1998, 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\") = 1998
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") = 1998 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 CHI99LA057Accident · No injuriesLimited investigationFinal reportMooney M20E · Tryon, NEother maintenance personnel's not correcting a loose cylinder assembly. Factors were loose engine cylinder assembly, fractured cylinder mounting hardware, the roadway, and road sign.NTSB CHI99LA050Accident · No injuriesLimited investigationFinal reportCessna 310 · Ashland, NEthe pilot's not refueling the airplane to avoid fuel exhaustion, and his inadequate preflight planning. A factor was fuel exhaustion.NTSB CHI99LA046Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Naponee, NEthe pilot's failure to identify the wires prior to spraying the field and the low altitude at which the pilot was flying. A factor was the wires which the airplane contacted.NTSB CHI99LA035Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Alliance, NEWas the late flare and stall by the student pilot and improper remedial actions by the student pilot.NTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.NTSB CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB CHI99LA006Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Oshkosh, NEthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the high winds, low altitude at which the pilot was maneuvering and the uneven terrain which the helicopter contacted.NTSB CHI98LA322Accident · No injuriesLimited investigationFinal reportFairchild 24R-46A · Scribner, NEthe inadvertent ground loop caused by an unknown person who was in the process of stealing the airplane.NTSB CHI98LA317Accident · No injuriesLimited investigationFinal reportBeech C23 · North Platte, NEthe pilot's not compensating for wind conditions and failure to maintain control of the aircraft. A factor was the crosswind.NTSB CHI98LA312Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Shelton, NEThe pilot mismanaged the fuel which led to fuel starvation and subsequent loss of engine power.NTSB CHI98LA304Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Trenton, NEthe pilot misjudged the forced landing approach and stalled the airplane while attempting to lengthen his glide on final approach and inadequate preflight planning that led to the loss of engine power due to fuel exhaustion.NTSB CHI98LA272Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Falls City, NEthe main landing gear leg fracturing and separating from the portion mounted to the fuselage for undetermined reasons.NTSB CHI98LA262Accident · Serious injuriesLimited investigationFinal reportAeronca 11BC · Blue Springs, NEthe pilot's inadequate visual outlook to avoid impact with a wire. Factors were sunglare and the wire (static).NTSB CHI98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Nehawka, NEthe pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.NTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.NTSB CHI98LA196Accident · No injuriesLimited investigationFinal reportCessna 172K · Omaha, NEThe aircraft modification not being in compliance with the Supplemental Type Certificate. A factor to the accident was the fracture of the landing gear axle during landing.NTSB CHI98LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrison, NEthe pilot's improper positioning of the magneto switch and his improper use of the mixture control.NTSB CHI98LA190Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Lexington, NEAn improper autorotation by the pilot in command. Factors contributing to this accident were the accumulation of ice in the carburetor resulting in a total loss of engine power, and the soft terrain.NTSB CHI98LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEthe pilot's failure to maintain control of the aircraft. Factors were the crosswind and runway light.NTSB CHI98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Norfolk, NEthe pilot's misjudged wind conditions and his not obtaining/maintaining compensation for wind conditions. A factor was a sudden wind shift.NTSB CHI98LA180Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Orleans, NEthe pilot selected a field with unsuitable terrain and stalled the airplane. Additional factors were the tower in the field, and engine failure due to the improper torque applied to camshaft bolts by other maintenance personnel.NTSB CHI98LA178Accident · Minor injuriesLimited investigationFinal reportCessna 414 · North Platte, NEthe slipped number two bearing in the airplane's right engine, which blocked the bearing's oil feed line, causing the bearing and the crankshaft to overheat and fracture. A factor contributing to this accident was the trees.NTSB CHI98LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Lincoln, NEthe pilot of N60BH failed to maintain clearance with N11498. Factors associated with the accident were the diminished visual lookout due to the runway and the tail wheel configuration of N60HB, along with the controllers failure to point out traffic.NTSB CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.NTSB CHI98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Omaha, NEThe fatigue failure of the crankshaft which resulted from a spun bearing and the low altitude at which the loss of engine power occurred. A factor in the accident was the embankment on which the airplane was landed.NTSB CHI98LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Superior, NEthe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the sign which the airplane contacted and inadequate preflight planning/preparation.NTSB CHI98LA094Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Wood Lake, NEthe pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings.NTSB CHI98LA084Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Island, NEice build-up on the airplane's wings and empennage which led to an inadvertent stall and hard landing. Factors contributing to this accident were the pilot's inadvertent flight into icing conditions, and the icing conditions.