NTSB investigations, 2000
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\") = 2000
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") = 2000 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 ATL01LA013Accident · No injuriesLimited investigationFinal reportBeech BE-23-A24R · Jackson, MSDeer on the runway, which forced the pilot to make an evasive maneuver forcing him to the side of the runway and striking the marker lights.NTSB LAX01LA039Accident · No injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105CBS-5 · Parumph, NVThe pilot's failure to verify the presence of wires near the remote landing site during the high reconnaissance, and his misjudgement of the clearance from the ground during the attempted hovering turn to avoid the wire obstacle. Factors were the dark night…NTSB CHI01LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pulaski, WIthe evasive maneuver initiated by the pilot. Factors were the presence of the skydiver on the runway, and the pilot's selection of a closed runway.NTSB ANC00LA132Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-3 · Ketchikan, AKThe pilot's inadvertent activation of the collective flight stop/emergency fuel augmentation switch, which resulted in engine and main rotor overspeeds, thereby precipitating failures of the tail rotor drive shaft coupling and power turbine blades. A factor…NTSB CHI00LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 737-322 · Chicago, ILthe evasive maneuver performed by the pilot. A factor was the activation of the collision avoidance system.NTSB CHI00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Harbor Springs, MIthe pilot selected the wrong runway direction in which to land and he did not perform a go-around when he realized the landing approach was too high. Factors associated with the accident were the tailwind condition, the improper glidepath, and the intentional…NTSB ANC00LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKA bear running onto the landing area during the landing flare. A factor associated with the accident was the high vegetation on the edge of the airstrip.NTSB ANC00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's excessive application of heel brakes. A factor associated with this accident was the pilot's lack of experience in the make and model of airplane.NTSB IAD00IA032Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · New York City, NYThe first officer's failure to maintain control of the airplane during climb out over water at night, which was a result of spatial disorientation. Factors in the incident were the cloud layer and dark night.NTSB MIA00FA102Accident · 2 fatalField investigationFinal reportMcDonnell Douglas HU-600N · Miami, FLThe pilot's ostentatious display and in-flight decision to perform an abrupt low altitude pitch up maneuver (aerobatic flight). This resulted in the main rotor blades colliding with and separating the tail boom assembly while maneuvering, and the helicopters…