NTSB investigations, 2012
79 cases where the sequence of events included 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 year(c.\"eventDate\") = 2012
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") = 2012 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 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 WPR12LA301Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cheyenne, WYThe pilot's failure to maintain clearance with a power line. Contributing to the accident was the sun's glare.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…