NTSB investigations, 2024
27 cases where the defining event was Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 41 |
|---|---|
| 2009 | 58 |
| 2010 | 49 |
| 2011 | 80 |
| 2012 | 66 |
| 2013 | 76 |
| 2014 | 45 |
| 2015 | 60 |
| 2016 | 47 |
| 2017 | 44 |
| 2018 | 50 |
| 2019 | 33 |
| 2020 | 32 |
| 2021 | 35 |
| 2022 | 30 |
| 2023 | 29 |
| 2024 | 27 |
| 2025 | 28 |
| 2026 | 26 |
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\" = '120')
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" = '120') 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 ANC25FA010Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 208B · Honolulu, HIOn December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…NTSB GAA25WA032Accident · 5 fatalClass 5 · ForeignCessna U206 · Cantón Central San José y Distrito de Pavas, Costa RicaNTSB CEN25FA047Accident · 2 fatalClass 3 · FieldFinal reportCessna 182T · Drake, COThe pilot’s failure to maintain airplane control while maneuvering in mountainous terrain. Contributing was mountain wave turbulence in the area.NTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB GAA25WA013Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Ouro Preto - Minas Gerais, BrazilNTSB ANC24FA094Accident · 4 fatalClass 3 · FieldPreliminary reportCessna 207 · Saint Mary's, AKOn September 15, 2024, about 2204 Alaska daylight time, a Cessna 207 airplane, N90193, was destroyed when it was involved in an accident near St. Mary’s, Alaska. The pilot and three passengers were fatally injured. The flight was operated as a Title 14 Code…NTSB ERA24LA346Accident · 1 fatalClass 4 · LimitedFinal reportPiper J3 · Mooresburg, TNThe pilot’s intentional flight into a building as an act of suicide.NTSB DCA24WA333Incident · No injuriesClass 3 · ForeignATR ATR72 · Bhubaneswar, IndiaNTSB GAA24WA245Accident · 2 fatalClass 5 · ForeignLearjet 35 · Matupa, BrazilNTSB GAA24WA225AccidentClass 5 · ForeignBriten-Norman BN2A-20 · Bouffa, VanuatuNTSB GAA24WA231AccidentClass 5 · ForeignCessna 172 · La Aurora, GuatemalaNTSB ERA24LA297Accident · 1 fatalClass 4 · LimitedFinal reportBuckeye Dream Machine · Bainbridge, GAThe non-certificated pilot’s failure to maintain adequate clearance from powerlines while maneuvering at low altitude. Contributing to the accident was the pilot’s impairment due to alcohol and methamphetamine use.NTSB ERA24FA292Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · Lock Haven, PAThe student pilot’s premature turn to the crosswind leg of the traffic pattern at low airspeed and altitude, resulting in a collision with trees and terrain.NTSB WPR24LA221Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Running Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.NTSB GAA24WA220Accident · 1 fatalClass 5 · ForeignRobinson R22 · Brasil Novo, BrazilNTSB WPR24FA195Accident · 2 fatalClass 3 · FieldFinal reportLuscombe 8A · South Lake Tahoe, CAThe pilot’s decision to continue low-altitude flight toward rising mountainous terrain in high density altitude conditions, which resulted in collision with trees and terrain.NTSB WPR24FA190Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Elk River, IDThe pilot’s failure to maintain clearance from terrain while climbing in mountainous terrain during moderately high density altitude conditions, and conditions conducive to severe carburetor icing.NTSB GAA24WA179Accident · 2 fatalClass 5 · ForeignPiper PA-34-200T · Santa Rosa, EcuadorNTSB GAA24WA133Accident · 1 fatalClass 4 · ForeignCessna 172 · La Linea, ChileNTSB ERA24FA136Accident · 5 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Hot Springs, VAThe PIC’s continuation of an unstabilized approach in gusting wind conditions and his failure to monitor the airplane’s altitude during the approach, which led to a descent into terrain short of the runway. Contributing was the flight crew’s failure to set…NTSB WPR24LA094Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · Valley Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude and inadvertently entering a box canyon where the airplane could not outclimb the rising terrain.NTSB CEN24LA116Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Laotto, INThe pilot’s improper decision to continue an approach with his vision obscured by sun glare, which resulted in a collision with a tree.NTSB WPR24LA090Accident · No injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Lewistown, MTThe pilot’s failure to maintain clearance from terrain. Contributing to the accident was the pilot’s encounter with low light conditions and snow-covered terrain.NTSB GAA24WA095Accident · 2 fatalClass 5 · ForeignCessna U206 · Canaima, VenezuelaNTSB GAA24WA131Accident · 9 fatalClass 5 · ForeignBeech E90 · Lote Ocho, MexicoNTSB ERA24FA096Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Weston, FLThe pilots’ spatial disorientation in dark night visual meteorological conditions, which resulted in their failure to maintain altitude and a subsequent descent and impact with a swamp.NTSB GAA24WA070AccidentClass 5 · ForeignThrush S2R · Región del Maule, Chile