NTSB investigations, 2022
35 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 57 |
|---|---|
| 2009 | 70 |
| 2010 | 70 |
| 2011 | 99 |
| 2012 | 79 |
| 2013 | 91 |
| 2014 | 61 |
| 2015 | 75 |
| 2016 | 56 |
| 2017 | 68 |
| 2018 | 63 |
| 2019 | 40 |
| 2020 | 35 |
| 2021 | 39 |
| 2022 | 35 |
| 2023 | 38 |
| 2024 | 39 |
| 2025 | 33 |
| 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\") = 2022
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2022 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA23WA038Accident · No injuriesClass 5 · ForeignBeech 95-B55 · Jraber township, ArmeniaNTSB GAA23WA035Accident · 1 fatalClass 5 · ForeignRotorway unk · Drummondville, CanadaNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNTSB ERA23FA048Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Harlan, KYThe pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…NTSB ANC23LA002Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-260 · Cordova, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA23FA006Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Arundel, METhe pilot’s loss of situational awareness, which resulted in an unstabilized approach, descent below published minimum altitudes, and collision with terrain.NTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyNTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB CEN22LA417Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Delta Junction, AKThe pilot’s decision to depart during high, gusty wind conditions which resulted sink and subsequent impact with terrain.NTSB ERA22FA397Accident · 1 fatalClass 3 · FieldFinal reportRotorway Jetexec · Arthur, KYThe pilot’s decision to attempt the cross-country flight in thunderstorm conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to obtain a weather briefing.NTSB WPR22LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Yellow Pine, IDThe pilot's failure to maintain clearance from a tree while maneuvering.NTSB CEN22LA374Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot’s failure to maintain proper approach glide path, which resulted in a collision with a berm.NTSB ERA22LA347Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Franklin, PAThe pilot’s inadequate visual lookout while flying at a low level over a river, which resulted in a wire strike.NTSB WPR22LA258Accident · 2 fatalClass 3 · LimitedFinal reportEvolution Revolt · Walter Springs, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike and impact with terrain.NTSB WPR22FA255Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7BCM · Lake McMurray, WAThe pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain.NTSB GAA22WA226Accident · 1 fatalClass 5 · ForeignCessna A188 · Puerto Lopez, ColombiaNTSB ANC22FA053Accident · 1 fatalClass 3 · FieldFinal reportChampion 7EC · Valdez, AKThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions which resulted in loss of control and collision with terrain.NTSB ERA22LA307Accident · No injuriesClass 3 · LimitedFinal reportMooney M20F · Cragsmoor, NYThe pilot’s decision to continue toward rising terrain despite observing the airplane’s decreased climb performance after takeoff, which resulted in flight into terrain.NTSB ERA22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Plymouth, CTThe pilot’s encounter with known and forecast adverse weather which resulted in a collision with trees during the initial climb.NTSB WPR22LA238Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA20 · Challis, IDThe pilot's turn towards rising terrain with limited climb performance and his subsequent failure to maintain clearance from terrain that resulted in an impact with terrain.NTSB GAA22WA247Accident · Serious injuriesClass 5 · ForeignPilatus PC6 · Papua, IndonesiaNTSB ENG22WA038Accident · 22 fatalClass 5 · ForeignDe Havilland DHC6 · Near Shikha, NepalNTSB CEN22LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Princeton, MNThe pilot’s failure to maintain proper approach glide path, which resulted in a collision with trees.NTSB GAA22WA200Accident · 1 fatalClass 5 · ForeignCessna TU206 · Macizo Del AuyáN-Tepui, VenezuelaNTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.NTSB ERA22LA179Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Manville, NJThe pilot’s delayed go-around decision following an encounter with a tailwind during landing, which resulted in an inability to climb and subsequent impact with trees.NTSB GAA22WA140Accident · 1 fatalClass 5 · ForeignCessna 208 · Gruehorn, SwitzerlandNTSB ANC22LA025Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172P · Kekaha, HIThe pilot’s improper decision to continue the visual-flight-rules flight into low visibility conditions, which resulted in controlled flight into terrain.NTSB ERA22FA160Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 369 · Loxahatchee, FLThe pilot’s failure to maintain clearance from power lines while maneuvering at low altitude.NTSB GAA22WA127Accident · 1 fatalClass 3 · ForeignCirrus SR22 · Ceresole, ItalyNTSB GAA22WA136Accident · 2 fatalClass 5 · ForeignCessna 210 · Tierra Nueva, MexicoNTSB CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.NTSB WPR22FA098Accident · 1 fatalClass 3 · FieldFinal reportBell UH-1H · Coalinga, CAThe pilot’s loss of situational awareness for reasons that could not be determined given the available evidence, which led to controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the helicopter while ill and…NTSB CEN22FA113Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Heath, OHThe pilot’s failure to maintain altitude after takeoff, which resulted in collision with trees and terrain.NTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.