NTSB investigations, 1985, MN
9 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 5 |
| 1984 | 6 |
| 1985 | 9 |
| 1986 | 8 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 11 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 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 year(c.\"eventDate\") = 1985
AND 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\" = 353)
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 year(c."eventDate") = 1985 AND 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" = 353) 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 CHI85FER03Accident · Minor injuriesFinal reportUnivair 108-1 · Mcgregor, MNThe acft contacted trees off the departure end of rwy 18 during a forced landing following a loss of pwr on takeoff. Post accident inspection revealed the fuel selector was positioned for the left tank and the left tank contained no fuel. The carburetor did…NTSB CHI85LA377Accident · Minor injuriesLimited investigationFinal reportWippler Cassut III M · Randall, MNThe engine lost power when the pilot attempted to add power at the completion of a descent. The pilot did not use carburetor heat in the descent. The relative humidity was approximately 60%.NTSB CHI85LA352Accident · No injuriesLimited investigationFinal reportHughes 269A · Hector, MNAfter liftoff from an open field, on a short local flight the helicopter experienced fuel exhaustion. During the auto rotation landing, in an open field the helicopter rolled on the side.NTSB CHI85LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPilot had dept with minimum fuel for the 60 mi x-country flt. He overflew dest by 25 mi and after correcting course ran out of fuel 2 mi short of the aprt. While landing on a country road acft veered into a ditch.NTSB CHI85LA319Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Madelia, MNDuring cruise engine power was lost. The pilot was unable to restart the engine. During landing in an oats field the acft nosed over.NTSB CHI85FA269Accident · 2 fatalField investigationFinal reportChamberlain Viking Dragonfly · Faribault, MNThe acft collided with trees and burst into flames during a forced landing. On the plt's second radio contact with Faribault municipal airport UNICOM he declared, 'I have engine failure. I'm going down in a corn field.' Post accident inspection of the…NTSB CHI85LA278Accident · No injuriesLimited investigationFinal reportGrumman TR2 · Crookston, MNThe acft nosed over in a fld during a forced landing following a total loss of pwr. The plt reported the fuel consumption during the flt seemed higher than usual. He then began looking for Crookston municipal arpt to land. Aprx 3 miles se of the arpt the pwr…NTSB CHI85LA260Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roseau, MNThe plt intentionally ground looped the acft during a forced landing to avoid obstacles following a loss of power en route. Aprx 1 1/2 hrs into the flt the plt noticed an engine roughness followed by an increase in oil temp which returned to normal shortly…NTSB CHI85LA200Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Golden Valley, MNShortly after takeoff, on the last leg on it's flight, the engine of the air cargo acft started to sputter. The plt turned the fuel selector handlr from the left tank to another position & turned on the boost pump. The engine stopped running & the plt elected…