NTSB investigations, MN
168 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 11 |
| 1986 | 8 |
| 1987 | 7 |
| 1988 | 10 |
| 1989 | 9 |
| 1990 | 5 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 8 |
| 1997 | 5 |
| 1998 | 5 |
| 1999 | 8 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 1 |
| 2007 | 6 |
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\" = 250)
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" = 250) 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 CHI08FA039Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Faribault, MNThe pilot not maintaining adequate airspeed for the gusty crosswind conditions and the stall/spin encountered during the go-around. Contributing to the accident were the crosswinds and wind gusts.NTSB CHI08CA030Accident · No injuriesData collectionFinal reportCessna 172M · Duluth, MNThe pilot's inadequate compensation for wind conditions during the landing approach. Contributing to the accident was the crosswind weather condition.NTSB CHI07CA315Accident · Minor injuriesData collectionFinal reportAerotechnik Sportstar-Evektor · Maple Lake, MNThe student pilot's failure to relinquish the flight controls and the flight instructor's inadequate supervision which resulted in the certified flight instructor not being able to maintain directional control. Contributing factors included the student…NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB CHI07CA239Accident · No injuriesData collectionFinal reportCessna 150H · Cook, MNThe pilot not maintaining airspeed leading to the stall/mush encountered during takeoff and the unsuitable terrain the pilot selected during the forced landing. Factors were the vehicle encountered during the forced landing and the ditch the pilot steered the…NTSB CHI07LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Eden Prairie, MNThe pilot's inability to maintain control of the airplane for undetermined reasons. Contributing to the accident were the embankment and the fence.NTSB CHI06CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Backus, MNThe airplane stalled as a result of the low airspeed and the instructor pilot's failure to take remedial action.NTSB CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…NTSB CHI06CA020Accident · No injuriesData collectionFinal reportStinson SR-6A · Glencoe, MNThe pilot's inadequate wind compensation and his failure to maintain directional control during the landing rollout. A factor to the accident was the gusting crosswind condition.NTSB CHI06LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Williams, MNThe pilot's failure to maintain airspeed which resulted in the airplane stalling. Factors associated with the accident were the low level at which the airplane was maneuvering and the pilot's failure to perform weight and balance calculations prior to the…NTSB CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB CHI05CA168Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Minneapolis, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors associated with the accident were the crosswind and the taxiway sign.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Minneapolis, MNThe pilot's inadequate compensation for the wind conditions and his failure to maintain control of the helicopter while maneuvering to center the helicopter on a cart. A factor associated with the accident was the wind gusts.NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB CHI04CA169Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Mankato, MNThe pilot's improper decision to initiate the flight given the crosswind wind condition. Additional causes were the pilot's inadequate compensation for the crosswind and his subsequent failure to maintain aircraft control. The crosswind and the runway light…NTSB CHI04CA163Accident · No injuriesData collectionFinal reportGrumman G-164A · Hutchinson, MNThe pilot's failure to maintain airspeed during the low altitude turn after takeoff. A factor to the accident was the low altitude and the swampy terrain condition.NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB CHI03LA269Accident · 2 fatalLimited investigationFinal reportHolden Pulsar · Willmar, MNThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB CHI03LA216Accident · 1 fatalLimited investigationFinal reportCessna 172H · Isle, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.NTSB CHI03LA172Accident · Minor injuriesLimited investigationFinal reportBell 206B · Baxter, MNThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. Factors contributing to this accident were the helicopter's low airspeed, low altitude, the crosswind, and the trees.NTSB CHI03LA117Accident · 1 fatalLimited investigationFinal reportSmith Rans S-7 · Baudette, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the low altitude maneuver by the student pilot.NTSB CHI03LA104Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lino Lakes, MNThe pilot not maintaining aircraft control while manuevering.NTSB CHI03LA112Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Grand Rapids, MNThe pilot's failure to obtain adequate airspeed which resulted in a stall. The short, soft, takeoff area, and the trees were contributing factors.NTSB CHI03LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeville, MNThe pilot's inadequate removal of ice and snow during the airplane preflight, and the subsequent loss of control due to the airplane being covered with ice.NTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.NTSB CHI02LA176Accident · 1 fatalLimited investigationFinal reportBar/Curtiss JN-4D · Owatonna, MNThe pilot's failure to maintain adequate airspeed during the takeoff climb resulting in an inadvertent stall. A factor associated with the accident was the low altitude at which the stall occurred.NTSB CHI02LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Minneapolis, MNThe pilot did not attain a proper climb rate during the go-around and the intentional wheels up landing. Factors associated with the accident were the inability of the pilot to maintain directional control of the airplane during the landing and the parked…NTSB CHI02LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Hackensack, MNThe pilot's inadequate compensation for the winds conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind conditions and the trees alongside the runway which the…NTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.NTSB CHI02LA030Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Hillman, MNThe inadvertent stall by the pilot. Factors were the tailwind, and the improper decision of the pilot to takeoff with a tailwind.NTSB CHI02LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Erhard, MNThe pilot not maintaining adequate airspeed while maneuvering in the turn. Factors relating to this accident were the low airspeed, the inadvertent stall, and the low altitude.NTSB CHI01LA258Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Crane Lake, MNThe inadvertant control interference by the passenger's knee leading to the pilot's directional control of the floatplane not being possible.NTSB CHI01LA250Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 STD Astir III · Faribault, MNThe pilot's failure to maintain adequate airspeed during the landing which resulted in a stall.NTSB CHI01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tracy, MNThe inadvertent stall during the initial takeoff. Factors relating to the accident were the student pilot's premature lift-off of the airplane during the initial takeoff, the instructor pilot's inadequate supervision, and the fences.NTSB CHI01LA153Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Cambridge, MNThe pilot's inadequate compensation for the wind conditions and the failure to maintain control of the airplane. A factor associated with the accident were the trees that the airplane contacted during the aborted landing.NTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.NTSB CHI01FA100Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Erhard, MNThe pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…NTSB CHI00FA185Accident · 3 fatalField investigationFinal reportPiper PA-30 · Duluth, MNloss of control in flight for undetermined reason(s).NTSB CHI00LA179Accident · 1 fatalLimited investigationFinal reportNorton Volksplane VP-1 · Waconia, MNthe inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.NTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.NTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.NTSB CHI00FA111Accident · No injuriesField investigationFinal reportBell 222U · St. Paul, MNThe loss of clamp-up force between the transmission case and the pylon mounted actuator support assembly which resulted in fatigue failure of the threaded studs and dowel pins, the failure of the flight control system, helicopter control not being possible…NTSB CHI00FA107Accident · 1 fatalField investigationFinal reportAeronca 7AC · Embarrass, MNthe inadvertent stall/spin the pilot encountered. A factor was the wind gusts.NTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…NTSB CHI00LA075Accident · Minor injuriesLimited investigationFinal reportKretsinger Bensen B8M · Wayzata, MNthe pilot's poor inflight planning in that he turned into a tailwind which resulted in diminished airspeed. Factors associated with the accident were the tailwind, low altitude maneuvering, the snow covered terrain, and the pilot's inability to successfully…NTSB CHI99LA353Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Gran Marais, MNthe downwind turn, stall, mush, due to the pilot's decision to turn and failure to maintain flying speed.NTSB CHI99FA264Accident · 1 fatalField investigationFinal reportBeech C23 · Detroit Lakes, MNAircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.NTSB CHI99LA235Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Maple Lake, MNThe pilot's inadequate preflight planning that resulted in exceeding the maximum gross weight of the airplane and the subsequent inadvertent aerodynamic stall.