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 ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.NTSB WPR24FA156Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Bandera, WAThe pilot’s decision to continue flight into icing conditions and inclement weather, which likely led to spatial disorientation when he attempted to divert from the planned course to the destination airport.NTSB ERA24LA220Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · New Washington, OHThe pilot’s failure to maintain clearance from powerlines during an aerial application flight.NTSB CEN24LA191Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Dell City, TXThe pilot’s failure to switch fuel tanks while en route which resulted in the loss of engine power due to fuel starvation.NTSB ANC24FA032Accident · 2 fatalClass 3 · FieldFinal reportTaylorcraft BC12-D · Nondalton, AKThe non-certificated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into the water.NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB ERA24FA217Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Franklin, TNThe pilot’s flight into convective weather, which resulted in a loss of control due to spatial disorientation and a subsequent inflight breakup of the airplane. Contributing to the accident was the lack of accurate weather intensity depiction on the…NTSB CEN24LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Shreveport, LAThe airplane’s collision with a deer on the runway during landing.NTSB WPR24LA149Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Bonners Ferry, IDThe student pilot’s failure to maintain control of the airplane during landing in gusting wind conditions.NTSB CEN24FA179Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Marianna, ARThe pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.NTSB WPR24LA151Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman G164 · Maxwell, CAThe pilot’s failure to ascertain a proper touchdown point and late decision to initiate a go-around, which resulted in a subsequent collision with vegetation.NTSB WPR24LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Chandler, AZThe pilot’s failure to maintain clearance from obstacles during taxi operations.NTSB CEN24LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · New Century, KSThe inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.NTSB CEN24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Chesaning, MIThe pilot’s failure to maintain control while landing on a wet turf runway, which resulted in a runway excursion and impact with trees. Contributing to the accident was the pilot’s failure to ensure the passenger’s proper use of seatbelts before the landing.NTSB WPR24LA148Accident · No injuriesClass 3 · LimitedFinal reportKjelsrud Gary Kitfox · Powell, WYThe pilot’s adjustment of the carburetor to an incorrect setting, which resulted in partial loss of engine power during takeoff.NTSB CEN24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Davis, OKThe pilot’s failure to maintain proper airspeed on approach which resulted in an extended touchdown, bounced landing, and runway overrun.NTSB WPR24LA145Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot’s failure to maintain directional control during takeoff with a gusty crosswind.NTSB CEN24LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Midland, TXThe pilot’s failure to maintain airplane control during a go-around in a gusting crosswind, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot’s lack of system knowledge regarding the operation of the…NTSB ERA24LA210Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Titusville, FLThe pilot’s failure to maintain directional control while landing in variable wind conditions, which resulted in runway excursion and collision with an approach light.NTSB ERA24FA209Accident · 2 fatalClass 3 · FieldFinal reportRockwell International 690A · Palmyra, VAThe pilot’s loss of control following an encounter with structural icing, which resulted in an inflight breakup of the airplane.NTSB DCA24FA179Accident · Minor injuriesClass 2 · FieldFinal reportEmbraer EMB-145LR · Houston, TXThe captain’s unintentional use of the nose down pitch trim during final approach which limited the elevator control authority resulting in a hard landing that collapsed the left main landing gear.NTSB WPR24LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna T206H · Halls Crossing, UTThe airplane’s collision with a tree during an aborted landing. Contributing to the accident was the airplane’s reported brake malfunction for undetermined reasons.NTSB WPR24LA138Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA315B · Lewiston, IDThe pilot’s failure to maintain clearance from power lines during a low level aerial application.NTSB ERA24LA212Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Georgetown, OHAn inadvertent encounter with the rotor wash of a nearby hovering helicopter during landing, which resulted in a loss of control and a runway excursion.NTSB CEN24LA174Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · West Chicago, ILThe flight instructor’s failure to maintain control of the airplane during an encounter with wind while holding short of the runway.NTSB CEN24LA176Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Watervliet, MIThe pilot’s failure to maintain control during the landing roll on a soft turf runway.NTSB CEN24LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · England, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering during a low-level aerial application flight.NTSB WPR24LA144Accident · No injuriesClass 4 · LimitedFinal reportRans S7 · Hemet, CAThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR24LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Scappoose, ORThe pilot’s failure to maintain aircraft control during the landing roll in gusting wind conditions.NTSB CEN24LA177Accident · No injuriesClass 4 · LimitedFinal reportZenith CH-750 · Seymour, INThe flight instructor’s failure to maintain clearance from a fence during a takeoff attempt.NTSB CEN24LA168Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Clearbrook, MNThe pilot’s delayed use of carburetor heat which resulted in the loss of engine power due to carburetor icing.NTSB ERA24LA195Accident · No injuriesClass 4 · LimitedFinal reportReddick Jonathan L Zodiac 601XLB · Dunbar, PAA total loss of engine power as a result of an improperly fabricated fuel-air mixture cable bracket. Contributing was the pilot’s decision to fly the airplane with a known mechanical engine issue, and the presence of another airplane that was back taxiing on…NTSB DCA24LA174Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Hogansville, GAAn encounter with convectively induced turbulence during descent.NTSB ERA24LA201Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Beach City, OHA total loss of engine power due to the due to the pilot’s delayed application of carburetor heat.NTSB CEN24LA165Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Olney, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.NTSB CEN24FA164Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy FG · Spicewood, TXThe pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR24LA127Accident · No injuriesClass 3 · LimitedFinal reportSchleicher Alexander ASH 26 E · Heber, UTReduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.NTSB WPR24LA128Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4-Place · Buckhorn, NMThe pilot’s inflight loss of control during landing following an encounter with a wind gust which resulted in a hard landing.NTSB ERA24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zelienople, PAThe pilot’s inadequate compensation for the gusting crosswind condition during landing.NTSB CEN24FA160Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Hartsburg, MOThe pilot’s encounter with convective weather conditions, which resulted in a loss of airplane control, the exceedance of the airplane’s never exceed speed, and the resulting overload failure of the horizontal stabilizer and subsequent failure of the…NTSB ERA24LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Manassas, VAThe pilot’s failure to apply carburetor heat before reducing engine power during a prolonged descent while operating in environmental conditions conducive to the development of carburetor ice, which resulted in a total loss of engine power due to carburetor…NTSB CEN24LA158Accident · No injuriesClass 3 · LimitedFinal reportJacobson SE5A Replica · Luther, OKThe pilot’s failure to use carburetor heat, which resulted in fuel starvation during the initial climb, a loss of engine power, and impact with terrain.NTSB WPR24FA124Accident · 1 fatalClass 3 · FieldFinal reportGulfstream 695A · San Bernardino, CAThe pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ANC24LA028Accident · No injuriesClass 4 · LimitedFinal reportTeam Rocket F1 · Payson, AZThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.NTSB CEN24LA162Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe rudder post’s failure due to corrosion fatigue. Contributing to the accident were the misalignment of the rudder hinge components, which produced mechanical binding and elevated localized stress, and a compromised the protective coating, which allowed…NTSB ANC24LA030Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during takeoff in gusting wind conditions, which resulted in collision with an object.NTSB ERA24LA175Accident · Minor injuriesClass 4 · LimitedFinal reportHaring Robert C Zenith CH601XLB · East Amherst, NYThe pilot’s failure to maintain directional control and his decision to continue the takeoff from the soft turf runway.NTSB CEN24LA154Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Council Bluffs, IAThe pilot's failure to maintain directional control during the takeoff with a direct gusting crosswind.NTSB ERA24LA171Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · South Kingstown, RIThe pilot’s failure to maintain clearance from the water while maneuvering at low altitude.