NTSB investigations, MN
12 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1999 | 1 |
| 2002 | 2 |
| 2005 | 1 |
| 2006 | 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\" = 430)
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" = 430) 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 CHI06CA066Accident · No injuriesData collectionFinal reportCessna 120 · Hibbing, MNThe pilot used a rough frozen lake for takeoff which resulted in the overload failure of the landing ski. A factor was the rough frozen lake.NTSB CHI06LA027Accident · No injuriesLimited investigationFinal reportAgusta A109-E · Robbinsdale, MNThe loss of lift for undetermined reasons.NTSB CHI03LA031Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNThe cabin flight crew not verifying the galley service cart had been properly stowed prior to departure, which resulted in the inadvertent deployment of the galley service cart during initial climb after takeoff.NTSB CHI02LA298Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Little Falls, MNThe inadequate starting procedure by the pilot.NTSB CHI99LA209Accident · No injuriesLimited investigationFinal reportCessna 180A · White Bear Lake, MNthe pilot's inability to get the airplane to climb for undetermined reason, and the pilot landing the floatplane on the lake with the wheels extended. Factors contributing to this accident were the pilot's failure to perform a before landing checklist,…NTSB MKC89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Clear Lake, MNThe pilot's improper decision in attempting to land with inadequate visual cues which precluded identification of a correct runway alignment. A suitable alternative airport was readily available.NTSB CHI88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mankato, MNNTSB CHI85FA314Accident · 4 fatalField investigationFinal reportBeech J35 · Eden Prairie, MNThe plt's windscreen became covered with oil shortly after takeoff. The plt returned to the arpt attempting to set up a pattern for landing. The acft was observed in a descent and turn to final apch. The acft collided with the ground in a descending left…NTSB CHI84LA361Accident · No injuriesLimited investigationFinal reportBeech V35B · Eden Prairie, MNPlt reported that after operating the fuel boost pump on pre-flt, he exited the acft to turn the prop by hand. During a telephone interview, he stated he could not recall removing the ignition key. After pulling the prop through 1/4 turn, the eng started and…NTSB CHI84LA216Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes Firefly 8-24 · Burnsville, MNThe Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to…NTSB CHI82DA202Accident · Minor injuriesFinal reportCessna 150 · Cambridge, MNOn his first solo flight the student pilot stated he panicked at about 400 feet AGL and decided to land in a plowed field. During the landed sequence the aircraft nosed over.NTSB CHI82DA177Accident · Minor injuriesFinal reportBlanik L-13 · Warren, MNThe pilot was having difficulty controlling the glider during the tow and released prematurely. The destination was 12 to 14 miles away with 10-15 kt headwinds. When the pilot decided the destination could not be made a road was selected for a forced landing…