NTSB investigations, 1990, MN

11 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases per year

19822026
NTSB investigations, 1990, MN per year, 1982–2026: 112 cases
19825
19835
19846
19859
19868
19873
19886
19896
199011
19915
19924
19934
19948
19951
19965
19971
19985
19991
20002
20012
20022
20031
20046
20053
20062
20071

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\") = 1990
    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.

NTSB CHI90FA252Accident · 1 fatalField investigationFinal reportCessna 172N · Pine City, MNThe pilot's misjudgement of the fuel supply, and his failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the make and model of aircraft.Sep 2, 1990 · N733CH · DestroyedNTSB CHI90FA250Accident · 1 fatalField investigationFinal reportBeech A23A · St Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall/spin.Aug 30, 1990 · N8871M · Substantial damageNTSB CHI90LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fridley, MNEngine failure due to fuel exhaustion because of fuel consumption calculations mis-judged by the pilot in command. Contributing factors were unsuitable terrain and a railroad sign.Aug 29, 1990 · N2842D · Substantial damageNTSB CHI90LA227Accident · Minor injuriesLimited investigationFinal reportBeech BE 95 · Faribault, MNThe pilot's improper inflight decision and his improper execution of the chosen emergency procedure.Aug 12, 1990 · N9906R · Substantial damageNTSB CHI90DER04Accident · Minor injuriesFinal reportBD 4- Francisco BD-4 · Rosemount, MNFailure of the manufacturer (amateur built) to design fuel system adequately to prevent vapor lock in fuel line.Jul 31, 1990 · N853BF · Substantial damageNTSB CHI90DER03Accident · No injuriesFinal reportBell 47G3B1 · Coon Rapids, MNThe pilot-in-command's inaccurate fuel consumption calculations and misjudgement of his fuel supply.Jul 31, 1990 · N4990H · Substantial damageNTSB CHI90LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNThe pilot's failure to perform fuel consumption calculations which resulted in fuel exhaustion and subsequent loss of engine power. Factor was rough/uneven terrain.Jul 19, 1990 · N2134Z · Substantial damageNTSB CHI90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Moorhead, MNThe pilot's poor in-flight planning and fuel system monitoring, and his failure to maintain directional control during the subsequent forced landing.Jul 16, 1990 · N9873J · Substantial damageNTSB MKC90LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Cottage Grove, MNFuel exhaustion and remedial action not performed by the pilot in command.Jun 18, 1990 · N9977E · Substantial damageNTSB MKC90LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Two Harbors, MNPilot factor in that he failed to maintain flying speed.Apr 17, 1990 · N4020J · Substantial damageNTSB CHI90LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · Grygla, MNThe pilot's inadequate preflight preparation/planning, and subsequent fuel exhaustion due to an inadequate supply of fuel. The light condition at dusk, icy terrain (road) and tree were related factors.Mar 4, 1990 · N22923 · Substantial damage