NTSB investigations
19,222 cases where NTSB found Aircraft.
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\", '01')) 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", '01')) 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 CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.NTSB CEN23LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Divide, COA loss of engine power during cruise flight for reasons that could not be determined.NTSB CEN23LA205Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Larchwood, IAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during initial climb after takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB ANC23LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · McGrath, AKThe pilot’s delayed decision to abort the takeoff, which resulted in a forced landing and impact with terrain.NTSB ANC23LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a water loop and impact with terrain.NTSB WPR23LA204Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Enterprise, UTThe pilot’s inability to maintain altitude during an initial climbout in mountainous terrain after encountering a suspected downdraft.NTSB ERA23FA249Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Plymouth, NYA total loss of engine power for reasons that could not be determined.NTSB CEN23LA221Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Doniphan, MOA partial loss of engine power for undetermined reasons.NTSB CEN23FA204Accident · 2 fatalClass 3 · FieldFinal reportLuce Buttercup · Lyndonville, NYAn in-flight breakup due to structural overload of the airplane for undetermined reasons.NTSB WPR23LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Minden, NVThe pilot’s failure to maintain directional control during the landing roll with a quartering headwind.NTSB WPR23LA205Accident · No injuriesClass 4 · LimitedFinal reportPiaggio Aero Industries P180 · Sugar Land, TXThe pilot’s failure to complete required preflight checklist items and properly configure the flaps for takeoff.NTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.NTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB ERA23FA247Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Lake Worth, FLMaintenance personnel’s failure to detect the corroded aileron cable during recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during takeoff.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB ERA23LA378Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Savannah, GAFailure and collapse of the nose landing gear during landing.NTSB ERA23LA245Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-25-260 · Hollywood, FLThe pilot’s improper banner pickup approach, which resulted in the banner tow hook contacting the airplane, and the subsequent overload separation of the right rudder control horn, resulting in a loss of airplane control.NTSB CEN23LA202Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Wright, LAThe pilot's decision to takeoff with the airplane overloaded which resulted in the airplane settling and subsequently impacting terrain.NTSB WPR23LA201Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177B · Tucson, AZA partial loss of engine power due to restricted fuel flow resulting from foreign object debris in the fuel flow transducer.NTSB WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB WPR23LA199Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Casa Grande, AZAn in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.NTSB CEN23FA201Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Grand Isle, LAThe pilot’s operation of the airplane while intoxicated, resulting in its impact with the ocean.NTSB ERA23LA244Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Reidsville, NCThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB CEN23LA256Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Romeoville, ILThe student pilot’s failure to attain/maintain a proper landing flare and failure to perform a go-around that resulted in an impact with the runway.NTSB CEN23LA200Accident · No injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Gregory, MIThe pilot’s improper landing flare that resulted in a hard, bounced landing and subsequent overstress failure of the nose landing gear.NTSB CEN23LA199Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Abbeville, LAThe pilot’s failure to maintain proper helicopter control during autorotation that resulted in an abnormal ground contact which caused the subsequent main rotor strike on the tail boom that severed the tail rotor driveshaft. Contributing to the accident was…NTSB CEN23LA198Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Wichita, KSThe pilot’s failure to maintain a safe taxi distance from a turbine-powered airplane, resulting in an encounter of the turbine-powered airplane’s jet blast while taxiing.NTSB CEN23LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Kansas City, MOThe student pilot's failure to maintain directional control during takeoff.NTSB ANC23LA038Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS350B2 · Honolulu, HIThe instructor pilot’s inadequate supervision of the pilot receiving instruction, which resulted in a hard landing, and substantial damage to the tail boom.NTSB WPR23LA195Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Mobile, AZThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.NTSB ERA23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Lancaster, TNThe fatigue failure of an exhaust valve, resulting in a partial loss of engine power.NTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.NTSB ERA23FA238Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Rougemont, NCA total loss of engine power due to oil starvation. The source of the oil starvation could not be determined.NTSB WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.NTSB WPR23LA197Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Redding, CAA fuel leak caused by an age-degraded fuel pressure sender hose, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was inadequate maintenance.NTSB WPR23LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · American Falls, IDThe pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA192Accident · 2 fatalClass 3 · LimitedFinal reportViking Air DHC-6-400 · Half Moon Bay, CAThe failure of the ferry fuel tank system to transfer fuel during a trans-Pacific flight for reasons that could not be determined, which resulted in fuel starvation and a subsequent ditching into the water.NTSB CEN23LA213Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ray, MIThe flight instructor’s failure to maintain airplane control during simulated engine-out procedures. Contributing to the accident was the flight instructor’s decision to land with a tailwind.NTSB CEN23LA192Accident · No injuriesClass 4 · LimitedFinal reportNorth American-Buehn T-6G · Ankeny, IAThe pilot’s inadvertent retraction of the landing gear control lever, resulting in a gear-up landing on the runway.NTSB ANC23LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Hunter Creek, AKThe pilot’s loss of directional control during takeoff roll in gusting wind conditions.NTSB WPR23LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172H · Seattle, WAA stuck exhaust valve that resulted in a partial loss of engine power and a forced water ditching.NTSB ERA23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportGary R Brearley RV-9A · Kingston, TNThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing which resulted in a nose over.NTSB CEN23LA208Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Cortez, COFailure of the right main landing gear due to prolonged corrosion of the landing gear tube, which weakened the gear.NTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.NTSB ERA23LA237Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-A90-1 · Petersburg, WVThe flight crew’s failure to ensure that the landing gear were properly configured before landing.NTSB ERA23FA235Accident · No injuriesClass 3 · FieldFinal reportHonda HA-420 · Summerville, SCThe pilot’s improper calculation of the airplane’s landing approach speed and required landing distance, which resulted in the airplane touching down fast with inadequate runway available, and a subsequent runway excursion.NTSB CEN23LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · Indianola, MSAn in-flight fire for undetermined reasons.NTSB WPR23LA300Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tracy, CAThe pilot’s failure to maintain directional control during the landing roll after encountering a wind gust.