NTSB investigations, 2011, OK

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
NTSB investigations, 2011, OK per year, 1964–2026: 2,798 cases
1964108
1965105
1966100
1967134
1968100
196999
197081
1971102
197256
197377
197466
197560
197666
197772
197863
197966
198064
198179
198263
198364
198465
198547
198642
198745
198838
198940
199029
199130
199236
199323
199432
199542
199635
199731
199841
199936
200031
200124
200226
200322
200423
200525
200621
200728
200825
200923
201023
201119
201218
201323
201411
201517
201621
201720
201815
201915
202018
202117
202222
202323
202419
202519
202613

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\") = 2011
    AND c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
  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 CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…Dec 10, 2011 · N999RR · Substantial damageNTSB CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.Nov 4, 2011 · N2099B · Substantial damageNTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 16, 2011 · N6085W · Substantial damageNTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.Oct 15, 2011 · UNREG · Substantial damageNTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.Oct 12, 2011 · N6171B · Substantial damageNTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.Aug 30, 2011 · N5501Q · Substantial damageNTSB CEN11LA579Accident · No injuriesLimited investigationFinal reportCessna 180 · Stillwater, OKThe pilot's on-ground loss of control during the landing roll upon encountering a sudden wind shift and gust.Aug 16, 2011 · N3316D · Substantial damageNTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.Jul 23, 2011 · N118TV · Substantial damageNTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…Jun 30, 2011 · N358MA · Substantial damageNTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.Jun 13, 2011 · N80WW · Substantial damageNTSB CEN11CA389Accident · No injuriesData collectionFinal reportConner Leroy RV6A · Oakwood, OKThe pilot's improper decision to land on a road with obstacles.Jun 10, 2011 · N25LC · Substantial damageNTSB CEN11CA378Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Wagoner, OKThe airplane's collision with a deer during the landing flare and touchdown.Jun 6, 2011 · N3534W · Substantial damageNTSB CEN11LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Frederick, OKAn in-flight fire for undetermined reasons.May 20, 2011 · N8957D · Substantial damageNTSB CEN11CA353Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Guymon, OKThe pilot's loss of directional control while landing in gusty, crosswind conditions.May 12, 2011 · N224RG · Substantial damageNTSB CEN11FA300Accident · 1 fatalField investigationFinal reportDahlman-Dower Tailwind W-8 · Elk City, OKThe pilot's decision to attempt flight into instrument meteorological conditions in an airplane that was equipped for flight in visual meteorological conditions only, which resulted in the pilot’s spatial disoriented and loss of control of the airplane.Apr 21, 2011 · N7804C · Substantial damageNTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.Apr 11, 2011 · N37OU · Minor damageNTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.Apr 7, 2011 · N31407 · Substantial damageNTSB CEN11LA200Accident · No injuriesLimited investigationFinal reportHughes 369D · Henryetta, OKFailure of the cyclic control system for reasons undetermined.Feb 23, 2011 · N112AS · Substantial damageNTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.Feb 20, 2011 · N8310L · Substantial damage