NTSB investigations
138 cases where NTSB found Task performance, 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\", '020600')) 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", '020600')) 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 ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…NTSB DCA14IA037Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Branson, MOThe Flight crew's failure to properly identify the airport and runway of intended landing. Contributing to the incident was the flight crew's failure to comply with procedures for use of navigation information and visual cues to verify the airport and runway…NTSB CEN14LA022Accident · No injuriesLimited investigationFinal reportBell OH-58C · Omaha, TXThe pilot’s failure to assess and compensate for the landing surface, which included high grass and loose dirt.NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB CEN13LA486Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Dumas, ARThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA13LA297Accident · Minor injuriesLimited investigationFinal reportBeech G-36 · Pompano Beach, FLThe pilot’s premature rotation during takeoff with a tailwind and his delayed retraction of the landing gear, which reduced the airplane’s climb performance and subsequently led to the collision with power lines.NTSB ERA13LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Geneva, FLThe passenger’s failure to adhere to the pilot’s instructions to stay away from the front of the airplane when the engine was operating.NTSB CEN13FA196Accident · 2 fatalField investigationFinal reportHawker Beechcraft 390 · South Bend, INThe private pilot's inadequate response to the dual engine shutdown during cruise descent, including his failure to adhere to procedures, which ultimately resulted in his failure to maintain airplane control during a single-engine go-around. An additional…NTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.NTSB CEN13CA153Accident · No injuriesData collectionFinal reportCessna 177RG · Herington, KSThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall.NTSB WPR13FA054Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Corona, CAThe pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.NTSB WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.NTSB CEN13CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Eden Prairie, MNThe pilot’s inadequate braking action and decision to abort the landing near the departure end of the runway. Contributing to the accident was the pilot’s attempt to land near the midpoint of the runway.NTSB ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.NTSB ANC12FA095Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Homer, AKThe pilot's failure to see and avoid high tension power lines.NTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…NTSB ANC12CA092Accident · Minor injuriesData collectionFinal reportDehavilland Beaver U-6 · Kenai, AKThe pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.NTSB CEN12LA448Accident · Serious injuriesLimited investigationFinal reportChapman Mark A Trike · Marlboro, OHThe student pilot’s failure to maintain adequate airspeed during a turn, which resulted in an aerodynamic stall.NTSB ANC12LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Chugiak, AKThe pilot/airplane owner’s loss of directional control after landing, and the instructor pilot's lack of adequate supervision of the training flight.NTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…NTSB DCA12CA045Accident · Serious injuriesData collectionFinal reportBoeing 767 · Angers, Francethe flight attendant inadvertently tripping over a passenger's luggage strap that was protruding into the isle.NTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB CEN12CA084Accident · No injuriesData collectionFinal reportCessna 550 · Moline, ILThe pilot's failure to maintain clearance from the parked, unoccupied airplane while taxiing. Contributing to the accident was the guidance provided by the marshaller.NTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.NTSB WPR12CA026Accident · Serious injuriesData collectionFinal reportAyres S2R-600 · Kahlotus, WAThe pilot’s failure to maintain clearance from the ground due to his distraction with programming a global positioning system receiver.NTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.NTSB CEN11LA646Accident · No injuriesLimited investigationFinal reportBell 206B · Spicewood, TXThe pilot did not maintain adequate rotor rpm during a low-altitude maneuvering flight.NTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.NTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.NTSB ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.NTSB CEN11CA631Accident · No injuriesData collectionFinal reportCessna A188 · Ord, NEThe pilot's loss of directional control during a crosswind takeoff.NTSB CEN11CA540Accident · Serious injuriesData collectionFinal reportBell 47G-2 · Charles City, IAThe pilot's failure to refuel the helicopter which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11CA545Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Forest City, IAThe pilot's inadequate visual lookout during an aerial application run, which resulted in an in-flight collision with a windmill.NTSB CEN11CA503Accident · No injuriesData collectionFinal reportAero Commander 100 · Llano, TXThe student pilot's failure to attain the proper touchdown point and the flight instructor's delayed remedial action.NTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…NTSB ANC11CA056Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's misalignment of the helicopter on the landing structure.NTSB ANC11CA050Accident · No injuriesData collectionFinal reportCessna 180 · Big Lake, AKThe pilot's failure to maintain the proper glide path during his landing approach, resulting in an undershoot and collision with terrain.NTSB OPS11IA653Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fairbanks, AKInadequate air traffic control actions that failed to establish and maintain required separation between the two airplanes. Contributing to the incident was inexperience on the part of the local controller, inadequate oversight by the tower…NTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.NTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB ANC11CA025Accident · No injuriesData collectionFinal reportPiper PA-12 · Delta Junction, AKThe pilot's misjudged altitude while landing in bright sunlight on an airstrip surrounded by snow, resulting in an undershoot and a nose over.NTSB CEN11CA271Accident · No injuriesData collectionFinal reportCessna 172N · Appleton, WIThe student pilot's failure to maintain directional control of the airplane during takeoff.NTSB WPR11CA174Accident · Minor injuriesData collectionFinal reportCessna 182C · Stockton, CAThe pilot's failure to secure the airplane before pulling the propeller to start the engine.NTSB OPS11IA410Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAThe air traffic controllers’ failure to adhere to required radar identification procedures, which resulted in loss of separation between the departing Boeing 757 and three other airplanes. Contributing to the incident was the pilots’ inadequate preflight…NTSB CEN11LA209Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Kingsville, TXA pre-existing crack in the front spar of the right horizontal stabilizer near a riveted fitting, causing it to fail and separate from the airplane in flight. Contributing to the accident was the failure of maintenance personnel comply with existing service…NTSB WPR11CA107Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Meadview, AZThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller, resulting in inadvertent movement of the airplane and collision with the ground.NTSB CEN11CA147Accident · Minor injuriesData collectionFinal reportPegasus 503 Sport · Cambridge, OHThe pilot's failure to maintain clearance from trees and terrain during the landing approach.