NTSB investigations, 2019

288 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\") = 2019
    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 ERA20FA002Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Asheboro, NCThe pilot’s loss of airplane control due to spatial disorientation, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent night flight experience.Oct 5, 2019 · N2FB · DestroyedNTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…Oct 5, 2019 · N326CW · DestroyedNTSB CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.Oct 3, 2019 · N700AQ · Substantial damageNTSB ERA20LA052Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Grove City, PAThe pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.Oct 1, 2019 · N9404Q · Substantial damageNTSB ERA19FA283Accident · 3 fatalClass 3 · FieldFinal reportCessna 421 · Deland, FLThe pilot’s failure to maintain control of the airplane, which resulted in a collision with terrain. Contributing was the pilot’s lack of training and experience in the accident airplane make and model.Sep 29, 2019 · N731PF · DestroyedNTSB ERA19LA287Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sanford, METhe student pilot's failure to maintain helicopter control while hover-taxiing in gusting wind conditions.Sep 28, 2019 · N21EH · Substantial damageNTSB ERA19LA286Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass · Dalton, GAThe pilot's exceedance of the aircraft's critical angle of attack during a turn shortly after takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing was the pilot's lack of experience in the accident aircraft.Sep 28, 2019 · UNREG · Substantial damageNTSB ERA19LA285Accident · Serious injuriesClass 3 · LimitedFinal reportEnstrom F28 · Bloomsburg, PAThe pilot's failure to maintain proper forward airspeed and power during final approach, which resulted in a loss of tail rotor effectiveness and impact with terrain.Sep 28, 2019 · N380SH · Substantial damageNTSB GAA19WA588Accident · 2 fatalForeign investigationPiper PA22 · Petrovice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a PIPER PA22 airplane that occurred on September 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…Sep 26, 2019 · D-EIRY · DestroyedNTSB GAA19CA575Accident · Minor injuriesData collectionFinal reportPiper J3C · Lander, WYThe pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.Sep 26, 2019 · N33463 · Substantial damageNTSB ANC19TA055Accident · Serious injuriesClass 4Final reportStinson 108 · Tyonek, AKThe pilot’s exceedance of the airplane’s critical angle of attack during a short field takeoff, which resulted in an aerodynamic stall and loss of control.Sep 26, 2019 · N6533M · Substantial damageNTSB GAA19CA587Accident · No injuriesData collectionFinal reportBeech 36 · Lubbock, TXThe pilot's improper pitch trim setting during takeoff in a left quartering tailwind, which resulted in the airplane abruptly pitching up and subsequently experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure to follow a…Sep 25, 2019 · N5836B · Substantial damageNTSB GAA19CA570Accident · Serious injuriesData collectionFinal reportCirrus SR22 · Lexington, NEThe pilot's exceedance of the airplane's critical angle of attack during a go around, which resulted in an aerodynamic stall and a hard landing.Sep 25, 2019 · N1216N · Substantial damageNTSB GAA19CA567Accident · No injuriesData collectionFinal reportGeorge W. Felix Mosquito · Kershaw, SCThe pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.Sep 23, 2019 · N849GF · Substantial damageNTSB ERA19TA277Accident · Serious injuriesClass 3Final reportVans RV 6 · Lakeland, FLThe pilot’s inability to maintain control due to passenger interference.Sep 23, 2019 · N12033 · Substantial damageNTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.Sep 21, 2019 · C-GOZJ · DestroyedNTSB ERA19TA278Accident · No injuriesClass 3Final reportCessna 208 · Pepperell, MAThe pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.Sep 20, 2019 · N895SF · Substantial damageNTSB WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.Sep 19, 2019 · N1891X · DestroyedNTSB WPR19FA262Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Torrance, CAThe pilot’s failure to maintain adequate airspeed and exceedance of the aircraft's critical angle of attack while turning during climb out, which resulted in an aerodynamic stall.Sep 19, 2019 · N2323Y · DestroyedNTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.Sep 18, 2019 · N5438U · DestroyedNTSB ERA19FA275Accident · 2 fatalClass 3 · FieldFinal reportVans RV 8 · Stroudsburg, PAThe pilot's failure to maintain control of the airplane for undetermined reasons.Sep 17, 2019 · N7TL · DestroyedNTSB GAA19CA550Accident · No injuriesData collectionFinal reportPzl Okecie PZL104 · Reno, NVThe pilot's failure to maintain bank control during takeoff in gusting crosswind conditions, resulting in a loss of control in flight and subsequent impact with terrain.Sep 16, 2019 · N123T · Substantial damageNTSB GAA19CA555Accident · Serious injuriesData collectionFinal reportCessna 175 · Toklat, AKThe pilot's loss of airplane control and his subsequent exceedance of the airplane's critical angle of attack during takeoff in variable, gusting wind conditions, which resulted in an aerodynamic stall.Sep 15, 2019 · N6837E · Substantial damageNTSB GAA19CA546Accident · No injuriesData collectionFinal reportMooney M20M · Chandler, AZThe pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action.Sep 14, 2019 · N1085W · Substantial damageNTSB GAA19WA595Accident · 2 fatalForeign investigationCozy Mark IV · Rio Verda, GO, BrazilThe government of Brazil has notified the NTSB of an accident involving a COZY Mark IV airplane that occurred on September 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Sep 13, 2019 · PR-ZQA · Substantial damageNTSB CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.Sep 11, 2019 · N24DR · DestroyedNTSB GAA19WA553Accident · 1 fatalForeign investigationCessna 208 · Gransee, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on September 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…Sep 9, 2019 · D-FIDI · DestroyedNTSB WPR19FA256Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · La Grande, ORThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Sep 8, 2019 · N6300Z · DestroyedNTSB WPR19FA252Accident · 2 fatalClass 3 · FieldFinal reportBeech C24 · Las Vegas, NVThe pilot’s operation of the airplane over its maximum gross weight and outside of center of gravity limits at a high-density altitude, which resulted in the exceedance of the airplane's critical angle of attack while maneuvering and subsequent aerodynamic…Sep 8, 2019 · N24030 · DestroyedNTSB GAA19CA529Accident · No injuriesData collectionFinal reportCessna 172 · Mekoryuk, AKThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting wind conditions.Sep 8, 2019 · N737NJ · Substantial damageNTSB CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…Sep 8, 2019 · N73000 · Substantial damageNTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.Sep 7, 2019 · N1932G · Substantial damageNTSB WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…Sep 6, 2019 · N14365 · Substantial damageNTSB ERA19FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Lady Lake, FLThe pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.Sep 6, 2019 · N767FS · DestroyedNTSB GAA19WA593Accident · No injuriesForeign investigationPiper PA25 · Mazatan, Chiapas, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Sep 5, 2019 · XB-LEDNTSB GAA19WA565Accident · 1 fatalForeign investigationCessna 172 · Racine, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO…Sep 5, 2019 · C-GSEN · DestroyedNTSB CEN19LA297Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Independence Charter Township, MIThe reduction in climb performance for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of performance.Sep 2, 2019 · N98278 · Substantial damageNTSB WPR19LA249Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Asotin, WAA loss of control for undetermined reasons.Sep 1, 2019 · N54528 · Substantial damageNTSB GAA19WA594Accident · 1 fatalForeign investigationAirbus A350 · Alta city, NorwayThe government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…Aug 31, 2019 · LN-OFU · DestroyedNTSB GAA19CA527Accident · No injuriesData collectionFinal reportDiamond DA20 · Convington, TNThe student pilot's improper pitch attitude during the takeoff climb, and the flight instructor's delayed remedial action which resulted in an aerodynamic stall and ground impact.Aug 31, 2019 · N98BZ · Substantial damageNTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.Aug 28, 2019 · N6064H · Substantial damageNTSB GAA19WA540Accident · 3 fatalForeign investigationRobinson R44 · Buriti Alegre, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Aug 25, 2019 · PR-APN · DestroyedNTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.Aug 25, 2019 · N8619W · Substantial damageNTSB CEN19WA287Accident · 3 fatalForeign investigationPiper PA28RT · Simplon Pass, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Aug 25, 2019 · G-BVDH · DestroyedNTSB CEN19LA300Accident · No injuriesClass 3 · LimitedFinal reportCessna 425 · Bethany, OKA loss of control during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.Aug 25, 2019 · N300GD · Substantial damageNTSB CEN19WA285Accident · 1 fatalForeign investigationRotorway Exec 162F · Herisau, SwitzerlandOn August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…Aug 24, 2019 · HB-YKJ · Substantial damageNTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…Aug 23, 2019 · HC-CJN · DestroyedNTSB ERA19FA256Accident · 1 fatalClass 3 · FieldFinal reportMoriarty Marvin Aventura II · Minneola, FLThe pilot’s improper modifications to the airplane’s engine, which resulted in the partial loss of engine power. Contributing to the outcome was the pilot's exceedance of the airplane’s critical angle of attack during an attempted return to the airport…Aug 23, 2019 · N9143M · Substantial damageNTSB GAA19CA513Accident · Minor injuriesData collectionFinal reportCessna A185 · Rangeley Lake, METhe pilot's inadequate preflight inspection of the floats, which led to his subsequent attempt to depart from a lake with damaged floats and led to a loss of roll control and the right wing impacting the water.Aug 22, 2019 · N1920Q · Substantial damageNTSB GAA19CA506Accident · No injuriesData collectionFinal reportGrob G103 · San Antonio, TXThe failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.Aug 22, 2019 · N901BG · Substantial damage