NTSB investigations, 2005, OR
7 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 2 |
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\") = 2005
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\" = 130)
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") = 2005 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" = 130) 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 SEA06IA019Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-5 · Hillsboro, ORThe failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.NTSB SEA05CA195Accident · Minor injuriesData collectionFinal reportEiland RAF-200 Gyro · Bend, ORThe malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.NTSB SEA05CA191Accident · No injuriesData collectionFinal reportGleason Sky Star Kitfox · Klamath Falls, ORThe binding of the flaperon push pull tube due to deformation of the front seat, which resulted in a loss of control on takeoff initial climb and collision with the runway.NTSB SEA05LA188Accident · 1 fatalLimited investigationFinal reportKirner Fisher FP404 · Prineville, ORThe design stress limits of the aircraft were exceeded resulting in a wing separation while the pilot was accomplishing maneuvers of hard banking turns, spins and steep descents.NTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.NTSB SEA05LA058Accident · Minor injuriesLimited investigationFinal reportRotorway Exec 162F · Coos Bay, ORThe disintegration, for undetermined reasons, of the upper main drive pulley assembly bearing, while in cruise flight, leading to the decoupling of the main rotor drive assembly from the engine drive assembly. Factors include the absence of any suitable…NTSB SEA05LA056Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Prineville, OROther maintenance personnel's inadequate reassembly of the tail wheel assembly and the left main landing gear breaking assembly resulting in an inadvertent loss of control during the landing roll. Contributing factors were the pilot's inadvertent swerve…