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 GAA17CA046Accident · No injuriesData collectionFinal reportCirrus SR22 · Kirksville, MOThe pilot’s improper compensation for changing wind during the landing flare, which resulted in an off-centered landing and a subsequent loss of directional control.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA040Accident · No injuriesData collectionFinal reportPiper PA 20S · Arcadia, FLThe pilot's improper pitch and power control during landing in a straight float-equipped airplane on grass in crosswind conditions, which resulted in a loss of directional control.NTSB GAA17CA034Accident · No injuriesData collectionFinal reportYakovlev YAK · Tracy, CAThe pilot’s unstabilized approach and delayed application of full throttle for a go-around, which resulted in an uncontrolled descent.NTSB CEN17LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Buffalo, WYThe pilot’s failure to set the proper flap position before the short field takeoff, which resulted in a runway excursion and impact with terrain.NTSB WPR17LA015Accident · No injuriesLimited investigationFinal reportRyan W Gross Arion Lighting · Mesa, AZThe pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane.NTSB GAA17CA053Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Valley Center, KSThe pilot's failure to maintain directional control during the landing roll and to see and avoid the airplane stopped on the edge of the runway.NTSB GAA17CA043Accident · No injuriesData collectionFinal reportAeronca 11AC · Winter Haven, FLThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion.NTSB ERA17LA029Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Mount Ulla, NCThe passenger's failure to follow the pilot's instructions for properly securing herself during landing, which resulted in her serious injury when the balloon landed hard and the basket was dragged.NTSB CEN17FA024Accident · 2 fatalField investigationFinal reportBeech C23 · Osage Beach, MOThe pilot's loss of control while maneuvering shortly after takeoff. Contributing to the loss of control was the pilot's attempt to climb with the flaps fully extended.NTSB OPS17IA003IncidentClass 2 · IncidentFinal reportDouglas DC 9 83 · Westfield, MAThe air traffic controller issuing the aircraft a clearance to land while there was a vehicle authorized to be on the same runway. Contributing to the incident was the air traffic controller's decision to not simulcast the local control and ground control…NTSB GAA17CA050Accident · No injuriesData collectionFinal reportCessna 305 · Llano, TXThe pilot's failure to maintain directional control during the landing roll in cross wind conditions.NTSB ERA17FA027Accident · 1 fatalField investigationFinal reportNanchang CJ6 · Blackshear, GAThe Bama 3 pilot's failure to properly conduct an overshoot maneuver and his premature climb before he was clear of the lead airplane, Bama 1, which lead to a midair collisionNTSB GAA17CA041Accident · No injuriesData collectionFinal reportCessna A185 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll.NTSB GAA17CA039Accident · No injuriesData collectionFinal reportEvolution Revo · Carson City, NVThe pilot receiving instruction's inadvertent application of throttle during the engine start, which led to an inadvertent acceleration and a roll-over.NTSB GAA17CA036Accident · No injuriesData collectionFinal reportCessna 172 · Carrabassett, METhe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.NTSB GAA17CA032Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Carrollton, GAThe pilot's failure to verify the usable fuel in the fuel tanks, which resulted in an inaccurate fuel totalizer setting during preflight, fuel exhaustion, and a total loss of engine power.NTSB WPR17LA009Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec 90 · Caldwell, IDThe pilot's failure to properly tighten the tension bolts during the installation of the alternator belt, which resulted in inadequate voltage to sustain ignition and the subsequent partial loss of engine power.NTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.NTSB GAA17CA033Accident · Minor injuriesData collectionFinal reportStinson 108 3 · Boulder City, NVThe pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.NTSB ERA17LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLA partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…NTSB GAA17CA030Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Paragould, ARThe pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.NTSB CEN17LA023Accident · No injuriesLimited investigationFinal reportStinson 108 · Austin, TXThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA17CA042Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.NTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA024Accident · Minor injuriesData collectionFinal reportCessna 182 · Leesburg, VAThe pilot's improper landing flare, which resulted in a hard landing and subsequent runway excursion.NTSB ERA17LA015Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stockbridge, GAA partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA17FA017Accident · 3 fatalField investigationFinal reportPiper PA28 · Austin, PAThe pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…NTSB CEN17FA016Accident · 2 fatalField investigationFinal reportMakela RV-4 · Oregonia, OHThe pilot's decision to fly at a low altitude, which resulted in the collision with a zipline.NTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…NTSB GAA17CA047Accident · No injuriesData collectionFinal reportPiper PA 34 · Springfield, OHThe pilot’s inadequate compensation for gusting wind during the landing flare, which resulted in a hard landing.NTSB GAA17CA038Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Wilmington, OHThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion.NTSB GAA17CA031Accident · No injuriesData collectionFinal reportBellanca 17 30 · Burnet, TXThe pilot’s decision to continue the unstabilized approach and his failure to extend the landing gear before landing.NTSB GAA17CA051Accident · No injuriesData collectionFinal reportCessna 152 · Chickaloon, AKThe flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.NTSB GAA17CA027Accident · Minor injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe airplane's encounter with a depression while the pilot applied excessive braking during the landing roll on a grass airstrip, which resulted in a nose-over.NTSB GAA17CA026Accident · Serious injuriesData collectionFinal reportPiper PA 28 · Latrobe, PAThe pilot’s unstabilized approach, which resulted in the airplane’s wing striking the ground while the pilot was maneuvering to realign with the runway.NTSB ERA17LA018Accident · 1 fatalLimited investigationFinal reportCessna 208 · Dunnellon, FLThe jumpmaster's failure to guard the reserve parachute ripcord, which caused an inadvertent deployment of his reserve parachute.NTSB WPR17IA007Incident · No injuriesIncident investigationFinal reportShort Bros SD3 60 Sherpa · Missoula, MTThe failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…NTSB ERA17LA014Accident · No injuriesLimited investigationFinal reportCessna 525 · Pawtucket, RIThe flight crew's failure to maintain an appropriate approach speed and obtain an appropriate touchdown point on the runway, which resulted in a runway overrun.NTSB GAA17CA028Accident · Minor injuriesData collectionFinal reportNewkirk Thomas Ray Vans RV 6 · Garland, NCThe pilot's improper landing flare, which resulted in a bounced landing on the grass runway.NTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB GAA17CA020Accident · No injuriesData collectionFinal reportRemos Remos GX · Lowell, ARThe pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.NTSB ERA17FA011Accident · 1 fatalField investigationFinal reportPiper PA 34-200 · East Hartford, CTThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ERA17CA013Accident · Serious injuriesData collectionFinal reportMickler Larry J RV6 A · Bell, FLThe pilot's inadequate compensation for gusting crosswinds, which resulted in a bounced landing and nose-over.NTSB ERA17CA012Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Knoxville, TNThe pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires.NTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.