NTSB investigations, 1997
7 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 5 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 4 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 1 |
Where
Open the mapLatest 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\") = 1997
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\" = 110)
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") = 1997 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" = 110) 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 IAD98LA014Accident · Minor injuriesLimited investigationFinal reportJones Mini 500 · Bluefield, WVPilot's unfamiliarity with reciprocating engine powered helicopter lead to a reduction in main rotor rpm and subsequent uncontrolled rate of descent with insufficient altitude to recover.NTSB FTW98LA033Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Counselor, NMthe pilot inadvertently allowing the helicopter to settle with power.NTSB CHI97LA285Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE-ATP · Peru, ILsudden/unexpected encounter with clear air turbulence.NTSB IAD97LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Willimantic, CTThe student pilot misunderstood the flight instructor's instructions and reduced the engine power to idle, and the Certificated Flight Instructor's delayed remedial action.NTSB IAD97FA060Accident · 1 fatalField investigationFinal reportCessna 337D · Hickory, PAServicing of the pilots portable oxygen system with compressed air, which resulted in pilot incapacitation due to Hypoxia.NTSB LAX97LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works AX-8B · Parker, AZthe pilot's inadequate in-flight planning, which resulted in an excessive descent and subsequent hard landing, due to a drop in fuel pressure along with shifting winds at low altitude.NTSB CHI97FA058Accident · 2 fatalField investigationFinal reportMooney M20J · Cottage Grove, MNfailure of the pilot to maintain control of the airplane during an ILS approach. Factors relating to the accident were: the IFR weather conditions, the pilot's lack of recent instrument experience, and the pilot's lack of familiarity in flying the accident…