NTSB investigations, 2013, OK

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

Cases per year

20082026
NTSB investigations, 2013, OK per year, 2008–2026: 71 cases
200810
20092
20105
20114
20123
20138
20142
20152
20165
20182
20193
20205
20219
20225
20231
20242
20252
20261

Latest 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\") = 2013
    AND c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
    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 CEN14FA046Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-25 · Owasso, OKThe pilot's loss of airplane control during a known one-engine-inoperative condition. The reasons for the loss of control and engine shutdown could not be determined because the airplane was not equipped with a crash-resistant recorder and postaccident…Nov 10, 2013 · N856JT · DestroyedNTSB CEN14FA019Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Talihina, OKThe pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.Oct 21, 2013 · N113WS · DestroyedNTSB CEN13TA441Accident · Serious injuriesFinal reportCessna 182S · Tecumseh, OKThe pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.Jul 27, 2013 · N820HP · Substantial damageNTSB CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.Jun 11, 2013 · N935EM · Substantial damageNTSB CEN13FA221Accident · 2 fatalField investigationFinal reportMooney M20J · Collinsville, OKThe pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.Apr 7, 2013 · N57672 · DestroyedNTSB CEN13FA217Accident · 2 fatalField investigationFinal reportMooney M20E · Guymon, OKThe noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…Apr 1, 2013 · N9330M · DestroyedNTSB CEN13LA155Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Tulsa, OKThe line technician’s failure to remove the refueling mat from the helicopter fuselage following servicing, which resulted in the mat striking the tail rotor in flight, and the pilot’s inadequate preflight inspection.Feb 6, 2013 · N276RC · Substantial damageNTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.Jan 19, 2013 · N143E · Substantial damage