NTSB investigations
856 cases where the defining event was Controlled flight into terr/obj (CFIT).
Cases, newest first
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.\"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 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 WPR12WA334Accident · 1 fatalForeign investigationPiper PA34 · Broome, Australia, AustraliaOn July 11, 2012, at 2020 universal coordinated time, a Piper PA-34-200, VH-LCK, collided with terrain near Broome, Australia. The airplane was a charter flight operating under the pertinent civil regulations of Australia. The pilot was fatally injured and…NTSB ERA12WA463Accident · 1 fatalClass 5 · ForeignPiper PA36 · San Alberto, ColombiaOn July 10, 2012, about 1230 universal coordinated time, a Piper PA-36-375, Colombian registration HK2210, operated by Aeropenort LTDA. Agropecuaria del Norte, was substantially damaged when it collided with trees, during an aerial application flight near San…NTSB ERA12WA444Accident · 2 fatalForeign investigationLancair · Concepcio, ArgentinaOn July 3, 2012, about 1230 coordinated universal time (0930 local time), a Lancair IV-P, Argentine registration LV-X243, was substantially damaged when it impacted terrain in Concepcion, Corrientes Province, Argentina. The pilot and the passenger were…NTSB ERA12FA409Accident · 1 fatalField investigationFinal reportRaytheon C90GT · Morgantown, WVThe pilot's inadequate preflight route planning and in-flight route and altitude selection, which resulted in an in-flight collision with a communications tower in possible instrument meteorological conditions. Contributing to the accident were the pilot's…NTSB WPR12FA255Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Mountain Home, IDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB CEN12CA347Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Sellersburg, INThe balloon pilot’s failure to maintain clearance from power lines.NTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.NTSB CEN12FA311Accident · 1 fatalField investigationFinal reportCessna T210L · Boyd, TXThe pilot’s delayed initiation of a go-around and early retraction of the flaps during the maneuver, which resulted in a collision with trees.NTSB ERA12LA360Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Kingston, NYThe pilot’s failure to maintain adequate clearance from trees/foliage at an undetermined point during the flight.NTSB ERA12FA327Accident · 2 fatalField investigationFinal reportMooney M20J · Sterling, PAThe pilot’s decision to take off on an uphill slope without utilizing the entire available runway, and his failure to abort the takeoff when he realized he wasn’t going to liftoff in time to clear the trees at the end of the runway.NTSB DCA12WA071Accident · 44 fatalForeign investigationSukhoi SJ100 · Mt. Salak, IndonesiaOn May 9, 2012, at 1450 local time, a Sukhoi SJ100-95, Russian registration RP97004, collided with terrain about 35 miles south of Jakarta, Indonesia. The airplane was on a demonstration flight. The 40 passengers and 4 crew were fatally injured, and the…NTSB ERA12CA304Accident · Serious injuriesData collectionFinal reportBell 206B · Hershey, PAThe pilot's diverted attention while performing aerial application at low altitude, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to adjust the control friction to the position he was accustomed.NTSB ERA12WA301Accident · 2 fatalForeign investigationCessna T206H · Macapá, BrazilOn April 20, 2012, about 0855 universal coordinated time, a Cessna T206H, Brazilian registration PR-CRR, was substantially damaged when it collided with terrain approximately five minutes after takeoff from Macapa International Airport (SBMQ), Macapa, Brazil.…NTSB CEN12WA679Accident · 2 fatalForeign investigationRobinson R22 · Huy, BelgiumThis accident is under the jurisdiction and control of the Belgium government.NTSB ERA12WA255Accident · 4 fatalForeign investigationPiper PA-32R-300 · Treasure Cay, BahamasOn March 25, 2012, at 1830 UTC, a Piper PA-32R-300, N8415C, was substantially damaged when it crashed shortly after takeoff from Treasure Cay International Airport (MYAT), Abaco, Bahamas. The two certificated private pilots and two passengers were fatally…NTSB CEN12LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Pinconning, MIThe pilot's failure to properly align his airplane with the runway during final approach. Contributing to the accident was the sunglare that obscured the pilot's view of the runway.NTSB ERA12WA240Accident · 3 fatalForeign investigationCessna 182 · Barrancabermeja, ColombiaOn March 17, 2012, about 2145 universal coordinated time (1645 local time), a Cessna 182M, Colombian registration HK1441G, was substantially damaged when it impacted transmission lines, then terrain, about 3 nautical miles south of Aeropuerto Yariguies…NTSB WPR12FA139Accident · 1 fatalField investigationFinal reportBeech B36 · Panoche, CAThe pilot’s lack of situational awareness regarding the surrounding terrain while descending during dark night conditions, which resulted in controlled flight into terrain.NTSB WPR12FA136Accident · 2 fatalField investigationFinal reportCessna 150L · Goble, ORThe flight instructor's decision to continue flight into the area of reduced visibility and the pilots’ subsequent failure to maintain clearance from the hilly terrain while operating in an area of low ceilings, rain, and fog.NTSB ANC12LA026Accident · Serious injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Ketchikan, AKThe pilot's decision to depart in marginal visual meteorological conditions, and his continued visual flight into instrument meteorological conditions.NTSB WPR12CA129Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Santa Clarita, CAThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain. Contributing to the accident was the pilot's decision to land with a tailwind.NTSB ERA12WA212Accident · 1 fatalForeign investigationCessna 172N · Miranda, VenezuelaOn March 3, 2012, about 1259 universal coordinated time, a Cessna 172N, Venezuelan registration, YV105E, was destroyed when it impacted into terrain while in cruise flight near Municipio Zamora Parroquia Bolivar, Miranda, Venezuela. The pilot was fatally…NTSB ERA12WA202Accident · 1 fatalForeign investigationCessna 208 · Manaus, BrazilOn February 28, 2012, about 1020 universal coordinated time, a Cessna 208B, Brazilian registration PT-PTB, operated by Cleiton Taxi Aereo Ltda., was substantially damaged when it impacted a lamppost and terrain, during the initial climb after takeoff from…NTSB ERA12CA190Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Swainsboro, GAThe pilot’s failure to maintain the proper glidepath during final approach in night visual meteorological conditions, which resulted in a collision with trees.NTSB WPR12CA173Accident · No injuriesData collectionFinal reportLindstrand LBL180A · Temecula, CAThe pilot failed to see and avoid a set of power lines while maneuvering to a landing site.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.NTSB ERA12WA155Accident · 5 fatalForeign investigationBell 206 · Montana Auyantepui, VenezuelaOn January 18, 2012, about 1715 universal coordinated time, a Bell 206 L-4 helicopter, Venezuelan registration YV1985, was destroyed when it collided with a mountain during a sightseeing flight near Montaña Auyantepui, Parque Nacional Canaima, in the State of…NTSB ERA12WA133Accident · 2 fatalForeign investigationPiper PA28 · Andres Bello,Tachira, VenezuelaOn December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…NTSB ERA12MA122Accident · 3 fatalMajor investigationFinal reportBell 206B · Green Cove Springs, FLThe pilot’s improper decision to continue visual flight into night instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the pilot’s improper decision was his self-induced pressure to complete the trip.NTSB CEN12LA109Accident · 1 fatalLimited investigationFinal reportCessna 172R · Denton, TXThe pilot's controlled flight into terrain while maneuvering at a low altitude in instrument meteorological conditions. Contributing to the accident was the pilot's decision to perform a circling maneuver in weather below circling minimums instead of flying…NTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…NTSB ERA12WA103Accident · 4 fatalForeign investigationCessna TU206 · Cerro Escalera, PeruOn December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.NTSB ERA12WA073Accident · 2 fatalForeign investigationCessna 150 · Santa Rosa, EcuadorOn November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…NTSB WPR12CA026Accident · Serious injuriesData collectionFinal reportAyres S2R-600 · Kahlotus, WAThe pilot’s failure to maintain clearance from the ground due to his distraction with programming a global positioning system receiver.NTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.NTSB ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.NTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.NTSB ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.NTSB CEN12FA010Accident · 1 fatalField investigationFinal reportBrinkerhuff Gerald G Q200 · Holland, MIThe pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.NTSB ERA12WA026Accident · 4 fatalForeign investigationBeech V35 · Maraba Paulista, BrazilOn October 1, 2011, about 2345 coordinated universal time (2045 local time), a Beechcraft V35, Brazilian registration PT-CTL, was substantially damaged when it impacted terrain between the cities of Maraba Paulista and Presidente Venceslau, Sao Paulo State,…NTSB ERA11WA520Accident · 2 fatalForeign investigationBeech D35 · Avare, BrazilOn September 29, 2011, about 1824 Universal Coordinated Time (UTC), a Beech D35, Brazilian registration PT-AVK, operated by a private owner, was destroyed following a collision with terrain at Santarém Municipality, State of Pará, Brazil. The local flight…NTSB CEN11FA666Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 · Curren, MIThe non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.NTSB ANC11FA107Accident · 1 fatalField investigationFinal reportDehavilland DHC-3T · Kodiak, AKThe pilot’s failure to maintain clearance from a tree during a low altitude maneuver and his failure to maintain control of the airplane. Contributing to the accident was the pilot’s use of over-the-counter sedating medications.NTSB CEN11FA663Accident · 1 fatalField investigationFinal reportThorp T-18 · Plainwell, MIThe pilot did not maintain clearance from a semitrailer along the approach path.NTSB WPR11LA461Accident · Serious injuriesLimited investigationFinal reportBunker RLV-1 · Wells, NVThe pilot did not maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot’s inadequate in-flight planning.NTSB ERA11WA499Accident · 3 fatalForeign investigationBeech 99 · Cap Haitien, HaitiOn September 20, 2011, at 2130 universal coordinated time, a Hawker Beechcraft BE-99A, registered in Haiti as HH-APA, was substantially damaged when it impacted terrain while on approach to the Cap Haitien International Airport (MTCH), Cap Haitien, Haiti. The…NTSB WPR11WA475Accident · 2 fatalForeign investigationCessna 208B · Wamean, West Papua, IndonesiaOn September 9, 2011, at 1223 local time (0323 UTC) a Cessna 208B, Indonesia registry PK-VVE, collided with mountainous terrain 8 nautical miles north east of Wamena Airport, Wamena, West Papau, Indonesia. The aircraft was operated by Susi Air under the…