NTSB investigations, 1989
10 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\") = 1989
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") = 1989 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 FTW90LA020Accident · No injuriesLimited investigationFinal reportCessna 150H · Mountain Home, TXLack of airspeed for a climb to clear obstacles off the departure end of the runway, resulting in a precautionary landing into unsuitable terrain. The inadequate airspeed was a result of an encounter with deer during the take off and the pilots vertical…NTSB FTW90LA016Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Friona, TXThe pilot's decision to perform an aerobatic maneuver during initial climb out with inadequate altitude for recovery.NTSB FTW89LA174Accident · No injuriesLimited investigationFinal reportBell 206BII · Grand Prairie, TXThe pilot's decision to execute an abrupt maneuver while hovering downwind, which led to a reduction in rotor RPM and subsequent hard landing.NTSB BFO89FA079Accident · Serious injuriesField investigationFinal reportBell 206B-III · White Plains, MDThe pilot's failure to follow procedures in that he delayed his climb during a night takeoff from a confined area. Contributing factor(s) was: the dark night and surrounding obstructions.NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.NTSB ANC89FA084Accident · 1 fatalField investigationFinal reportStinson 108-2 · Wasilla, AKPilot failed to operate the aircraft within its recommended parameters, resulting in loss of control and a stall-spin into the water.NTSB ATL89LA154Accident · 1 fatalLimited investigationFinal reportBoeing E75 (PT-13D) · Jacksonville, NCThe pilot encountered an accelerated stall during an abrupt maneuver, lost control of the airplane and did not have sufficient altitude to recover from the ensuing spin prior to colliding with the ground.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB DEN89FA093Accident · 2 fatalField investigationFinal reportCessna 177RG · Albuquerque, NMThe pilot's improper use of flaps during takeoff which resulted in inadequate airspeed, a stall, and loss of control.NTSB DEN89IA067Incident · No injuriesIncident investigationFinal reportBoeing 707-323B · Salt Lake City, UTThe pilot-in-command's attempt to align the airplane with the runway at an altitude insufficient for safe maneuvering, resulting in the no. 1 engine striking the runway. Contributing factors include obscured visibility due to fog, the captain's loss of depth…