NTSB investigations
10,307 cases where NTSB found Environmental 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\", '03')) 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", '03')) 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 WPR20CA195Accident · Minor injuriesClass 4 · Data collectionFinal reportCapella XLS · Liberty, UTThe pilot's failure to maintain clearance from a fence post during the initial climb.NTSB WPR20CA192Accident · Serious injuriesClass 4 · Data collectionFinal reportNorth Wing Uum Scout X-C · Rochester, WAThe pilot’s failure to maintain adequate airspeed while on final approach in turbulent conditions, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA20CA224Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Burlington, VTThe pilot’s failure to maintain directional control during landing roll in crosswind conditions.NTSB ERA20CA223Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Monroe, NCThe pilot's inadequate assessment of the landing area, which resulted in the airplane's encounter with tall weeds during landing and a subsequent nose-over.NTSB CEN20CA240Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer 269C · Sheffield, TXThe pilot's failure to maintain adequate clearance from a fence while hovering.NTSB ERA20CA222Accident · No injuriesClass 4 · Data collectionFinal reportBeech 77 · Elizabethton, TNThe student pilot's decision to continue from visual flight into instrument meteorological conditions, which resulted in a collision with trees and mountainous terrain.NTSB ERA20CA227Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Churchville, MDThe student pilot's improper landing flare and improper recovery from a bounced landing in gusty wind conditions, which resulted in a hard landing.NTSB ERA20LA220Accident · 1 fatalClass 3 · LimitedFinal reportRobinson R66 · Pikeville, NCThe pilot’s failure to see and avoid a small diameter wire during low altitude agricultural spraying operations. Contributing to the accident was the pilot’s insufficient property survey.NTSB CEN20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCX-2000-0086 · Gypsom, COThe pilot's failure to maintain airplane control during landing in gusting wind conditions.NTSB CEN20CA232Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Ely, MNThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapse during a gusty landing.NTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.NTSB WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.NTSB ANC20LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Fairbanks, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive carburetor to icing, which resulted in a total loss of engine power.NTSB ERA20CA215Accident · No injuriesClass 4 · Data collectionFinal reportPipistrel Pipistrel Sinus 912 · Brookline, NHThe pilot's failure to maintain airspeed while landing with a quartering tailwind, which resulted in a loss of control and a hard landing.NTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.NTSB WPR20CA179Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Lenore, IDThe pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.NTSB CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.NTSB ERA20CA210Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · St. Mary's, PAThe pilot's failure to maintain proper glide path during final approach which resulted in a collision with airport equipment short of the runway.NTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.NTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…NTSB ERA20CA209Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA38 · Cumberland, MDThe pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.NTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.NTSB ANC20CA058Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Palmer, AKThe pilot’s improper decision to load the airplane beyond its allowable gross weight limits, which resulted in an impact with a tree and collision with terrain.NTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.NTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…NTSB WPR20CA171Accident · Minor injuriesClass 4 · Data collectionFinal reportEnstrom 480 · Murphy, IDThe pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.NTSB CEN20CA218Accident · No injuriesClass 4 · Data collectionFinal reportGlasflugel Mosquito · Alvarado, TXThe pilot's decision to divert to the private airport and his subsequent failure to maintain directional control while landing on a turf runway that contained tall grass.NTSB CEN20CA213Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Cadillac, MIThe pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.NTSB WPR20CA166Accident · No injuriesClass 4 · Data collectionFinal reportAviat A 1 · Glendive, MTThe pilot's failure to maintain airplane control during landing in gusting wind condition which resulted in a collision with terrain.NTSB WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.NTSB CEN20LA207Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Duluth, MNThe pilot’s failure to remove an object from the airplane’s exterior, which impacted the propeller blades when he applied full power, causing them to fracture and damage the airplane.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 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 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 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 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 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 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 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 CEN20CA195Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Houma, LAThe pilot's failure to maintain adequate clearance from a ground obstacle during landing.NTSB CEN20LA186Accident · 2 fatalClass 3 · LimitedFinal reportCessna T206 · Center, TXThe non-instrument rated pilot’s intentional flight into instrument meteorological conditions (clouds) which resulted in spatial disorientation and an inflight loss of control.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 ERA20LA188Accident · Minor injuriesClass 3 · LimitedFinal reportVaughn Challenger · Clarksville, TNThe loss of engine power due to carburetor ice.