NTSB investigations, 2010

70 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\") = 2010
    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.

NTSB WPR10FA234Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Livermore, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with obstacles and terrain.May 9, 2010 · N56626 · Substantial damageNTSB CEN10FA230Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Friendswood, TXThe airplane's impact with terrain for undetermined reasons.Apr 28, 2010 · N14787 · Substantial damageNTSB ENG10RA025Accident · 89 fatalForeign investigationTupolev TU154 · Smolensk, RussiaOn April 10, 2010, about 0656 Coordinated Universal Time (UTC), a Tupolev Tu-154M, Tail Number 101, operated by the Polish Air Force as flight PLF101, crashed during approach to the Military Aerodrom Smolensk "Severnyi", Russia. All 89 passengers and 7…Apr 10, 2010 · N101 · DestroyedNTSB CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.Mar 30, 2010 · N71229 · Substantial damageNTSB ANC10CA027Accident · No injuriesData collectionFinal reportCessna 182B · Port Alsworth, AKThe pilot's decision to enter adverse weather conditions, resulting in a loss of visibility and collision with terrain during a turn to reverse direction.Mar 18, 2010 · N2266G · Substantial damageNTSB CEN10CA154Accident · No injuriesData collectionFinal reportGrumman American AA-5 · Maple Lake, MNThe pilot's failure to maintain a proper glide path during a simulated forced landing and the flight instructor's delayed remedial action to execute a go-around.Feb 27, 2010 · N5418L · Substantial damageNTSB ERA10WA160Accident · 2 fatalForeign investigationCessna 310R · Nova Lima, BrazilOn Feburary 26, 2010, about 1119 UTC, a Cessna 310R, Brazilian registration PT-OID, was destroyed when it collided with mountainous terrain near Nova Lima, Brazil. The pilot and one passenger were killed. The flight originated from Leopoldina, Brazil (SNDN)…Feb 26, 2010 · PT-OID · DestroyedNTSB CEN10RA133Accident · 5 fatalForeign investigationCessna 206 · San Pedro, BelizeFeb 26, 2010 · V3-HDR · Substantial damageNTSB ERA10CA152Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Patillas, PRThe student pilot’s decision to abort the takeoff with insufficient runway remaining.Feb 24, 2010 · N5212L · Substantial damageNTSB ERA10LA151Accident · Serious injuriesLimited investigationFinal reportCotter Stits Playmate · Williston, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's fuel mismanagement.Feb 21, 2010 · N816 · Substantial damageNTSB ERA10WA133Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Restauracion, Dominican Republic, Dominican RepublicOn February 4, 2010, about 1940 Atlantic standard time, a Robinson R44II helicopter, N7535F, impacted the side of Mount Jina Mocha, in the city of Restauracion, Dominican Republic, at night, while en route from Port Au Prince, Haiti to Cibao International…Feb 4, 2010 · N7535F · DestroyedNTSB WPR10FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot’s decision to take off in marginal visual flight rules conditions, which resulted in an encounter with low clouds, and the pilot's failure to maintain clearance from wires while maneuvering in the traffic pattern for landing.Jan 28, 2010 · N293PA · Substantial damageNTSB WPR10LA115Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Joshua Tree, CAThe certified flight instructor's decision to continue visual flight into deteriorating weather, which resulted in his inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain clearance with terrain.Jan 18, 2010 · N13073 · Substantial damageNTSB WPR10GA113Accident · 2 fatalFinal reportCessna 182R · Corvallis, ORThe pilot’s failure to maintain clearance from terrain while operating into a known area of mountain obscuration due to low clouds, precipitation, and mist.Jan 18, 2010 · N702 · Substantial damageNTSB WPR10FA116Accident · 2 fatalField investigationFinal reportCessna 340 · Lytle Creek, CAThe pilot’s loss of situational awareness while maneuvering under a cloud layer and failure to maintain sufficient clearance from mountainous terrain.Jan 18, 2010 · N2217B · Substantial damageNTSB CEN10CA100Accident · Minor injuriesData collectionFinal reportCessna P172D · Cedar Rapids, IAThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain a proper glidepath during the approach. Contributing to the accident was the pilot's lack of instrument proficiency.Jan 18, 2010 · N8584X · Substantial damageNTSB WPR10FA107Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Honolulu, HIThe pilot's continued visual flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance. Contributing to the accident was the air traffic controller's failure to issue a safety alert after observing the…Jan 10, 2010 · N8934N · Substantial damageNTSB WPR10CA106Accident · Minor injuriesData collectionFinal reportCessna 140 · Chico, CAThe pilot’s inadequate weather evaluation and failure to maintain clearance from trees while maneuvering in low visibility conditions.Jan 9, 2010 · N3160N · Substantial damageNTSB WPR10GA097Accident · 4 fatalFinal reportBell 206B · Auberry, CAThe pilot's failure to see and avoid a wire while maneuvering during low-altitude operations.Jan 5, 2010 · N5016U · Substantial damageNTSB WPR10CA094Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Tipton, CAThe pilot's failure to maintain clearance from terrain.Jan 1, 2010 · N440NR · Substantial damage