Final NTSB investigations, ND
18 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 2 |
| 2007 | 2 |
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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 CHI08IA022Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Fargo, NDThe failure of the Brake and Steering Control Unit, which allowed the nose landing gear to turn to the 90-degree position.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.NTSB CHI05LA154Accident · No injuriesLimited investigationFinal reportCessna A188B · Washburn, NDThe separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.NTSB CHI05LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Bismarck, NDRupture of the hydraulic powerpak drain line which resulted in a loss of hydraulic fluid and the inability to properly lower the landing gear despite the pilot's execution of the emergency extension procedures. A contributing factor was the runway light…NTSB CHI01LA252Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Edmore, NDThe incorrect installation of the wheel assembly bolts by maintenance personnel resulting in the stripped bolt threads and ultimate failure of the wheel, and directional control not possible by the pilot. A factor was the ditchNTSB CHI00LA178Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Tolna, NDthe wing spar fatigue and wing separation while maneuvering. A factor was that the fatigue was not detected by the mechanic during the last annual inspection.NTSB CHI00LA043Accident · 2 fatalLimited investigationFinal reportMcCarty Wittman W-8 Tailwind · Jamestown, NDthe wing spar failure due to its inadequate construction by the owner/builder.NTSB CHI95IA066Incident · No injuriesIncident investigationFinal reportBeech 1900D · Williston, NDthe improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.NTSB CHI94LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Spiritwood, NDthe failure of the fuselage tubing in the empennage.NTSB CHI92LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Langdon, NDFailure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.NTSB CHI90DTG02Accident · No injuriesFinal reportHiller UH-12-E · Garrison, NDThe failure of the helicopter tail rotor control cable. A factor related to the accident was the chafing of the tail rotor control cable.NTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.NTSB DEN87LA062Accident · No injuriesLimited investigationFinal reportBeech 58 · Bismarck, NDThe plt, while at cruise, detected an odor he suspected to be overheated electrical wiring. He diverted to a nearby arpt for a precautionary landing. The plt shutdown all electrical pwr after communication with the twr. Prior to landing, the plt turned on…NTSB DEN86LA239Accident · No injuriesLimited investigationFinal reportPiper PA-23E-250 · Grand Forks, NDThe acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear…NTSB DEN86LA145Accident · No injuriesLimited investigationFinal reportMooney M20 · Fargo, NDThe plt reports that he experienced difficulty in retracting the landing gear after departure but it did retract after several attempts. He said the gear system seemed to be hanging up. Upon reaching destination the gear again seemed to hang up when extension…NTSB DEN84FA042Accident · Serious injuriesField investigationFinal reportMooney M20J · Bismarck, NDThe plt of N1151N reported that the departure arpt had some drifting snow which caused the r brake to freeze after takeoff. When the acft was landed, the r tire slid until it wore thru, then deflated. The plt stopped the acft on the rwy, informed tower psnl…NTSB DEN82DA171Accident · No injuriesFinal reportCessna 190 · Bismarck, NDLeft brake failed. Examination revealed the hydraulic brake line to the left brake had pulled loose from a union fitting. The line also sheared by the shifting of the gear box assembly. There were signs of inadequate flare to the tubing in that it pulled out…NTSB DEN82FA148Accident · 1 fatalField investigationFinal reportEnstrom F-280 · Medora, NDDuring flt the plt noticed that eng RPM was about 500 over rotor RPM. The acft crashed during an unsuccessful autorotation. The overrunning clutch linkage & clutch was found in the disengaed position. A successful autorotation requires that the collective…