NTSB investigations

1,269 cases where NTSB found Performance/control parameters, general.

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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000'))
  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 CEN14FA249Accident · 4 fatalField investigationFinal reportRaytheon G36 · Silver City, NMThe airplane’s encounter with a strong tailwind and/or windshear, which resulted in an inadvertent stall. Contributing to the accident was the pilot’s continuation of the unstable approach, long landing, and delayed decision to conduct a go-around.May 23, 2014 · N536G · DestroyedNTSB ERA14CA320Accident · No injuriesData collectionFinal reportFairchild M 62C(PT-23A) · Petersburg, VAThe flight instructor's failure to maintain control of the airplane during the landing attempt. Contributing to the accident was the changing wind conditions.May 22, 2014 · N60418 · Substantial damageNTSB CEN14CA250Accident · No injuriesData collectionFinal reportSantschi Chris A Vans RV8 · Bonne Terre, MOThe pilot's failure to maintain aircraft control on takeoff.May 16, 2014 · N627CS · Substantial damageNTSB CEN14CA237Accident · No injuriesData collectionFinal reportMooney M20F · Dowling, MIThe pilot's failure to maintain control during landing.May 11, 2014 · N343ED · Substantial damageNTSB WPR14FA186Accident · 1 fatalField investigationFinal reportCessna T207A · Page, AZThe pilot’s inability to maintain aircraft control due to a partial loss of engine power and an encounter with downdrafts and gusting crosswinds while on final approach to the runway. The reason for the partial loss of engine power could not be determined…May 10, 2014 · N7311U · Substantial damageNTSB ERA14CA230Accident · No injuriesData collectionFinal reportCessna 172S · Deland, FLThe student pilot's failure to maintain control of the airplane during the landing, and the flight instructor's inadequate supervision of the student pilot resulting in abnormal runway contact and damage to the airplane.May 9, 2014 · N493ER · Substantial damageNTSB ANC14CA026Accident · No injuriesData collectionFinal reportCessna 170B · Soldotna, AKThe pilot's failure to recognize a wind shift, resulting in a tailwind landing, loss of control, and ground loop.May 3, 2014 · N3469C · Substantial damageNTSB ERA14LA218Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Middlesboro, KYThe pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…May 2, 2014 · N702JS · Substantial damageNTSB ERA14CA216Accident · No injuriesData collectionFinal reportAgusta Aerospace AW119 Mkii · Lumberton, NJThe flightcrew's improper recovery from a simulated engine failure after takeoff. Contributing to the accident was the flight instructor's failure to clarify who had control of the helicopter.May 1, 2014 · N119HF · Substantial damageNTSB WPR14LA173Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Adelanto, CAThe commercial pilot’s improper control inputs, which resulted in a loss of helicopter control during takeoff.Apr 27, 2014 · N606BP · Substantial damageNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB ERA14CA203Accident · Minor injuriesData collectionFinal reportEvolution Revo · Concord, NHThe student pilot's failure to maintain control during a go around, which resulted in a collision with terrain.Apr 20, 2014 · N2264X · Substantial damageNTSB CEN14CA207Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Bloomington, INThe pilot did not maintain control of the airplane while landing.Apr 19, 2014 · N298AB · Substantial damageNTSB CEN14CA203Accident · Minor injuriesData collectionFinal reportPiper PA-28 · Kalamazoo, MIAn inadvertent stall during gusting crosswind conditions.Apr 19, 2014 · N38240 · Substantial damageNTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.Apr 18, 2014 · UNREG · Substantial damageNTSB ERA14CA200Accident · No injuriesData collectionFinal reportKaldor Gregory N Zenith 701 · Eutaw Springs, SCThe pilot's improper decision to execute a precautionary landing to unsuitable terrain following an inflight encounter with a wind gust, resulting in substantial damage to the airplane.Apr 14, 2014 · N851RC · Substantial damageNTSB WPR14FA167Accident · 1 fatalField investigationFinal reportSands Helicycle · Reno, NVThe pilot’s failure to maintain control of the helicopter while in the traffic pattern.Apr 13, 2014 · N78CS · Substantial damageNTSB ERA14FA192Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Hugheston, WVThe pilot's loss of airplane control while operating in instrument flight rules conditions.Apr 11, 2014 · N39965 · DestroyedNTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.Apr 10, 2014 · N2143N · Substantial damageNTSB ANC14FA022Accident · 2 fatalField investigationFinal reportCessna 208B · Kwethluk, AKThe check airman's delayed remedial action and initiation of a recovery procedure after a simulated pitch trim excursion, which resulted in a loss of airplane control.Apr 8, 2014 · N126AR · DestroyedNTSB ERA14CA184Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe inadvertent encounter with a microburst during taxi from landing that resulted in the aircraft being turned over inverted and receiving substantial damage.Apr 7, 2014 · N2630B · Substantial damageNTSB ERA14CA188Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Bethel, METhe pilot's failure to maintain control of the airplane while taxiing after landing during gusty wind conditions.Apr 6, 2014 · N74843 · Substantial damageNTSB CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.Apr 6, 2014 · N761BT · Substantial damageNTSB CEN14FA185Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Albany, OHThe pilot’s loss of airplane control during the approach to landing.Apr 5, 2014 · N8259R · Substantial damageNTSB CEN14FA173Accident · 1 fatalField investigationFinal reportWorthington Donald Wayne Sonerai II LT · Highlands Ranch, COThe pilot’s loss of control during a forced landing following a loss of engine power for reasons that could not be determined due to postimpact fire damage.Mar 29, 2014 · N63917 · DestroyedNTSB ERA14LA174Accident · 1 fatalLimited investigationFinal reportN/A N/A · Patillas, PRThe pilot’s failure to maintain airplane control during approach for landing, which resulted in a stall/spin.Mar 26, 2014 · UNREG · Substantial damageNTSB ERA14CA166Accident · No injuriesData collectionFinal reportWaco UIC · Saint Petersburg, FLThe pilot's inadequate compensation for the wind conditions during landing.Mar 23, 2014 · N13562 · Substantial damageNTSB ERA14CA165Accident · Serious injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Kill Devil Hills, NCThe pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.Mar 23, 2014 · N90650 · Substantial damageNTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.Mar 22, 2014 · N702H · Substantial damageNTSB ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.Mar 14, 2014 · N80457 · Substantial damageNTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.Feb 24, 2014 · N7745C · Substantial damageNTSB CEN14LA148Accident · 1 fatalLimited investigationFinal reportVans RV-9A · Tribune, KSThe pilot’s failure to maintain airplane control while conducting high-g turns, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to initiate the flight with a severe progressive neurological disorder that…Feb 23, 2014 · N7872 · Substantial damageNTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…Feb 19, 2014 · N9026N · Substantial damageNTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.Feb 19, 2014 · N811BL · DestroyedNTSB 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 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 CEN14TA116Accident · Minor injuriesFinal reportAutogyro Mtosport · Spring, TXThe pilot’s failure to maintain the gyroplane’s rotor control during the landing roll in gusting crosswind conditions.Jan 16, 2014 · N250TX · 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 CEN14CA098Accident · No injuriesData collectionFinal reportBell 206B · Temple, TXThe pilot's loss of control while landing on a mobile helipad.Jan 2, 2014 · N400XL · Substantial damageNTSB WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.Dec 29, 2013 · N4936D · Substantial damageNTSB CEN14LA087Accident · Serious injuriesLimited investigationFinal reportMaarten H Versteeg Zenith 601XL(B) · Leakey, TXThe pilot’s failure to maintain control of the airplane after the canopy opened on takeoff. Contributing to the accident was the pilot’s failure to properly secure the canopy latch before takeoff.Dec 16, 2013 · N581SL · Substantial damageNTSB WPR14CA067Accident · Serious injuriesData collectionFinal reportBeech 58P · Kalispell, MTThe pilot's failure to maintain airplane control during the landing sequence.Dec 9, 2013 · N53MT · Substantial damageNTSB WPR14CA063Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Bryon, CAThe pilot's failure to maintain adequate wing clearance from a runway sign while taxiing.Dec 8, 2013 · N3981C · Substantial damageNTSB CEN14FA077Accident · 2 fatalField investigationFinal reportAviat A-1C-200 · Los Alamos, NMThe pilot’s loss of airplane control while maneuvering after takeoff in gusty wind conditions.Dec 8, 2013 · N80MF · DestroyedNTSB CEN14LA079Accident · Serious injuriesLimited investigationFinal reportThompson William A Sparrow II · Jeromesville, OHThe student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.Dec 4, 2013 · N5955Y · Substantial damageNTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…Dec 3, 2013 · N87NF · DestroyedNTSB CEN14FA072Accident · 1 fatalField investigationFinal reportBiesemeier David I Smyth Sidewinder · Boulder, COThe pilot’s abrupt maneuver, which exceeded the structural limits of the left wing and resulted in its in-flight separation.Nov 27, 2013 · N3786A · DestroyedNTSB ERA14FA045Accident · 4 fatalField investigationFinal reportLearjet 35 · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…Nov 20, 2013 · XA-USD · DestroyedNTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…Nov 20, 2013 · N6832B · DestroyedNTSB ERA14FA044Accident · 1 fatalField investigationFinal reportFocke-Wulf FWP 149D · Kenansville, NCThe pilot’s loss of control in instrument meteorological conditions for reasons that could not be determined because examination of the airframe and engine revealed no anomalies that would have precluded normal operation. Contributing to the accident was the…Nov 17, 2013 · N132FW · Destroyed