NTSB investigations, 1997
9 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 19 |
| 1986 | 27 |
| 1987 | 25 |
| 1988 | 19 |
| 1989 | 10 |
| 1990 | 14 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 13 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 11 |
| 1999 | 5 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 4 |
| 2005 | 12 |
| 2006 | 4 |
| 2007 | 4 |
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\" = 100)
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" = 100) 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 ANC97FA159Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…NTSB CHI97FA300Accident · 2 fatalField investigationFinal reportBeech T34B · Fremont, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.NTSB CHI97LA225Accident · No injuriesLimited investigationFinal reportSorrell SNS-7 · Tomahawk, WIThe pilot encountered a tailplane stall. The factors involved were the pilot conducted a low altitude flight maneuver and encountered engine torque effect.NTSB ANC97LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Fairbanks, AKThe pilot's initiation of an abrupt, evasive maneuver, and his failure to maintain directional control of the airplane. Factors in the accident were an undetermined object crossing the runway and the passenger's rudder control interference during the evasive…NTSB LAX97GA235Accident · 1 fatalFinal reportBell BHT-206L-1 · Highland, CALoss of engine power due to fuel contamination. Also causal was the ingestion of entrapped air that occurred during an abrupt maneuver and fuel-borne contamination that caused the fuel system check valves to leak, resulted in a lower than expected fuel level…NTSB LAX97LA227Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Jacumba, CAThe pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.NTSB FTW97FA207Accident · 1 fatalField investigationFinal reportCanadair F-86E MK.6 · Broomfield, COInadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.NTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.NTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.