NTSB investigations, 2003, MN

5 cases where the first occurrence was “Loss of engine power”.

Cases per year

19822026
NTSB investigations, 2003, MN per year, 1982–2026: 80 cases
19825
19833
19843
19862
19872
19894
19903
19915
19921
19931
19941
19961
19973
19986
19993
20003
20018
20029
20035
20043
20052
20063
20074

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\") = 2003
    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\" = 350)
  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 CHI03LA305Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Pine River, MNAn inadequate pre-flight inspection by the pilot due to his failure to visually confirm fuel quantity prior to flight, and the resulting fuel exhaustion. Contributing factors were the pilot's improper use of the fuel management computer installed in the…Sep 9, 2003 · N5360U · Substantial damageNTSB CHI03LA213Accident · 1 fatalLimited investigationFinal reportAllenberg Swick BC 12-D · Winsted, MNThe inadequate aircraft preflight by both pilots of the closed main fuel valve which led to fuel starvation of the engine. Additional causes were the lack of recent experience in the accident airplane and the inadvertent stall by both pilots after a loss of…Jul 16, 2003 · N7895A · DestroyedNTSB CHI03LA192Accident · Serious injuriesLimited investigationFinal reportDebay Dragonfly Mark II · Eden Prairie, MNThe pilot's intentional operation of the airplane with a known deficiency with regard to an improper carburetor calibration that led to the loss of engine power. The improperly calibrated carburetor and the trees were contributing factors.Jul 3, 2003 · N25JD · Substantial damageNTSB CHI03LA106Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Benson, MNThe loss of engine power for undetermined reasons.Apr 13, 2003 · N5519X · Substantial damageNTSB CHI03LA087Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Mankato, MNFuel exhaustion due to the pilot's inadequate preflight and not verifying the airplane had been refueled.Mar 20, 2003 · N553RA · Substantial damage