NTSB investigations, MN
24 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 1 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 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\" = '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\" = 310)
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" = 310) 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 CHI07CA253Accident · No injuriesData collectionFinal reportCessna 180A · Duluth, MNThe pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.NTSB CHI03LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Waskish, MNThe inadequate preflight planning/preparation by the pilot. Contributing factors were the snow covered takeoff area and the tailwind.NTSB CHI02LA173Accident · No injuriesLimited investigationFinal reportBeech BE90 · Roseau, MNAn inadvertent collision with a deer during the landing roll.NTSB CHI02LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Minneapolis, MNThe pilot did not maintain clearance from the vehicle while taxiing. A factor was the fuel truck.NTSB CHI01FA129Accident · Minor injuriesField investigationFinal reportDouglas DC-9-31 · Minneapolis, MNThe partial failure of the aircraft tug for undetermined reasons.NTSB CHI99LA259Accident · No injuriesLimited investigationFinal reportCessna 180 · Tower, MNfailure of the operator of the boat to maintain clearance with the floatplane.NTSB CHI98LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Mankato, MNthe pilot's inadequate compensation for the wind conditions and not maintaining proper alignment. Factors contributing to the accident were the snow covered terrain and the lack of depth perception it produced.NTSB CHI98LA042Accident · No injuriesLimited investigationFinal reportMooney M20K · Eden Prairie, MNthe pilot's improper decision to continue the approach beyond decision height, when he could not see the runway; and his attempt to land without being properly aligned on the runway. Factors relating to this accident were: darkness, fog and and runway lights.NTSB CHI97LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNthe pilot's misjudgment of his clearance around the parked vehicle. A factor was the location of the parked vehicle.NTSB CHI96LA050Accident · No injuriesLimited investigationFinal reportBeech B90 · Eden Prairie, MNthe pilot's failure to maintain clearance with the hangar while taxiing. A factor associated with the accident was the pilot's impairment due to alcohol.NTSB CHI95LA170Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-211 · St Paul, MNthe captain's not maintaining crew/group coordination. Factors were the captain's diverted attention and his not maintaining visual separation.NTSB CHI95LA094Accident · No injuriesLimited investigationFinal reportBeech 1900 · Minneapolis, MNthe pilot-in-command's failure to maintain clearance from obstacles during taxi operations. Related factors are the dark night light conditions and the wrong taxi route.NTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.NTSB CHI91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Morgan, MNA guy wire was struck on takeoff because of inadequate clearance. Factors related to the accident were poor planning/decision by the pilot and over confidence in personal ability.NTSB MKC90LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNInadequate visual outlook by the pilot and his failure to maintain clearance from the light pole. The location of the pole was considered to be a related factor.NTSB MKC90LA014Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Brooten, MNThe pilot's failure to use proper starting procedures and the excessive throttle setting.NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.NTSB CHI88FA233Accident · No injuriesField investigationFinal reportBoeing 727-200 · Minneapolis, MNFailure of the captain to follow company pushback procedures and not getting a release before starting to taxi.NTSB CHI88FA163Accident · No injuriesField investigationFinal reportBoeing 727 · St Paul, MNAfter push back from the gate, the captain received an unrestricted taxi clearance & elected to taxi to the north side of a construction area. Subsequently, the left wing of the acft struck a parked vehicle in a nonmovement area, which resulted in substantial…NTSB CHI88LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Buffalo, MNNTSB CHI85LA362Accident · No injuriesLimited investigationFinal reportBeech A36 · Mankato, MNThe plt of this acft attempted to start the eng twice with acft battery and a ground pwr unit without success. He then tied the tail down with a rope and had started the eng. After the eng started, the tie down rope broke and the acft taxied by itself into…NTSB CHI83IA300Incident · No injuriesIncident investigationFinal reportBeech H-35 · Graceville, MNOn landing roll on slick grass with a crosswind the acft slid to the right and the right wing tip struck a tree.NTSB CHI83LA136Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Northome, MNThe acft collided with a snowbank while landing on the airport at Northome, MN. There was no UNICOM at Northome and NOTAMS advised the runway was closed. The weather was VMC but overcast with freezing rain. The pilot reported he made a precautionary landing…NTSB CHI82DER20Accident · No injuriesFinal reportCessna 188B · Hallock, MNDuring landing roll to investigate a stalled truck, the aircraft collided with the truck which backed into the aircraft's roll out path. After the collision, the aircraft ran into a ditch.