NTSB investigations, 2000, OR

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, 2000, OR per year, 1982–2026: 109 cases
1982	2
1983	2
1984	2
1985	7
1986	4
1987	2
1988	2
1991	4
1992	4
1993	3
1994	2
1995	5
1996	4
1997	7
1998	7
1999	3
2000	8
2001	4
2002	9
2003	4
2004	6
2005	7
2006	4
2007	7

Where

Open the map

Latest cases

Query with SQL

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") = 2000 AND c."eventStateOrRegion" = 'OR' 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

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\") = 2000
    AND c.\"eventStateOrRegion\" = 'OR' 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.

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") = 2000
  AND c."eventStateOrRegion" = 'OR' 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

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 SEA00LA176Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ontario, ORThe pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.Sep 13, 2000 · N22237 · Substantial damage NTSB SEA00LA166Accident · No injuriesLimited investigationFinal reportFairchild 24G · Cascade Locks, ORThe pilot's failure to apply carburetor heat after experiencing a partial power loss while flying under conditions conducive to the formation of carburetor ice. Factors include the presence of carburetor icing conditions and an expanse of water (Columbia…Aug 18, 2000 · N4714 · Substantial damage NTSB SEA00LA157Accident · No injuriesLimited investigationFinal reportHamer Lancair 235 · Chiloquin, ORLoss of engine power due to a fracture and separation of the engine's crankshaft. A factor was a vehicle on the roadway.Aug 10, 2000 · N84LH · Substantial damage NTSB SEA00LA150Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oregon City, ORA loss of engine power for undetermined reason(s). A factor was the rough/uneven terrain.Aug 2, 2000 · N1927Y · Substantial damage NTSB SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.Jul 30, 2000 · N90345 · Substantial damage NTSB SEA00LA143Accident · Serious injuriesLimited investigationFinal reportJim Weseman Challenger II · Chiloquin, ORLoss of engine power for undetermined reasons. Unsuitable terrain and the pilot's failure to maintain aircraft control were factors.Jul 23, 2000 · UNREG · Substantial damage NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.Jul 21, 2000 · N731GR · Substantial damage NTSB SEA00LA084Accident · No injuriesLimited investigationFinal reportOveross Vans RV-8 · Independence, ORThe rotation of the right fuel tank elbow fitting within the tank during previous maintenance. The improper alignment resulted in the fuel pick-up tube being mis-positioned and a subsequent starvation of fuel to the engine. Contributing factors were the…May 7, 2000 · N998TT · Substantial damage