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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN22LA150Accident · No injuriesClass 4 · LimitedFinal reportSparrow Hawk III · Lubbock, TXThe pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.NTSB ERA22LA165Accident · Minor injuriesClass 4 · LimitedFinal reportNordquist Richard A Vans RV7 · Polk City, FLA loss of control during landing due to the loose and uneven landing surface.NTSB ERA22LA162Accident · 1 fatalClass 3 · LimitedFinal reportCzech Sport Piper Sport · Homestead, FLThe airplane’s collision with water for underdetermined reasons.NTSB CEN22LA132Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Crete, NEThe pilot’s failure to maintain control of the airplane during takeoff.NTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.NTSB WPR22LA072Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Upland, CAThe pilot’s loss of airplane control during a go-around as it encountered wake turbulence from a slow hover taxiing helicopter.NTSB WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.NTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.NTSB WPR22FA048Accident · 1 fatalClass 3 · FieldFinal reportZenith Zodiac CH601XL · Temecula, CAThe failure of the airplane’s canopy latch system, which resulted in the canopy opening in flight and a loss of airplane control. Contributing to the accident was the lack of a secondary canopy latch as recommended by the kit manufacturer.NTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.NTSB ERA22LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Inverness, FLThe pilots inadequate recovery from a wind gust during landing, which resulted in a hard landing and substantial damage to the fuselage.NTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…NTSB ERA21LA387Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLThe pilot’s loss of helicopter control after landing. Also causal was the pilot’s intentional operation of the helicopter without the required training, experience, and endorsements.NTSB CEN21LA474Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion H · Burlington, WIThe pilot’s failure to maintain aircraft control during landing with a gusting crosswind that resulted in an aerodynamic stall and a hard impact on the runway.NTSB CEN21LA416Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hot Springs, SDThe tensile overload failure of the main landing gear attachment bolt, which resulted in separation of the left main landing gear and a loss of control during landing.NTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.NTSB CEN21LA401Accident · No injuriesClass 3 · LimitedFinal reportBulfer James G Genesis · Fairmont, MNThe pilot’s failure to maintain airspeed during a forced landing, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the loss of power due to the failure of the engine’s…NTSB ANC21LA080Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pelican, AKThe pilot’s loss of control while landing on a remote helipad.NTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB CEN21LA449Accident · No injuriesClass 4 · LimitedFinal reportColumbia Aircraft Mfg LC41-550FG · Granby, COThe pilot’s loss of control during landing in high density altitude conditions.NTSB ERA21LA313Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Waxhaw, NCThe pilot’s failure to abort the takeoff in sufficient time to stop the airplane on the runway remaining. Contributing to the accident was the lack of airplane takeoff performance due to the pilot’s failure to assure that the carburetor heat control was in…NTSB WPR21FA300Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Colusa, CAThe pilot’s abrupt flight control input that led to mast bumping and a subsequent in-flight breakup.NTSB WPR21FA286Accident · 6 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Truckee, CAThe first officer’s (FO’s) improper decision to attempt to salvage an unstabilized approach by executing a steep left turn to realign the airplane with the runway centerline, and the captain’s failure to intervene after recognizing the FO’s erroneous action,…NTSB CEN21FA334Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Benoit, MSThe pilot’s exceedance of the airplane’s takeoff performance capabilities and his failure to abort the takeoff in a timely manner. Contributing to the accident was the pilot’s impairment due to his use of ethanol and prohibited medications.NTSB ERA21LA295Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Point Harbor, NCThe noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…NTSB CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.NTSB ERA21LA275Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rome, NYThe pilot's improper termination of a practice autorotation with power recovery, which resulted in low rotor rpm, an unstable landing, and a rollover. Contributing to the accident was the evaluator's inadequate oversight.NTSB CEN21FA290Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe canopy moving fully open during flight, which resulted in the pilot’s distraction and a subsequent aerodynamic stall/spin and loss of control.NTSB ERA21LA262Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Swan Lake, NYThe pilot's failure to maintain adequate clearance from the power transmission tower structure during powerline maintenance work, which resulted in the helicopter's main rotor striking the lifeline support bracket for the tower catwalk and the subsequent loss…NTSB ANC21LA034Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Palmer, AKThe pilot’s selection of unsuitable terrain for landing and his excessive braking which resulted in a nose-over.NTSB ERA21FA178Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Great Valley, NYThe pilot’s failure to maintain control during takeoff.NTSB CEN21LA181Accident · 1 fatalClass 3 · LimitedFinal reportEvolution Revolt · Seminole, TXThe student pilot’s loss of trike control while maneuvering at low altitude in gusting wind conditions, resulting in an impact with terrain.NTSB ERA21LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot under instruction’s improper landing flare and attempted go-around which resulted in an aerodynamic stall, and subsequent loss of control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN21LA091Accident · 1 fatalClass 3 · LimitedFinal reportExtra Flugzeugproduktions-Und EA 300/L · Aledo, TXThe pilot’s loss of control during an intentional aerobatic maneuver, which resulted in an upright spin into terrain.NTSB CEN21LA084Accident · 2 fatalClass 3 · LimitedFinal reportRobinson R44 · Colorado City, TXThe pilot’s loss of control and exceedance of performance and/or structural limitations during low-altitude operations, which resulted in an inflight breakup.. Contributing to the accident was the pilot’s impairment from the effects of tetrahydrocannabinol.NTSB ANC21LA007Accident · 2 fatalClass 3 · LimitedFinal reportCessna 150L · Colton, ORThe pilot’s failure to maintain positive control of the airplane in mountainous terrain during dark night conditions as a result of spatial disorientation which led to a loss of control and subsequent impact with terrain.NTSB CEN21LA044Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-22-135 · Dunn Center, NDThe noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB ERA21LA038Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA22 · Warner Robins, GAThe pilot’s improper compensation for shifting wind conditions, which resulted in a runway excursion and a subsequent nose over.NTSB CEN21LA030Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210 · Lubbock, TXThe pilot’s improper decision to fly into icing conditions with an airplane that was not equipped for icing, which led to structural icing and a subsequent loss of airplane control, and the pilot’s impairment from carbon monoxide poisoning due to a cracked…NTSB CEN21FA025Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Slidell, LAThe pilot’s loss of control shortly after departure for reasons that could not be determined based on the available information.NTSB ERA21LA014Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Rural Hall, NCThe pilot’s failure to maintain airplane control and improper recovery from an unusual attitude, which resulted in an in-flight breakup.NTSB WPR21LA002Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Burlington, WAThe total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN20LA425Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Spring, TXThe student pilot’s failure to maintain airplane control during climb and subsequent impact with terrain.NTSB WPR20LA319Accident · 1 fatalClass 3 · LimitedFinal reportCessna T182 · Santa Barbara, CAThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions.NTSB ERA20CA319Accident · No injuriesClass 4 · Data collectionFinal reportRotorway Exec 162F · Kenansville, FLThe pilot’s failure to maintain control of the helicopter during takeoff.NTSB ANC20LA086Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA 14 · Wasilla, AKThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions, which resulted in impact with trees.NTSB CEN20LA354Accident · 1 fatalClass 3 · LimitedFinal reportLancair Lancair Super ES · Ely, MNThe non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.NTSB ANC20CA081Accident · No injuriesClass 4 · Data collectionFinal reportPerformer High Performer · Chandalar Shelf, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing and a nose over.NTSB CEN20LA328Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Marathon, TXThe in-flight loss of helicopter control for reasons that could not be determined based on the available evidence.NTSB CEN20LA304Accident · 1 fatalClass 3 · LimitedFinal reportBrantly B2B · Monrovia, INThe pilot’s loss of control after takeoff for reasons that could not be determined based on the available information.