NTSB investigations, 1998
11 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\") = 1998
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") = 1998 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 MIA99LA039Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Fort Lauderdale, FLan abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.NTSB CHI99LA027Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Monticello, INlow altitude stall and an ostentatious display by the pilot. Factors associated with this accident were the performance of a low altitude maneuver and an abrupt pullup by the pilot.NTSB IAD98GA110Accident · 1 fatalFinal reportHughes OH-6A · Newark, TXFailure of the Instructor Pilot to control the helicopter's rate of descent during a demonstrated autorotation. Contributing to the accident were the Operator's lack of: a. Instructor Pilot standardization procedures, and b. Specific or adequate flight…NTSB ANC98LA155Accident · No injuriesLimited investigationFinal reportPiper PA-12 · New Stuyahok, AKThe pilot's selection of an unsuitable takeoff area and his intentional ground loop maneuver. A factor associated with the accident was trees.NTSB NYC98LA169Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Jackson Twnshp, NJThe flight (check pilot) instructor's excessive pull-up maneuver and his inadvertent entry into a low altitude stall/spin.NTSB IAD98FA086Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Stevensville, MDThe pilot-in-command's failure to maintain aircraft control while buzzing a building.NTSB ANC98FA079Accident · 1 fatalField investigationFinal reportCessna 185 · Big Lake, AKThe pilot's performance of a low level maneuver. Factors were the pilot's overconfidence in his personal ability, his lack of experience in the type of airplane, and his failure to maintain adequate clearance from terrain.NTSB LAX98FA171Accident · 2 fatalField investigationFinal reportVans RV-8 · Ripley, CAthe intentional or unintentional sudden application of aft elevator control by an undetermined aircraft occupant that exceeded the design stress limits of the aircraft. The aircraft gross weight, which exceeded the maximum allowable for aerobatics, and…NTSB IAD98FA061Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Manassas, VAThe pilot's failure to maintain adequate altitude/clearance during an aerobatic maneuver.NTSB IAD98FA049Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Stevensville, MDThe pilot's abrupt, low-g maneuver, which resulted in mast bumping and separation of the main rotor system.NTSB LAX98LA132Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Prescott, AZThe pilot's failure to attain directional control after swerving off the runway and impacting a ditch.