NTSB investigations
19,008 cases where NTSB found Personnel issues.
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\", '02')) 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", '02')) 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 CEN20CA223Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182J · Olive Branch, MSThe student pilot's improper landing flare and the flight instructor's inadequate supervision, which resulted in a hard landing.NTSB WPR20LA163Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Fairfield, CAThe pilot’s failure to maintain adequate clearance from powerlines while conducting external load operations, which resulted in the main rotor contacting a wire and a subsequent collision with terrain.NTSB WPR20CA173Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Butte, MTThe pilot's failure to maintain airplane control during landing in turbulent conditions.NTSB ERA20LA202Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA23 · San Juan, PRThe pilot’s intentional operation of the airplane with known deficiencies of the left engine and subsequent in-flight loss of control after takeoff. Contributing to the loss of engine power was internal contamination of the left servo fuel injector.…NTSB ERA20CA205Accident · Serious injuriesClass 4 · Data collectionFinal reportMooney M20C · Durham, NCThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall..NTSB ANC20CA056Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Nikiski, AKThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a ground loop.NTSB WPR20LA157Accident · 1 fatalClass 3 · LimitedFinal reportCub Crafters CCK-1865 · Valley Center, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control.NTSB ERA20CA203Accident · No injuriesClass 4 · Data collectionFinal reportBeech 36 · Batavia, NYThe pilot's failure to extend the landing gear during a precautionary landing after an electrical failure.NTSB CEN20CA249Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Lahoma, OKThe loss of engine power due to fuel exhaustion and the pilot’s improper fuel planning before the flight.NTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.NTSB ANC20CA052Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT802 · Unalakleet, AKThe pilot's failure to maintain terrain clearance during the departure, which resulted in a collision with terrain..NTSB WPR20CA158Accident · No injuriesClass 4 · Data collectionFinal reportCessna P210 · Heber City, UTThe pilots failure to switch the fuel pump to the 'OFF' position during landing, resulting in a loss of engine power and subsequent collision with a fence during landing. Contributing to the accident was a modified before landing checklist which omitted the…NTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.NTSB CEN20LA199Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Pineville, LAThe airplane’s inability to gain sufficient airspeed after takeoff due to it being at or over its maximum gross weight, which resulted in a loss of control. Contributing to the accident was the pilot’s decision to operate the airplane at or over its maximum…NTSB CEN20CA206Accident · No injuriesClass 4 · Data collectionFinal reportZenair CH601 · Worthington, MNThe pilot's excessive brake application during the landing roll to avoid an animal on the runway, which resulted in a ground loop.NTSB CEN20CA205Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lakeview, ARThe pilot’s failure to maintain control of the airplane during the takeoff.NTSB CEN20CA202Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Arlington, TXThe pilot's failure to maintain airplane directional control during a gusty crosswind landing.NTSB ANC20LA053Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH701 · Ambler, AKThe pilot’s improper decision to take off from unsuitable terrain, which resulted in impact with uneven terrain, the subsequent failure of the nosewheel fork, and a nose over.NTSB WPR20CA162Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Elko, NVThe pilot's failure to maintain helicopter control in gusting wind that resulted in a loss in altitude and subsequent collision with a fence.NTSB ERA20LA197Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C-1 · Ozark, ALA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight school’s inadequate maintenance of the helicopter’s fuel quantity and caution systems.NTSB ANC20CA055Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Anchorage, AKThe pilot’s failure to maintain a proper descent rate during landing in gusting wind conditions, which resulted in a hard landing.NTSB WPR20CA159Accident · No injuriesClass 4 · Data collectionFinal reportGrumman G164 · Maxwell, CAThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the runway and collided with terrain. Contributing to the accident was the pilot's inadequate preflight…NTSB ERA20CA228Accident · Minor injuriesClass 4 · Data collectionFinal reportThorp Thorp T 18 · Madisonville, TNThe pilot's failure to maintain directional control during the landing roll on a soft turf runway, which resulted in a nose-over.NTSB CEN20LA203Accident · Minor injuriesClass 3 · LimitedFinal reportMagni Magni M 16 · Cape Girardeau, MOThe student pilot’s decision to take off with inadequate runway remaining, and his subsequent failure to attain proper airspeed, which resulted in the gyroplane’s descent into terrain.NTSB ANC20LA050Accident · Serious injuriesClass 3 · LimitedFinal reportRockwell 500 · Aniak, AKA loss of engine power due to the use of improper fuel. Contributing to the accident was the failure of the pilot and ground personnel to ensure that the airplane was serviced with the proper fuel.NTSB WPR20LA155Accident · 1 fatalClass 3 · LimitedFinal reportCSP Leasing Cavalon · Roseburg, ORA substantially unweighted rotor system for reasons that could not be determined, which resulted in contact between the main rotor blade and the gyrocopter’s keel tube and a loss of control and impact with terrain.NTSB WPR20CA160Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7ECA · Vine Grove, KYAircraft control was not maintained during initial climb with gusting wind that resulted in a collision with power lines and the terrain.NTSB ANC20CA051Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Sterling, AKThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and collision with trees.NTSB ANC20CA057Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Palmer, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB ERA20LA195Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · South Boston, VAThe powerplant mechanic’s failure to properly affix the engine crankshaft gear lockplate during overhaul, resulting in a total loss of engine power.NTSB CEN20CA194Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Appleton, WIThe pilot's loss of control while landing a tailwheel airplane.NTSB WPR20CA154Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Spotted Horse, WYThe pilot's loss of directional control during an aborted takeoff with a tailwind, which resulted in a noseover.NTSB ANC20CA054Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Gulkana, AKThe pilot's failure to maintain proper airspeed during final approach to landing, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.NTSB WPR20CA153Accident · Minor injuriesClass 4 · Data collectionFinal reportAyres S 2R · Artois, CAThe pilot's failure to maintain clearance from power lines during a go-around.NTSB CEN20CA191Accident · No injuriesClass 4 · Data collectionFinal reportPietenpol Aircamper · Midland, MIThe pilot's loss of control during an aborted landing.NTSB CEN20CA190Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Bunkie, LAThe pilot's failure to maintain directional control during takeoff.NTSB CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.NTSB CEN20CA192Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Carbondale, ILThe pilot's excessive brake input while he attempted to maintain directional control during landing roll.NTSB CEN20CA195Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Houma, LAThe pilot's failure to maintain adequate clearance from a ground obstacle during landing.NTSB WPR20LA152Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR20 · Santa Maria, CAThe pilot’s exceedance of the airplane’s critical angle of attack during a steep and descending turn to final approach, which resulted in an aerodynamic stall and loss of control.NTSB CEN20LA187Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · West Branch, MIThe pilot's failure to maintain rotor rpm during a precautionary autorotation, which resulted in a hard landing. Contributing to the accident was the airframe vibration for reasons that could not be determined because examination of the helicopter revealed no…NTSB CEN20CA188Accident · No injuriesClass 4 · Data collectionFinal reportCessna R172 · Lino Lakes, MNThe pilot's loss of directional control during takeoff with a crosswind.NTSB DCA20LA107Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737 · Victorville, CAImproper installation of dorsal fin attach bolts which caused the dorsal fin to separate during flight, substantially damaging the left horizontal stabilizer.NTSB CEN20CA184Accident · No injuriesClass 4 · Data collectionFinal reportRhoads, Larry E Sopwith Baby · Lee's Summit, MOThe airplane builder's improper installation of the lower right wing which resulted in an uncommanded left roll and the subsequent loss of control.NTSB WPR20LA161Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Cascade Locks, ORThe pilot’s improper fuel tank selection which resulted in fuel starvation to the engine and a loss of engine power.NTSB WPR20CA149Accident · No injuriesClass 4 · Data collectionFinal reportCessna 185 · Winifred, MTAn inadequate flare that resulted in a bounced landing and the pilot's subsequent delayed decision to go-around that did not allow for sufficient clearance from trees when the airplane was affected by a gusting wind.NTSB WPR20CA150Accident · Serious injuriesClass 4 · Data collectionFinal reportAir Creation Tanarg · Buckeye, AZThe failure of the pilot to adequately maintain a safe distance from the airplane's propeller, which resulted in a serious injury when the propeller struck his hand.NTSB ERA20LA188Accident · Minor injuriesClass 3 · LimitedFinal reportVaughn Challenger · Clarksville, TNThe loss of engine power due to carburetor ice.NTSB ERA20CA190Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Oxford, CTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB ERA20CA189Accident · No injuriesClass 4 · Data collectionFinal reportZenith Zodiac CH 650 · Carthage, NCThe pilot's failure to attain the proper touchdown point during landing with a tail wind, which resulted in a runway excursion.