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 WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.Aug 11, 2010 · N500FV · Substantial damageNTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.Aug 11, 2010 · N21363 · Substantial damageNTSB WPR10CA390Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe pilot’s failure to maintain aircraft control during final approach, resulting in a hard landing.Aug 8, 2010 · N6165M · Substantial damageNTSB ERA10LA408Accident · No injuriesLimited investigationFinal reportQuest Kodiak 100 · Naples, MEA loss of control during landing for undetermined reasons.Aug 8, 2010 · N917CM · Substantial damageNTSB CEN10CA473Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Watkins, COThe pilot's failure to maintain aircraft control during the landing, resulting in a ground-loop.Aug 5, 2010 · N8576Y · Substantial damageNTSB WPR10CA398Accident · Serious injuriesData collectionFinal reportKirkpatrick Buzzard · Lincoln, CAA loss of control due to the mechanical disconnection of an aileron pushrod from its bellcrank as a result of the mechanic's failure to properly secure the pushrod attach hardware. Also causal was the pilot's inadequate preflight inspection.Aug 4, 2010 · N84BS · Substantial damageNTSB ERA10LA389Accident · 1 fatalLimited investigationFinal reportCessna A185F · Newfane, NYThe pilot's failure to maintain aircraft control due to his diverted attention, which resulted in a collision with trees during the initial climb after takeoff. Contributing to the accident was the passenger's attempt to secure the jump door after it opened…Aug 1, 2010 · N4976E · Substantial damageNTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.Jul 31, 2010 · N5027G · Substantial damageNTSB CEN10LA470Accident · 1 fatalLimited investigationFinal reportAero SP Z O O AT-4 LSA · Delaware, OHThe pilot’s failure to maintain adequate airspeed which resulted in a stall and subsequent loss of control of the airplane.Jul 28, 2010 · N8549S · Substantial damageNTSB CEN10LA408Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Minden, NEThe pilot's inadequate flare during an autorotation, which resulted in a hard landing and subsequent rollover.Jul 19, 2010 · N410JM · Substantial damageNTSB CEN10CA417Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Shreveport, LAThe student pilot's failure to maintain control of the helicopter during takeoff, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.Jul 19, 2010 · N721BB · Substantial damageNTSB CEN10CA410Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Cairo, NEThe pilot's failure to maintain aircraft control.Jul 18, 2010 · N9552P · Substantial damageNTSB CEN10CA387Accident · No injuriesData collectionFinal reportCessna 140 · Franklin, INThe pilot's improper touchdown point and excessive braking, which resulted in a nose over.Jul 10, 2010 · N72609 · Substantial damageNTSB CEN10CA386Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Chillicothe, MOThe pilot's failure to maintain aircraft control during takeoff.Jul 9, 2010 · N6513K · Substantial damageNTSB WPR10LA339Accident · Minor injuriesLimited investigationFinal reportDouglas A4L · Fallon, NVA loss of engine power during takeoff due to the failure of the engine's stator and turbine. Contributing to the accident was inadequate maintenance.Jul 8, 2010 · N132AT · Substantial damageNTSB CEN10CA357Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Harrison, ARThe pilot’s failure to maintain control of the balloon during landing.Jun 27, 2010 · N60029 · Minor damageNTSB ERA10CA332Accident · No injuriesData collectionFinal reportCrabtree RV6 · Sewanne, TNThe pilot's improper recovery from a bounced landing.Jun 25, 2010 · N3856D · Substantial damageNTSB WPR10LA307Accident · 1 fatalLimited investigationFinal reportCessna 172N · Angels Camp, CAThe pilot’s failure to maintain airplane control while maneuvering.Jun 21, 2010 · N733AS · Substantial damageNTSB WPR10LA299Accident · 1 fatalLimited investigationFinal reportOliver Vans RV-9A · May, IDThe pilot's failure to maintain control of the airplane during maneuvering flight due to spatial disorientation. Contributing to the accident was the pilot's ingestion of an impairing level of over-the-counter medication.Jun 19, 2010 · N559B · Substantial damageNTSB CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.Jun 13, 2010 · N6036U · DestroyedNTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.May 29, 2010 · N88399 · Substantial damageNTSB CEN10CA290Accident · Minor injuriesData collectionFinal reportAeronca 0-58B · Jefferson, TXThe pilot's failure to maintain control of the airplane on during initial climb.May 29, 2010 · N46857 · Substantial damageNTSB CEN10LA266Accident · Serious injuriesLimited investigationFinal reportHall Thomas K Kitfox Speedster · Defiance, OHThe pilot's failure to maintain control of the airplane while performing low-altitude maneuvers.May 23, 2010 · N211ES · Substantial damageNTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…May 22, 2010 · N3041Y · Substantial damageNTSB ERA10CA270Accident · Serious injuriesData collectionFinal reportHealy RAF 2000 · Hopkinsville, KYThe pilot’s overcompensation for gusting wind conditions during the takeoff roll, which resulted in a loss of control.May 17, 2010 · N397MK · Substantial damageNTSB CEN10LA255Accident · Minor injuriesLimited investigationFinal reportSupinski Mark R Supinski Mustang II · Peyton, COThe pilot’s failure to maintain control of the airplane during landing. Contributing to the accident was the pilot’s lack of experience flying tailwheel configured airplanes.May 17, 2010 · N512SR · Substantial damageNTSB ERA10LA266Accident · 2 fatalLimited investigationFinal reportAerostar S A YAK-52 · Jensen Beach, FLThe pilot's decision to perform an aerobatic maneuver at a low altitude, which resulted in insufficient clearance from the water to conduct a recovery. Contributing to the accident was the airplane’s extended landing gear, which resulted in a degradation of…May 15, 2010 · N6868Y · Substantial damageNTSB WPR10CA233Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lake Havasu City, AZThe student pilot's failure to maintain aircraft control during a go-around, resulting in a stall/mush.May 8, 2010 · N918JR · Substantial damageNTSB WPR10CA218Accident · No injuriesData collectionFinal reportCessna 172 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions during taxi.Apr 28, 2010 · N914JM · Substantial damageNTSB CEN10CA231Accident · No injuriesData collectionFinal reportBeech 35 · Boulder, COThe pilot's failure to maintain directional control while landing in a crosswind.Apr 28, 2010 · N8SM · Substantial damageNTSB ERA10FA246Accident · 2 fatalField investigationFinal reportBeech 58 · Bear Branch, KYThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent.Apr 27, 2010 · N1856S · Substantial damageNTSB CEN10CA229Accident · Minor injuriesData collectionFinal reportThomas Long Long's Paraglider · Amarillo, TXThe pilot’s failure to maintain control of the powered parachute, resulting in an unintentional departure and subsequent collision with power lines and the ground.Apr 25, 2010 · UNREG · Substantial damageNTSB ERA10CA242Accident · No injuriesData collectionFinal reportSeymour Robert M Rotorway 162F · Dallas, GAThe student pilot's failure to maintain control of the helicopter during landing resulting in a roll over.Apr 23, 2010 · N831MS · Substantial damageNTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…Apr 19, 2010 · N5425P · DestroyedNTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.Apr 12, 2010 · N93876 · Substantial damageNTSB CEN10CA201Accident · No injuriesData collectionFinal reportGrumman G-164B · Forest City, MOThe pilot's failure to maintain aircraft control during landing, which resulted in an encounter with wet/muddy terrain and a subsequent nose over.Apr 8, 2010 · N993QC · Substantial damageNTSB ERA10CA218Accident · No injuriesData collectionFinal reportCessna 150G · Winter Haven, FLThe student pilot's inadequate recovery from a bounced landing in gusting winds.Apr 4, 2010 · N4655X · Substantial damageNTSB CEN10FA182Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Spol Sro Mermaid · Algonac, MIThe pilot’s loss of control resulting from an aerodynamic stall/spin while maneuvering at low altitude.Apr 1, 2010 · N853CZ · DestroyedNTSB ERA10CA200Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot's inadequate recovery from a bounced landing.Mar 30, 2010 · N21394 · Substantial damageNTSB ERA10CA196Accident · No injuriesData collectionFinal reportDiamond DA20 · Chesapeake, VAThe pilot's improper recovery from a bounced landing.Mar 27, 2010 · N552MA · Substantial damageNTSB CEN10CA213Accident · No injuriesData collectionFinal reportWaco YPF-7 · Houston, TXThe pilot's inability to maintain control during landing due to the failure of the tailwheel locking mechanism to remain engaged prior to landing.Mar 27, 2010 · N32077 · Substantial damageNTSB CEN10CA160Accident · No injuriesData collectionFinal reportUltralight America Spitfire II Modelctv · Cameron, TXThe pilot's failure to maintain control while maneuvering during a forced landing after a partial loss of engine power.Mar 13, 2010 · N6524R · Substantial damageNTSB CEN10LA143Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · DeKalb, ILThe collapse of the landing gear during landing due to the company's improper maintenance practices and the pilot's decision to take off with an overextended landing gear strut.Mar 2, 2010 · N129LA · Substantial damageNTSB CEN10FA130Accident · 2 fatalField investigationFinal reportBeech C24R · Bristow, OKThe pilot’s loss of control for undetermined reasons while maneuvering at low altitude.Feb 28, 2010 · N63713 · DestroyedNTSB CEN10FA125Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Belleville, ILThe pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.Feb 22, 2010 · N350WF · DestroyedNTSB CEN10FA119Accident · 1 fatalField investigationFinal reportPiper PA-31T · Forest City, IAThe pilot's failure to maintain airplane control during final approach.Feb 12, 2010 · N250TT · Substantial damageNTSB ERA10CA145Accident · No injuriesData collectionFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe pilot’s failure to maintain control of the airplane during landing.Feb 8, 2010 · N286JL · Substantial damageNTSB CEN10FA114Accident · 4 fatalField investigationFinal reportBeech A36 · Winslow, ARThe instrument-rated pilot's spatial disorientation and subsequent loss of airplane control during flight in instrument meteorological and conditions favorable for structural icing.Feb 6, 2010 · N1085D · Substantial damageNTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.Jan 23, 2010 · N145AG · Substantial damageNTSB ANC10CA015Accident · No injuriesData collectionFinal reportCessna 172H · Nightmute, AKThe pilot's failure to maintain control of the airplane in a strong gusting wind, and his decision to taxi for takeoff in such conditions.Jan 23, 2010 · N3718F · Substantial damage