NTSB investigations, 2000, OR
6 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 12 |
| 1984 | 12 |
| 1985 | 4 |
| 1986 | 8 |
| 1987 | 8 |
| 1988 | 7 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 6 |
| 1992 | 9 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 7 |
| 1996 | 10 |
| 1997 | 8 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 8 |
| 2005 | 11 |
| 2006 | 6 |
| 2007 | 8 |
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\") = 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\" = 250)
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" = 250) 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 SEA00LA186Accident · 1 fatalLimited investigationFinal reportde Havilland DH-100 MK.6 · Ontario, ORThe pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.NTSB SEA00LA174Accident · No injuriesLimited investigationFinal reportBeard Lancair 320 · Bend, ORThe pilot's failure to take adequate remedial action upon encountering aircraft control difficulties during landing. Factors included gusty wind conditions and the pilot's failure to maintain aircraft control during landing.NTSB SEA00LA112Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Boardman, ORThe pilot's failure to maintain adequate airspeed through an area of turbulence, resulting in entry into a stall/mush condition. Factors included tailwind conditions, trees at the end of the runway, terrain-induced turbulence, and crops near the airstrip.NTSB SEA00LA107Accident · 1 fatalLimited investigationFinal reportHaessler Cosmo Phase II · Banks, ORThe pilot's improper installation, i.e., reversed connection, of the rudder control cables resulting in reverse rudder operation and a subsequent stall/spin. A contributing factor was the pilot's intentional design change/addition of a rudder to the aircraft.NTSB SEA00LA079Accident · No injuriesLimited investigationFinal reportMorton Christavia Mark I · Salem, ORThe pilot/builder's failure to correct the center of gravity computations after a weight increase. A contributing factor was the pilot/builder's exceeding the forward CG limit in fuel weight, of which both conditions resulted in a degradation of aircraft…NTSB SEA00FA039Accident · 2 fatalField investigationFinal reportMooney M20K · Pendleton, ORThe pilot's failure to adequately remove ice and snow from the airplane. A contributing factor was the pilot's inability to maintain control during climb due to degradation of the airplane's aerodynamic performance.