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 WPR25LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Los Angeles, CAA partial loss of engine power due to carburetor ice accumulation.NTSB ERA25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during landing in a gusting crosswind, which resulted in a hard landing and runway excursion.NTSB CEN25LA039Accident · No injuriesClass 4 · LimitedFinal reportAtkinson Jeffrey M RV-8 · Denton, TXThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB WPR25LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Lancaster, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR25LA032Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Prescott, AZThe flight instructor’s failure to maintain clearance from a fence during taxi. Contributing to the accident was the low light conditions and obstacles adjacent to the deice bay.NTSB WPR25LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Priest River, IDThe pilot's failure to attain a proper touchdown point and his inability to stop the landing roll on a wet gras runway, which resulted in a collision with a tree.NTSB ERA25LA040Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 369D · Waycross, GAAn encounter with a foreign object, which resulted in a loss of control and collision with terrain.NTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.NTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB ERA25LA027Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Canal Winchester, OHAn in-flight collision with a bird while in cruise flight.NTSB CEN25LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Pineville, LAThe airplane’s collision with a stake on a closed runway. Contributing to the accident was the pilot’s inadequate preflight planning and failure to see the closed runway markings.NTSB ERA25LA039Accident · No injuriesClass 4 · LimitedFinal reportCessna T240 · Fort Myers, FLThe pilot’s inadequate compensation for the prevailing wind conditions while landing, which resulted in a runway excursion and collision with a sign.NTSB ERA25LA028Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · St. Agatha, MEA partial loss of engine power due to carburetor ice as a result of the pilot’s delayed use of carburetor heat while operating in environmental conditions conducive to serious carburetor icing.NTSB ERA25LA026Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sebring, FLA birdstrike during descent to the destination airport.NTSB CEN25LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Falcon, COThe student pilot’s failure to maintain aircraft control and the flight instructor’s delayed remedial action during takeoff, which resulted in a collision with a taxiway sign.NTSB CEN25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Denton, TXThe partial loss of engine power during the initial climb and the pilot’s failure to maintain directional control during the forced landing with a tailwind.NTSB CEN25FA019Accident · 4 fatalClass 2 · FieldFinal reportRobinson R44 · Houston, TXThe pilot’s failure to maintain clearance from a lighted radio tower during a visual night flight. Contributing to the accident was the air traffic controller’s failure to issue a safety alert notifying the pilot of the flight’s unsafe proximity to the tower.NTSB WPR25LA021Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Rexburg, IDThe pilot’s failure to see and avoid transmission wires during the landing approach.NTSB CEN25LA024Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2A · Stoughton, WIThe pilot’s failure to maintain directional control during landing.NTSB WPR25LA023Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons US A-275 · Wittmann, AZThe pilot’s failure to maintain clearance from a power line during an approach.NTSB ERA25LA034Accident · No injuriesClass 4 · LimitedFinal reportHunt Exec 162F · North East, PAThe pilot’s failure to maintain control of the helicopter during landing following an encounter with an unanticipated wind gust, which resulted in a dynamic rollover.NTSB CEN25LA020Accident · No injuriesClass 4 · LimitedFinal reportStarship Enterprise · Addison, TXForeign object debris damage to the ventral stabilizer.NTSB ERA25LA017Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · East Ellijay, GAThe pilot’s inadequate compensation for winds during landing., which resulted in a loss of control and an aerodynamic stall.NTSB ERA25LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Newnan, GAThe pilot’s inadequate use of carburetor heat during the engine run-up, which resulted in a partial loss of power due to carburetor icing during takeoff.NTSB ERA25FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Savannah, GAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power to both engines.NTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.NTSB WPR25LA019Accident · No injuriesClass 4 · LimitedFinal reportJared Baker Rans DSG INC S21 OUT · Springer, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with an obstacle.NTSB WPR25LA016Accident · No injuriesClass 4 · LimitedFinal reportLindstrand 80E · Albuquerque, NMThe pilot’s loss of control during landing, which resulted in the balloon’s envelope contacting powerlines.NTSB ERA25LA014Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · South Charleston, WVThe pilot’s decision to continue landing after encountering a strong tailwind, which resulted in a loss of control and subsequent runway excursion.NTSB WPR25LA015Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Moriarty, NMThe pilot’s failure to maintain an adequate glidepath, which resulted in the glider landing on rough terrain short of the runway.NTSB CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…NTSB WPR25LA081Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US ZL-70 · Rio Rancho, NMThe pilot’s inability to maintain clearance from a tree during the landing approach due to a gusting wind shift.NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.NTSB WPR25LA005Accident · Serious injuriesClass 4 · LimitedFinal reportRotorsport Cavalon · Chico, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent descent and subsequent collision with trees.NTSB CEN25LA011Accident · Serious injuriesClass 4 · LimitedFinal reportPowrachute SKY Rascal · Peculiar, MOThe failure of the pilot to use appropriate engine power during descent in turbulent air which resulted in a loss of control.NTSB ANC25LA004Accident · No injuriesClass 4 · LimitedFinal reportCessna U206B · Skwentna, AKThe pilot’s delayed go-around decision, which resulted in inadvertent contact with the landing surface, loss of directional control, and a nose over in gusting wind conditions.NTSB CEN24LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Pierz, MNThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.NTSB CEN24LA372Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Eden Prairie, MNThe bird strike during cruise flight that resulted in substantial damage to the airplane.NTSB CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN24LA368Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Lexington, NEThe pilot’s failure to maintain proper clearance from powerlines.NTSB WPR24LA311Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC11 · Grand View, IDThe pilot’s loss of control after encountering a dust devil during taxi.NTSB WPR24LA310Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Redlands, CAThe pilot’s failure to maintain airplane control during final approach, which resulted in a collision with rocky terrain.NTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB ERA24LA396Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Elyria, OHThe pilot's failure to maintain directional control during the landing roll with a direct crosswind.NTSB ANC24LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Bettles, AKThe pilot’s failure to adequately compensate for shifting wind conditions, resulting in a hard landing.NTSB WPR24LA317Accident · No injuriesClass 4 · LimitedFinal reportYakovlev YAK-50 · Watsonville, CAThe Yak-50 pilot’s failure to maintain clearance from another airplane while taxiing and maneuvering. Contributing to the accident was the pilot’s inattention due to a distraction inside the cockpit.NTSB CEN24LA360Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Shakopee, MNThe pilots’ failure to apply carburetor heat during the descent, which resulted in a loss of power on both engines due to carburetor ice.NTSB WPR24LA314Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206G · West Sacramento, CAFailure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.