NTSB investigations, 2014

311 cases where the sequence of events included Loss of control in flight.

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\") = 2014
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' 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 ERA14LA117Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLThe noninstrument-rated pilot’s continued flight into dark night, instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation and subsequent impact with water.Feb 8, 2014 · N2571U · DestroyedNTSB ERA14FA112Accident · 4 fatalField investigationFinal reportGulfstream AM Corp Comm Div 690 · Bellevue, TNThe pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…Feb 3, 2014 · N840V · DestroyedNTSB DCA14WA179Accident · 3 fatalForeign investigationBeech C90 · Lanseria, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Beech C90-GTI airplane that occurred on February 03, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation under the…Feb 3, 2014 · ZS-CLT · DestroyedNTSB WPR14CA110Accident · Minor injuriesData collectionFinal reportBeech V35A · Globe, AZThe pilot's inadequate glide path and failure to maintain adequate airspeed during final approach, which resulted in an aerodynamic stall.Feb 1, 2014 · N31TC · Substantial damageNTSB ERA14WA114Accident · 2 fatalForeign investigationCessna 140 · Cachoeira do Sul, BrazilOn January 29, 2014, about 1340 universal coordinated time, a Cessna 140, Brazilian registration PP-DFW, was substantially damaged during impact with terrain, following a loss of control on approach to Cachoeira do Sul Airport (SSKS), Cachoeira do Sul, Rio…Jan 29, 2014 · PP-DFW · Substantial damageNTSB CEN14TA126Accident · Minor injuriesFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe flight instructor's loss of control after takeoff following a wake turbulence encounter from a preceding helicopter. Contributing to the accident were the flight instructor's misidentification of the helicopter type and a lack of Federal Aviation…Jan 29, 2014 · N959DA · Substantial damageNTSB WPR14CA101Accident · No injuriesData collectionFinal reportEnstrom Helicopter 280C · Showlow, AZThe pilot's failure to maintain main rotor RPM during the takeoff run in a high density altitude environment, which resulted in a loss of aircraft control and collision with terrain.Jan 21, 2014 · N51683 · Substantial damageNTSB CEN14FA102Accident · 2 fatalField investigationFinal reportMooney M20R · Boyne City, MIThe pilot’s failure to maintain control of the airplane as he attempted to return to the airport after encountering dark night conditions and heavy snow showers.Jan 6, 2014 · N1046L · Substantial damageNTSB CEN14FA099Accident · 1 fatalField investigationFinal reportCanadair CL 600 2B16 · Aspen, COThe flight crew's failure to maintain airplane control during landing following an unstabilized approach. Contributing to the accident were the flight crew's decision to land with a tailwind above the airplane's operating limitations and their failure not to…Jan 5, 2014 · N115WF · DestroyedNTSB CEN14CA104Accident · No injuriesData collectionFinal reportCessna 172P · Cotulla, TXThe student pilot did not maintain control of the airplane while landing. The flight instructor's failure to monitor the flight contributed to the accident.Jan 5, 2014 · N55277 · Substantial damageNTSB WPR14CA086Accident · Minor injuriesData collectionFinal reportDehavilland Beaver DHC 2 MK.1 · Shaw Island, WAThe pilot's failure to maintain directional control during takeoff in variable wind conditions, resulting in a collision with trees lining the left side of the runway.Jan 4, 2014 · N5484U · Substantial damage