NTSB investigations
1,131 cases where the sequence of events included Other weather encounter.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN15FA164Accident · 1 fatalField investigationFinal reportAirbus Helicopters (Eurocopte EC-130-B4 · St Louis, MOThe pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.NTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.NTSB CEN15CA188Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Akron, OHThe pilot's failure to maintain directional control during a crosswind landing in gusting crosswind conditions.NTSB CEN15LA106Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Shipshewana, INThe total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…NTSB CEN15CA105Accident · No injuriesData collectionFinal reportCessna 172K · Holland, MIThe pilot's loss of control while landing in gusty wind conditions.NTSB CEN15LA103Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons USA 120A · Peru, INThe hard landing due to a higher-than-forecast surface wind, which resulted in a serious neck injury to the pilot.NTSB CEN15LA091Accident · No injuriesLimited investigationFinal reportCessna 208B · Roswell, NMThe pilot's failure to maintain adequate airspeed to compensate for icing on the airplane's wings and control surfaces during a circling approach, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN15CA213Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Mesquite, TXThe pilot's loss of directional control while landing in gusting crosswind conditions, which exceeded the airplane's maximum demonstrated crosswind velocity.NTSB CEN15LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-500 · Sugarland, TXThe pilot's engagement of the emergency parking brake during the landing roll, which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the pilot's decision to engage the emergency parking…NTSB CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…NTSB CEN15FA040Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Grover Hill, OHThe airplane's encounter with supercooled large droplet (SLD) icing, which resulted in a loss of lift and a subsequent uncontrolled descent into terrain. Also causal was the pilot's preflight and in-flight decision to fly in known icing conditions in an…NTSB ERA15CA042Accident · No injuriesData collectionFinal reportCessna 172M · Everglades City, FLThe student pilot's failure to compensate for gusting wind conditions during the flare, and the flight instructor's failure to intervene in a timely manner, resulting in a loss of airplane control and hard landing off of the runway.NTSB CEN15CA065Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Branson, MOThe pilot's failure to maintain aircraft control when executing a landing with a tailwind, resulting in impact with a retaining wall.NTSB ENG15IA037Incident · No injuriesIncident investigationFinal reportBoeing 787-8 · London, United KingdomA shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…NTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.NTSB ANC14CA090Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Port Alsworth, AKThe pilots failure to maintain control of the airplane during an aborted landing in gusty wind conditions.NTSB CEN14CA525Accident · No injuriesData collectionFinal reportBell 206B · Nashoba, OKThe pilot's loss of directional control due a loss of tail rotor effectiveness.NTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.NTSB ANC14CA079Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Susitna, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.NTSB CEN14CA503Accident · No injuriesData collectionFinal reportMaule MT 7-260 · Largo Vista, TXThe pilot's inadequate compensation for gusting wind conditions during takeoff, which resulted in the nose landing gear impacting the runway and the subsequent collapse of the nose landing gear.NTSB CEN14CA470Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Minneapolis, MNThe pilot's loss of control while landing with a crosswind. Contributing to the accident was the pilot lack of experience flying in similar weather conditions.NTSB CEN14LA447Accident · Serious injuriesLimited investigationFinal reportHerder Michael Zodiac 601 HD · Fredericksburg, TXThe pilot’s loss of airplane control during a gusting crosswind landing.NTSB CEN14LA431Accident · Serious injuriesLimited investigationFinal reportAeronca S11AC · Boulder Junction, WIThe pilot’s improper runway selection, which resulted in a tailwind landing, and his subsequent failure to maintain directional control.NTSB CEN14LA406Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Manistee, MIThe pilot receiving instruction's inability to respond to or compensate for the sudden change in wind direction and speed that the airplane encountered shortly after liftoff, which resulted in a tailwind condition, a corresponding decrease in airspeed, and a…NTSB CEN14CA428Accident · Minor injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Frankfort, MIThe pilot's improper recovery from a bounced landing in gusty, crosswind conditions. Contributing to the accident was the pilot lack of recent tail wheel landing experience.NTSB ANC14LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot’s failure to maintain directional control during the landing due to his decision to attempt a landing with a quartering tailwind, which resulted in a ground loop and impact with the runway surface.NTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.NTSB CEN14CA386Accident · No injuriesData collectionFinal reportBlack Christopher Sparrow Sport Spec · Moriarty, NMThe pilot's loss of directional control while landing in gusty crosswind conditions. Contributing to the accident was the pilot's operation of the engine above its normal temperature limit on takeoff.NTSB CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.NTSB CEN14LA326Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350B · Mayhill, NMThe pilot's failure to maintain helicopter control while performing a go-around in strong, gusting wind conditions. Contributing to the accident was the pilot's decision to initiate the flight in strong, gusting wind conditions.NTSB WPR14FA231Accident · 1 fatalField investigationFinal reportGrumman G 21A · Sula, MTThe pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.NTSB CEN14LA299Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Dell, ARThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.NTSB CEN14LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winner, SDThe pilot's improper decision to attempt a takeoff with a tailwind and his failure to achieve the proper airspeed for liftoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB ERA14CA284Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Defuniak Springs, FLThe pilot's failure to maintain directional control in gusty wind conditions during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN14CA280Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus 3/24.5 · Wallis, TXThe pilot's failure to maintain direction control of the glider during takeoff in gusty wind conditions.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.NTSB CEN14CA246Accident · No injuriesData collectionFinal reportNorth American SNJ 6 · Santa Fe, NMThe pilot's loss of directional control during landing and subsequent go around attempt.NTSB ERA14CA234Accident · Minor injuriesData collectionFinal reportSam R Peachey Just Aircraft Highla · Roxbury, PAThe pilot's failure to maintain adequate airspeed during low altitude maneuvering.NTSB ERA14CA243Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Meadville, PAThe pilot's failure to maintain directional control during an attempted go around in gusty wind conditions which resulted in a collision with terrain.NTSB CEN14CA215Accident · Serious injuriesData collectionFinal reportFirefly 8B-15 · Security, COAn unexpected increase in wind velocity which resulted in a hard landing and the subsequent passenger injury.NTSB WPR14CA168Accident · Minor injuriesData collectionFinal reportLinstrand 240A · Mayer, AZThe balloon's encounter with unexpected increased wind, which resulted in a hard landing on rough terrain.NTSB ERA14CA200Accident · No injuriesData collectionFinal reportKaldor Gregory N Zenith 701 · Eutaw Springs, SCThe pilot's improper decision to execute a precautionary landing to unsuitable terrain following an inflight encounter with a wind gust, resulting in substantial damage to the airplane.NTSB WPR14CA162Accident · No injuriesData collectionFinal reportCessna 207 · Shaw Island, WAThe pilot's loss of directional control during the landing flare with a gusting tailwind.NTSB ERA14CA188Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Bethel, METhe pilot's failure to maintain control of the airplane while taxiing after landing during gusty wind conditions.NTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.NTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.NTSB CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.NTSB CEN14LA134Accident · No injuriesLimited investigationFinal reportCessna 172K · Milan, ILThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during a short final approach.