NTSB investigations, MN
22 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 2 |
| 1988 | 2 |
| 1991 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 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\" = 320)
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" = 320) 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 CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB CHI06CA197Accident · No injuriesData collectionFinal reportCessna 206H · Lutsen, MNThe unsuitable terrain the pilot encountered during takeoff in rough water. A factor was the wave in the rough water.NTSB CHI06CA104Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Tower, MNThe unsuitable landing area selected by the pilot which led to the subsequent nose-over. The terrain condition was a factor.NTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.NTSB CHI03LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Paul, MNThe student pilot failed to maintain directional control. A factor was the runway sign.NTSB CHI03CA004Accident · No injuriesData collectionFinal reportCessna 182E · Oslo, MNFailure of the pilot-in-command to maintain directional control during the landing roll. Contributing factors were the wind gust and the soft terrain adjacent to the runway.NTSB CHI00LA198Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Dell, MNthe failure of the pilot to maintain clearance with the terrain.NTSB CHI98LA316Accident · Minor injuriesLimited investigationFinal reportWakely DR-107 · Stanton, MNthe pilot's misjudging recovery from a bounced landing. Factors were the partial failure of the propeller and a crop field.NTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…NTSB CHI95LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Baudette, MNan encountered with a hidden obstruction during taxi. A factor was the ski assembly not having been installed.NTSB CHI94DER02Accident · No injuriesFinal reportAir Tractor AT-301 · Halstad, MNthe commercial pilot's failure to maintain clearance from terrain during the attempted takeoff. Related factors are the soft terrain and the deterioration in aircraft performance due to the high gross weight.NTSB CHI92LA055Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Roseau, MNThe pilot's failure to maintain proper alignment with, and not selecting the proper touchdown point on the landing runway. Factors associated with the accident are a dark night light condition and crosswinds.NTSB CHI91DER12Accident · Serious injuriesFinal reportLacey B D4 · Albert Lea, MNThe pilot's failure to take adequate remedial action. Related factors are the tall grass runway conditions, and the inadequate airspeed.NTSB CHI91LA128Accident · No injuriesLimited investigationFinal reportDe Havilland Beaver U-6A · Oak Island, MNUnsuitable terrain was selected by the pilot. A factor related to the accident was the terrain/runway was composed of weak ice.NTSB CHI89LA017Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Mora, MNNTSB CHI88LA136Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC2-MK I · Warroad, MNThe pilot decided to land in the lake approximately 1000 yds from the sea plane base and was attempting a step-taxi back to the base when the acft struck a sand bar. The pilot stated that he was taxiing near tall grass where he thought the water was deep…NTSB CHI86FER05Accident · Serious injuriesFinal reportCessna A188B · Greenbush, MNThe plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient…NTSB CHI86IA115Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Minneapolis, MNN508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.…NTSB CHI84LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sauk Rapids, MNThe plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over.NTSB DCA83AA013Accident · 1 fatalFinal reportConvair 580-11-A · Brainerd, MNDuring arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right…NTSB CHI82DA289Accident · No injuriesFinal reportCessna 150 · Caledonia, MNThe pilot stated that the wind was from about 135 deg at 10 KTS. He stated he made a mistake and landed on runway 31 instead of 13. Reportedly, his touchdown was too FAR down the runway for a safe landing. He initiated a go-around but the stall warning horn…NTSB CHI82DA248Accident · No injuriesFinal reportCessna 182C · Deer River, MNThe pilot reported that when he was briefed by the flight service station, he was told the ceilings were low, but VFR conditions were expected by 1000 CDT. The pilot departed at 0850 CDT in weather conditions that he estimated to be 1000 ft overcast with 8 mi…