NTSB investigations, NE
23 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
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\" = 'NE' 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\" = 130)
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" = 'NE' 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" = 130) 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 CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…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 CHI03LA152Accident · No injuriesLimited investigationFinal reportZimmerman Glastar · Pierce, NEThe pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…NTSB CHI02FA174Accident · 3 fatalField investigationFinal reportEurocopter France AS-350-B2 · Norfolk, NEA loss of tail rotor effectiveness and the pilot's failure to maintain control of the helicopter. Factors associated with the accident were the binding of the tail rotor pitch changed rod, the gusty wind conditions, and the pilot’s lack of total experience in…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 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 CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.NTSB CHI94MA072Accident · 2 fatalMajor investigationFinal reportCessna 421C · Mccook, NEImproper in-flight planning/decision by the pilot, and the accumulation of airframe ice, which resulted in an inadvertent stall. Factors associated with the accident were: partial failure of both alternators, which resulted in a subsequent electrical system…NTSB MKC90LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Omaha, NEFailure of the throttle cable assembly which resulted in a forced landing and subsequent collision with a fence.NTSB MKC88LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Bayard, NEThe pilot stated that he started the trip, from new Mexico to north dakota, the evening prior to the accident. Because of poor weather, the pilot re-routed the flight through several alternate fuel and oil stops. The flight was en route to a planned fuel stop…NTSB MKC88FA043Accident · Minor injuriesField investigationFinal reportAerospatiale AS-350B · Omaha, NEThe pilot picked the aircraft up to a hover and made a hovering turn in preparation for departure. The nose of the aircraft began to rise. The pilot stated later that he could not control the aircraft. The aircraft began to descend and the tail rotor struck a…NTSB MKC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Columbus, NEThe PIC was positioning his ag acft for a spray job when he thought he had a pblm with the eng. A precautionary lndg was decided on, but the lndg resulted in substantial dmge to the acft. A spray pump, posnd beneath the eng cowling which rotates by means of a…NTSB MKC87LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Adams, NEAfter a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation…NTSB MKC87FA131Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Holdrege, NEWitnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the…NTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…NTSB MKC86FCJ04Accident · Minor injuriesFinal reportAmateur Built Quickie Q2 · Grand Island, NEThe acft engine developed severe roughness during cruise and the plt decided to make an emergency landing. During approach, the engine quit and the plt attempted a tight turn to the runway. During the turn, the aircraft hit the asphalt ramp in a left wing…NTSB MKC86IA018Incident · No injuriesIncident investigationFinal reportSAAB-Fairchild SF340A · Lincoln, NEDuring landing roll at the Lincoln airport, the outboard wheel of the left main landing gear separated from the axle. The acft was not hampered in its landing roll and taxithe landing gear assembly revealed that a retaining nut washer was not installed on…NTSB MKC85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Norfolk, NEThe plt confirmed an alternator failure a short time after departing fairmont, cancelled his IFR clearance and continued to Norfolk for landing. Upon reaching his destination the plt was unable to extend the landing gear due to the electrical failure and no…NTSB MKC84FA174Accident · 4 fatalField investigationFinal reportBeech C35 · Broken Bow, NEWhile on an IFR flt at 6000 ft, the plt requested, and was granted a deviation around wx. Later, N335W informed denver ARTCC that they were going to get into some moderate turbulence for a little bit but that it looked like the light at the end of the tunnel.…NTSB MKC84LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · North Platte, NEWhile in cruise flt the plt noticed a loss of electrical power. A diversion was made to North Platte, NE, where the plt hoped to have the electrical problem fixed. Numerous attempts were made to lower the landing gear but to no avail and a gear up landing…NTSB MKC84LA105Accident · No injuriesLimited investigationFinal reportBeech A36TC · North Platte, NEThe acft had just departed North Platte airport and retracted the landing gear. The acft door then opened, the pilot elected to land back on the runway and failed to remember to lower the landing gear.NTSB MKC83FA122Accident · Serious injuriesField investigationFinal reportCessna 320E · Minden, NEThe acft stalled and crashed on the final approach to land. The acft had called for landing information and entered the pattern and was seen established in a low final approach when it suddenly turned right and descended to the ground. The acft impacted about…NTSB MKC83FA038Accident · No injuriesField investigationFinal reportPiper PA-32R-300 · Dewitt, NEAs the flt approached destination the alternator began to malfunction. Plt continued to destination which was IMC, and as the gear was lowered during an instrument approach the nose gear indicated unsafe. The approach was discontinued and the plt climbed back…