NTSB investigations, MN
71 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 5 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 7 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 3 |
| 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\" = 'MN' 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" = 'MN' 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 CHI07LA277Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Anoka, MNThe loss of helicopter pitch control for undetermined reasons during the aerial application maneuver and the pilot's inability to control the aircraft during the descent.. A contributing factor to the accident was the soft terrain.NTSB CHI07LA173Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fergus Falls, MNThe propeller blade failure during climb due to a fatigue crack. The oil leak that obstructed the pilot's vision was a factor in the accident.NTSB CHI07LA002Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marshall, MNThe failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.NTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.NTSB CHI06LA207Accident · Serious injuriesLimited investigationFinal reportSchlei Avid Flyer Speed Win · Fergus Falls, MNthe fractured aileron bell crank and elevator clevis rod end.NTSB CHI05MA111Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-9-51 · Minneapolis, MNthe Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…NTSB CHI05LA097Accident · No injuriesLimited investigationFinal reportCessna 310 · Clear Lake, MNThe collapse of the nose landing gear as a result of the pilot performing improper maintenance on the airplane due to his failure to properly safety the nose landing gear door.NTSB CHI05LA064Accident · No injuriesLimited investigationFinal reportCessna A185F · Minneapolis, MNA failure of the tail wheel locking mechanism which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.NTSB CHI04LA119Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Winsted, MNThe failure of the main rotor drive belts for an undetermined reason, and the pilot's misjudged flare during the autorotation.NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…NTSB CHI02IA270Incident · No injuriesIncident investigationFinal reportFokker 100 · Minneapolis, MNThe improper installation of the #2 main landing gear wheel, including the axle nut not being properly torqued and safetied, which resulted in the wheel separation during takeoff.NTSB CHI02LA044Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · St Paul, MNThe autopilot's computer connections arcing and reported disconnection during the localizer approach and the pilot not performing a go around prior to the hard landing. A factor was the pilots lack of total experience in the accident airplane's make and model.NTSB CHI01IA047Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Cloud, MNthe fatigue failure of the propeller blade during the initial takeoff climb. The failure was a result of a material defect, which occurred during the manufacturing process and the manufacturers failure to detect the defect.NTSB CHI01LA008Accident · No injuriesLimited investigationFinal reportWalton RV-6 · Saint Paul, MNThe rudder tube failure, and aircraft control not possible during the flare by the pilot. A factor was the service bulletin not being complied with by the mechanic during the condition inspection.NTSB CHI00LA296Accident · No injuriesLimited investigationFinal reportBoeing 727-224 · Minneapolis, MNThe fatigue failure of the wheel assembly. A factor was the inadequate inspection procedures prior to the issuance of a service bulletin.NTSB CHI00LA118Accident · No injuriesLimited investigationFinal reportCessna 170A · St. Paul, MNthe broken landing gear axle.NTSB CHI99LA261Accident · Serious injuriesLimited investigationFinal reportHodre-Buull-Kolb Mark III · Plymouth, MNThe failure of the airplane's rudder control pulley due to corrosion and inadequate maintenance inspection of the airplane by the owner/pilot mechanic of the airplane.NTSB CHI99LA243Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marshall, MNthe inadvertent stall and the checklist not followed by the pilot. Contributing factors were the baggage door not secured and the precautionary landing attempt by the pilot.NTSB CHI99LA241Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aitkin, MNthe right spring in the tailwheel assembly's separation. Factors were the fatigue in the landing gear, the maintenance personnel not identifying the fatigue during the annual inspection, and the right main gear's separation.NTSB CHI98IA164Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Minneapolis, MNthe open shielding on the #2 VHF transceiver coax connector which resulted in electromagnetic interference with the yaw damper system.NTSB CHI98FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Faribault, MNwas the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot.NTSB CHI98IA035Incident · No injuriesIncident investigationFinal reportCessna 152 · Blaine, MNthe fracture of the flap cable as a result of fatigue cracking.NTSB CHI97LA306Accident · Serious injuriesLimited investigationFinal reportBell 47 · Pipestone, MNthe fracture of the pitch control rod assembly.NTSB CHI97FA095Accident · 1 fatalField investigationFinal reportCessna 140 · Big Lake, MNThe pilot's maneuvers which exceeded the design stress limits of the airplane and resulted in structural overload of the horizontal tail followed by a structural overload of the wings.NTSB CHI96LA317Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Stewartville, MNthe pilot's improper in-flight planning/decision, which resulted in a failure to reach the proper touchdown point for the landing. The fractured nose gear shimmy damper attaching collar and the jammed nose gear were related factors.NTSB CHI96FA314Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Medford, MNfailure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: failure of the (primary) vacuum system and a restriction in the (standby) vacuum system.NTSB CHI96IA066Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Bemidji, MNinadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.NTSB CHI95IA342Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNinadequate design of the fly-by-wire flight control system which allowed false signals from the sidestick transducer units to generate uncommanded rolls.NTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.NTSB CHI94IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Thief Rvr Falls, MNFatigue failure of the propeller blade, originating from a corrosion pit.NTSB CHI93IA382Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Grand Rapids, MNthe fractured aileron cable and other maintenance personnel's inadequate maintenance/adjustment.NTSB CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.NTSB CHI92LA031Accident · No injuriesLimited investigationFinal reportCessna 310R · South St Paul, MNThe inadequate design of the propeller hub assembly which resulted in metal fatigue and propeller blade separation during initial climbout.NTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…NTSB CHI91DER10Accident · Serious injuriesFinal reportKolb Twinstar MK II · Staples, MNThe disconnected elevator trim cable. Related factors are the inadequate maintenance/installation, and the pilot's inability to maintain aircraft control.NTSB CHI91LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · North Mankato, MNThe fatique failure of the tail boom support strut attachment cluster and the improper inspection of the cluster attachment.NTSB CHI91DER01Accident · Minor injuriesFinal reportCessna 206 · South St. Paul, MNThe inadvertent deployment of the drag parachute. Related factors are the pilot's improper remedial action, habit interference, and the reduced aircraft controllability.NTSB CHI90LA260Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrison, MNInadequate inspection of the aircraft.NTSB MKC90LA116Accident · 1 fatalLimited investigationFinal reportRollins-Bowers FLY Baby 1A · Bemidji, MNThe wing attachment bolts were not installed resulting in inflight wing separation.NTSB MKC90LA088Accident · Serious injuriesLimited investigationFinal reportBell 47 · Oakdale, MNA slipping rotor drive clutch assembly due to improper maintenance by company personnel. Contributing factors were static wires in the path.NTSB MKC89LA198Accident · No injuriesLimited investigationFinal reportBeech 80 · Littlefork, MNTotal failure of the electrical system during IFR operations & the aircraft's collision with a rock fence during the subsequent gear-up precautionary landing.NTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…NTSB CHI89IA083Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNFailure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws.NTSB MKC89IA024Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-31 · Minneapolis, MNThe failure of the left main landing gear tire carcass and the ingestion of the tire debris into the left engine which hindered normal operation.NTSB CHI88DER12Accident · No injuriesFinal reportCessna A188B · Clearbrook, MNOn initial climb the right cowling door came open. The pilot was unable to maintain a climb and elected to make an emergency landing in a hay field. The aircraft encountered unsuitable terrain and received substantial damage. Post accident inspection of the…NTSB CHI88DER14Accident · 1 fatalFinal reportHomebuilt Woodstock · Mankato, MNAircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers.NTSB CHI88DER06Accident · No injuriesFinal reportHiller UH-12E · Buffalo Lake, MNWhen the helicopter lifted off, the left tail rotor cable separated. Directional control was lost and the aircraft collided with the terrain. The pilot reported no injuries, however the helicopter sustained substantial damage. An inspection of the left tail…NTSB CHI88LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Mankato, MNAs the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During…NTSB CHI88LA104Accident · No injuriesLimited investigationFinal reportBeech K35 · Milaca, MNNTSB CHI88IA040Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Minneapolis, MNAircraft experienced a loss of aileron ctl when ice formed around aileron control cables and restricted their movement. Water draining through open plenum drains in the main landing gear wheel well froze when exposed to below freezing temperatures at 35,000…