NTSB investigations, MN
93 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 10 |
| 1984 | 7 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 8 |
| 2004 | 3 |
| 2006 | 2 |
| 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\" = '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\" = 220)
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" = 220) 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 CHI08FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Browerville, MNAn in-flight collision with at least one Canada goose, and the resulting damage to the left stabilator that caused the airplane to become uncontrollable. Contributing to the accident was the night lighting condition, which precluded any possibility of the…NTSB CHI06CA233Accident · No injuriesData collectionFinal reportHoyt Kolb Mark III Clsc · Lakeville, MNThe pilot's failure to maintain clearance from the crops which resulted in the subsequent impact with the ground.NTSB CHI06LA208Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Claremont, MNThe procedure not followed by the passenger during landing and the inadequate supervision of the passenger by the pilot during landing. A contributing factors were the barbed wire fence.NTSB CHI04CA291Accident · No injuriesData collectionFinal reportJohnson Titan Tornado I · Carlton, MNThe pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.NTSB CHI04CA180Accident · No injuriesData collectionFinal reportTexas Helicopter M-74 · Clear Lake, MNThe pilot failed to maintain a proper glidepath to the landing zone. A factor was the truck pad.NTSB CHI04FA133Accident · 4 fatalField investigationFinal reportCessna U206F · Owatonna, MNThe altitude/clearance not maintained by the pilot-in-command during a precision instrument approach. A contributing factor was the instrument meteorological conditions.NTSB CHI04LA033Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Minneapolis, MNThe in-flight collision with geese during approach. The contributing factor was the bright night conditionsNTSB CHI04CA020Accident · Minor injuriesData collectionFinal reportShapowal Rotorway Exec 90 · Cushing, MNSelection of an unsuitable landing area by the pilot due to the static wire across the approach path. Contributing factors were the pilot's disorientation, the static wire and the low light (dusk) conditions.NTSB CHI03FA296Accident · 2 fatalField investigationFinal reportBeech 58P · Grand Marais, MNThe continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.NTSB CHI03LA232Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Stephen, MNThe pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.NTSB CHI03LA210Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Cleveland, MNThe pilot's inadequate visual lookout and low altitude flight when he failed to maintain altitude/clearance from the transmission wire. A factor contributing to the accident was the transmission wire.NTSB CHI03LA089Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Raymond, MNThe altitude/clearance not maintained by the pilot and his ostentatious display. The power lines and the pilot's maneuvering at low altitude were contributing factors.NTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…NTSB CHI03LA046Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Ada, MNThe pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.NTSB CHI02LA209Accident · No injuriesLimited investigationFinal reportBeech S35 · Minneapolis, MNThe proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.NTSB CHI02LA156Accident · No injuriesLimited investigationFinal reportHale Kitfox Model III · Fairmont, MNFailure by the pilot to obtain adequate clearance from the tree line, as well as a failure to abort the takeoff in a timely manner. A contributing factor was the tree line.NTSB CHI02LA165Accident · No injuriesLimited investigationFinal reportFirm Kit Fox 4-1200 · Virginia, MNAn in-flight collision with a bird that resulted in severed fuel lines and the subsequent in-flight fire and loss of engine power. A factor in the accident was the soft terrain condition.NTSB CHI02LA160Accident · Minor injuriesLimited investigationFinal reportNavion Navion A · Forest Lake, MNThe pilot not performing an aborted takeoff. The soft turf runway and power lines were contributing factors.NTSB CHI01LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Detroit Lakes, MNAltitude/clearance not maintained from the transmission wires during a low altitude flight/maneuver performed by the pilot. A factor to the accident was the transmission wires.NTSB CHI01LA042Accident · No injuriesLimited investigationFinal reportAerostar PA-60-601P · Preston, MNaltitude/clearance from the trees not being obtained/maintained by the pilot. Factors to the accident were the trees and the contamination of the pitot/static system.NTSB CHI00LA141Accident · No injuriesLimited investigationFinal reportCessna C310R · Hibbing, MNthe deer incursion on the landing runway.NTSB CHI00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNthe pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.NTSB CHI99FA223Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Fertile, MNthe inadvertent stall. Factors relating to this accident were the instructor pilot maneuvering the airplane at very low altitude and the trees.NTSB CHI99LA216Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Fisher, MNthe pilot's failure to maintain clearance from the crop during an aerial application spray run.NTSB CHI99LA098Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Grand Rapids, MNthe pilot's inadequate visual lookout. A factor to the accident was the unmarked transmission wire.NTSB CHI99LA037Accident · Serious injuriesLimited investigationFinal reportBeech BE-55 · Crystal, MNthe pilot failed to maintain the proper glidepath. A factor was the sunglare.NTSB CHI99LA026Accident · No injuriesLimited investigationFinal reportTomschin Mini 500 · Clinton, MNthe non-pilot's failure to maintain clearance from the power lines. Factors contributing to this accident were the non-pilot's lack of total experience and the power lines.NTSB CHI98LA273Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Clearwater, MNThe inadequate visual lookout by the pilot-in-command. The unmarked transmission wire was a contributing factor.NTSB CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.NTSB CHI98LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-375 · Stephen, MNthe visual lookout not being maintained by the pilot. A factor to the accident was the transmission wire.NTSB CHI98LA198Accident · Serious injuriesLimited investigationFinal reportBell 47G · Le Center, MNthe pilot's failure to maintain clearance with the wire. A factor associated with the accident was the wire which the helicopter contacted.NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.NTSB CHI97LA192Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgregor, MNthe pilot's improper planning/decision, his failure to abort the takeoff while sufficient runway was remaining, and/or his failure to jettison his load in order to achieve sufficient climb rate to clear trees. His lack of certification and training to perform…NTSB CHI97FA059Accident · Minor injuriesField investigationFinal reportCessna 401 · Crystal, MNfailure of the pilot-in-command to ensure adequate removal of airframe ice from the aircraft during preflight.NTSB CHI96LA313Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNthe pilot's failure to maintain clearance from known transmission lines. Factors relating to this accident were the transmission lines and the sunglare which hindered the pilot's ability to see the transmission lines.NTSB CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.NTSB CHI95LA308Accident · No injuriesLimited investigationFinal reportLet L-23 Super Blanik · White Bear Lake, MNthe pilot's delayed retraction of the spoilers. Factors were the excessive sink rate and the power lines.NTSB CHI95LA245Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Oklee, MNthe pilot failed to maintain clearance with trees. Factors associated with the accident were the trees and the pilot's diverted attention.NTSB CHI95LA239Accident · Minor injuriesLimited investigationFinal reportK. Davey And B. Davey WAG-AERO · Hokah, MNthe pilot performing low altitude flight and the failure to maintain clearance with the trees. A factors associated with the accident was the trees.NTSB CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB CHI95LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · East Gull Lake, MNthe pilot's failure to maintain clearance from the trees. Factors in the accident were the crosswind and gusts.NTSB CHI95LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Cotton, MNthe pilot's failure to gain sufficient clearance over the trees during the aborted landing.NTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.NTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.NTSB CHI94LA276Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Sargeant, MNthe pilot's failure to maintain clearance from a transmission wire during an agricultural spray run. A factor in the accident is the transmission wire.NTSB CHI94LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Eden Prairie, MNThe pilot's poorly planned approach and remaining below a proper glide path during final approach. The pilot's lack of total expereince was a factor.NTSB CHI93LA240Accident · No injuriesLimited investigationFinal reportCessna R172K · Rice, MNThe pilot in command's failure to maintain proper clearance.NTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.NTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.