NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 FTW95TA218Accident · No injuriesFinal reportCessna R172K · Albuquerque, NMThe pilot's improper compensation for crosswind conditions. Factors were the crosswind, the proper touchdown point not attained, and the pilot not aborting the landing.NTSB FTW95LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Corpus Christi, TXThe pilot's inadequate compensation for crosswind conditions.NTSB FTW95LA212Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Owasso, OKThe failures of the landing gear hydraulic pump and the emergency gear extension system as result of inadequate maintenance by maintenance personnel.NTSB FTW95LA211Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lissie, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA156Accident · No injuriesLimited investigationFinal reportCessna 150G · Stockton, MOthe pilot's inadequate compensation for the crosswind weather condition and subsequent failure to maintain directional control. Factors were the crosswind and the ditch.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB NYC95LA113Accident · 1 fatalLimited investigationFinal reportBeech A23-24 · Atlantic City, NJThe pilot's delayed decision to abort the landing. Factors in the accident were: the downwind landing and the pilot's misjudgment of distance and speed.NTSB MIA95LA133Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Tallahassee, FLThe failure of a passenger to comply with flight crew instructions to remain seated with her seat belt fastened which resulted in her being injured while walking in the aisle during a turbulence encounter.NTSB MIA95IA134Incident · Serious injuriesIncident investigationFinal reportBoeing 727-227 · Brooksville, FLAn elderly passenger losing his balance as the aircraft operated in smooth air.NTSB LAX95LA192Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Colusa, CAthe pilot's misjudged flare height and timing, which resulted in an inadvertent stall and hard landing. Factors in the accident were the loss of engine power for undetermined reasons and the lack of a suitable forced landing area.NTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.NTSB FTW95LA207Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe ground service person's lack of attention and failure to remain clear of the turning propeller.NTSB CHI95LA157Accident · No injuriesLimited investigationFinal reportCessna 182P · French Lick, INthe pilot's not attaining a recovery from a bounced landing. Factors were high obstructions, and the pilot's intentional precautionary landing on rough/uneven and soft terrain.NTSB CHI95LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Hutchinson, MNthe pilot's not maintaining aircraft control. A factor was the crosswind condition.NTSB CHI95LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Kalkaska, MIFuel exhaustion due to the pilot's poor preflight and inflight planning and decisions. Factors were the powerlines and the inadvertent stall.NTSB CHI95FA153Accident · 1 fatalField investigationFinal reportRyan Navion · Sturgis, MIthe pilot's inadequate compensation for wind conditions during the attempted landing and go-around. A factor was the crosswind weather condition.NTSB NYC95LA112Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Clarkson, NYFailure of the engine fuel pump, which resulted in fuel starvation and loss of engine power over an unsuitable landing area. Factors relating to the accident were: the airplane manufacture did not list the use of the installed electric boost pumps, nor did…NTSB MIA95LA130Accident · No injuriesLimited investigationFinal reportCessna 172G · Sanford, FLThe pilot's failure to maintain airspeed during a forced landing resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of engine power while descending due to fuel exhaustion, and the…NTSB CHI95LA152Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Hatton, NDthe pilot's failure to maintain control of the airplane, and the excessive airspeed. Factors associated with the accident were the pilot's selection of unsuitable terrain for landing, and the soft, wet condition of the sod runway.NTSB ATL95LA097Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Franklin, TNThe pilot's improper use of the throttle which resulted in the loss of engine power. The pilot also failed to follow emergency procedures to restart the engine.NTSB ANC95LA055Accident · No injuriesLimited investigationFinal reportMaule M-5-235-C · Anchorage, AKA loss of engine power for an undetermined reason. A factor in the accident was the unsuitable terrain.NTSB SEA95IA102Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Spokane, WAA shorted electrical wiring on the elevator trim system.NTSB SEA95FA101Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cheyenne, WYfailure of the pilot to maintain sufficient altitude/clearance from rising terrain. Factors relating to the accident were: low light conditions at dusk, low ceilings with thunderstorms in the area, and continued flight by the pilot into adverse weather…NTSB NYC95LA111Accident · No injuriesLimited investigationFinal reportRockwell 112B · Edgewater, MDThe pilot's improper decision to continue his flight into the adverse weather conditions that existed at the destination airport. The weather contributed to the accident.NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB NYC95LA110Accident · 1 fatalLimited investigationFinal reportHighcraft Buccaneer II · Millstone Twsp, NJThe loss of engine power due to the seizure of the number one cylinder pistion and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB LAX95LA189Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Flagstaff, AZThe owner/pilot improper installation of the propeller by failing to properly connect the pitch change mechanism.NTSB FTW95LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baytown, TXThe pilot failed to maintain the proper glidepath during landing.NTSB FTW95LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Rockport, TXThe loss of engine power due to a stuck exhaust valve. The lack of suitable terrain for the forced landing was a factor.NTSB NYC95WA109Accident · No injuriesForeign investigationCessna 441 · Bayrouth, GermanyNTSB FTW95LA201Accident · 1 fatalLimited investigationFinal reportHarding 1500-R-MINI-MAX · Braggs, OKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to obtain or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall.NTSB FTW95LA199Accident · No injuriesLimited investigationFinal reportFairchild F-23A · Ozark, ARThe inadvertent stall while executing the turn to reverse direction during an aerial application flight.NTSB LAX95LA187Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Oakland, CAThe pilot's poor preflight planning/preparation by exceeding the airplane certificated maximum allowable takeoff gross weight and failure to abort the takeoff in a timely manner. The ditch was a factor in this accident.NTSB FTW95LA202Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Joes, COA total loss of power due to fuel exhaustion. Factors were: a malfunction in the fuel measuring system, the pilot's failure to perform fuel consumption calculations, and soft and unsuitable terrain for a forced landing.NTSB FTW95LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durango, COThe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW95LA195Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Frederick, COThe pilot's use of unsuitable terrain for takeoff and his delay in initiating an abort. Factors were a soft and wet air strip.NTSB CHI95LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · East Gull Lake, MNthe pilot's failure to maintain clearance from the trees. Factors in the accident were the crosswind and gusts.NTSB BFO95LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Oneonta, NYThe pilot's failure to maintain aircraft control during the attempted landing. The gusty crosswind condition was a related factor in this accident.NTSB SEA95LA100Accident · No injuriesLimited investigationFinal reportBoeing E75 · Newberg, ORThe pilot's improper use of the aircraft brakes. Contributing to the accident was the pilot's decision not to perform a go-around, which resulted in failure to attain the desired touchdown point on landing.NTSB NYC95LA108Accident · No injuriesLimited investigationFinal reportCessna 310J · Ararat, PAThe complete loss of electrical power for undetermined reasons, and the pilot's improper decision to make an off-airport landing.NTSB NYC95LA107Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Newark, DEThe pilot's improper use of throttle and collective controls, resulting in the loss of rotor rpm and the inflight loss of control.NTSB NYC95IA106Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Louisville, KYpreexisting crack(s) on the inside surface of the right main landing gear cylinder, and the subsequent fracture of the cylinder, which resulted in a collapse of the right main landing gear.NTSB FTW95LA200Accident · No injuriesLimited investigationFinal reportBeech D55 · Norman, OKThe pilot's inadvertent retraction of the landing gear, resulting in a gear up landing.NTSB FTW95LA198Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mount Pleasant, TXThe pilot's improper compensation for the crosswind component. A factor was the crosswind.NTSB BFO95LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dubois, PAThe failure of valve springs in the number two engine cylinder which resulted in a total loss of engine power during initial climb. The unsuitable terrain encountered during the subsequent forced landing was a factor.NTSB ATL95LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · Indian Trail, NCThe pilot's improper landing flare and improper recovery from a bounced landing.NTSB ANC95TA054Accident · No injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to verify the position of the parking brake knob prior to landing.NTSB SEA95LA099Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Sequim, WAFailure of an undetermined aircraft component, which resulted in a severe vibration, and subsequent ditching at sea. A factor relating to the accident was: the pilot's low cruising altitude (over water) of less than 1,000 feet, which limited his ability to…NTSB LAX95LA188Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe CFI's failure to apply adequate power during the flare which was a result of not maintaining the required engine and rotor rpm.NTSB FTW95LA197Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe inadvertent stall.