Fatal NTSB investigations, MN
10 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 130)
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."highestInjuryLevel" = 'Fatal' 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" = 130) 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 CHI98FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Faribault, MNwas the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot.NTSB CHI97FA095Accident · 1 fatalField investigationFinal reportCessna 140 · Big Lake, MNThe pilot's maneuvers which exceeded the design stress limits of the airplane and resulted in structural overload of the horizontal tail followed by a structural overload of the wings.NTSB CHI96FA314Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Medford, MNfailure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: failure of the (primary) vacuum system and a restriction in the (standby) vacuum system.NTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.NTSB MKC90LA116Accident · 1 fatalLimited investigationFinal reportRollins-Bowers FLY Baby 1A · Bemidji, MNThe wing attachment bolts were not installed resulting in inflight wing separation.NTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…NTSB CHI88DER14Accident · 1 fatalFinal reportHomebuilt Woodstock · Mankato, MNAircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers.NTSB CHI87FA139Accident · 2 fatalField investigationFinal reportBell 47G · Dayton, MNAircraft collided with terrain after tailboom structure failed because of internal corrosion. The aircraft was not registered at the time of the accident and the pilot/operator failed to assure that proper or timely preventive maintenance was performed on the…NTSB CHI85FA251Accident · 1 fatalField investigationFinal reportNeumann-Everett N2 · Cambridge, MNThe newly rated prt plt was on his 12th flt in the recently certificated homebuilt that he had designed and built himself. While performing an unknown maneuver both horizontal stabilizers and both wings separated from the acft. The acft was restricted from…NTSB CHI82FA123Accident · 3 fatalField investigationFinal reportMooney M20J · Bird Island, MNThe aircraft departed thief rivers, MN and proceeded en route to new ulm, MN. One witness near the accident site heard a noise that sounded to him like an explosion. He and other witnesses in the vicinity saw the aircraft descending out of control in a roll…