NTSB investigations, 2024
8 cases where the defining event was Abrupt maneuver.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 10 |
| 2011 | 11 |
| 2012 | 7 |
| 2013 | 9 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 12 |
| 2019 | 8 |
| 2020 | 3 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 3 |
| 2024 | 8 |
| 2025 | 5 |
| 2026 | 3 |
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\") = 2024
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 year(c."eventDate") = 2024 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 WPR24LA305Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Cottonwood, AZThe pilot’s evasive maneuver to avoid birds while on final approach at a low altitude, which resulted in the airplane colliding with a tree.NTSB DCA24LA241Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Orlando, FLThe captain’s inadvertent aggressive application of the brakes during taxi which resulted in a sudden stop. Contributing to the accident was the flight attendants’ failure to notify the flight crew of the unsecure cabin.NTSB DCA24WA176Incident · Minor injuriesClass 5 · ForeignBoeing 777 · London, United KingdomNTSB DCA24WA214OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB DCA24WA125Accident · Serious injuriesClass 3 · ForeignBoeing 787 · Auckland, New ZealandNTSB DCA24WA216OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB CEN24LA097Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kenosha, WIThe pilot’s failure to maintain control of the helicopter while landing.