NTSB investigations, CA
15 cases where the defining event was Abrupt maneuver.
Cases per year
| 2010 | 2 |
|---|---|
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '270')
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '270') 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 WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.NTSB WPR21FA300Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Colusa, CAThe pilot’s abrupt flight control input that led to mast bumping and a subsequent in-flight breakup.NTSB WPR18FA171Accident · 2 fatalClass 2 · FieldFinal reportBeech A35 · Hesperia, CAThe pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…NTSB WPR18FA093Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · San Diego, CAThe pilot's exceedance of the airplane's critical angle of attack during an attempted return to the runway following a total loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the excessive amount of…NTSB WPR17FA120Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Santa Rosa Valley, CAThe pilot's exceedance of the airplane's critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB WPR17FA101Accident · 2 fatalField investigationFinal reportIcon A5 · Lake Berryessa, CAThe pilot's failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot's mistaken entry into a canyon surrounded by steep rising terrain while at a low altitude for reasons that could not be…NTSB WPR15LA116Accident · Serious injuriesLimited investigationFinal reportBell 47G 2A · Ivanhoe, CAThe pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.NTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.NTSB WPR14CA256Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe pilot's failure to maintain aircraft control while maneuvering for landing.NTSB WPR13FA300Accident · 2 fatalField investigationFinal reportAllstar PZL Glider SZD-54-2 Perkoz · Jacumba, CAThe premature release of the towline from the glider and the glider’s subsequent right banking turn at low altitude for reasons that could not be determined because postaccident airframe examination did not reveal any evidence of a mechanical malfunction or…NTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.NTSB WPR11LA216Accident · No injuriesLimited investigationFinal reportDralle RV-8 · Livermore, CAThe pilot's decision to exit the runway while still traveling at an excessive speed and his subsequent loss of directional control.NTSB WPR10FA217Accident · 1 fatalField investigationFinal reportPiper PA-30 · Merced, CAPilot incapacitation due to the combined effect of multiple unreported medical conditions.NTSB WPR10LA134Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Santa Clarita, CAThe pilot’s abrupt airplane pitch change maneuver. Contributing to the accident was the flight crew’s failure to maintain the heading specified by the air traffic controller, which would have avoided the near collision course with an unidentified airplane…