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.

NTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.Feb 21, 2019 · N108TE · Substantial damageNTSB GAA19CA142Accident · No injuriesData collectionFinal reportCirrus SR22 · Tulsa, OKThe pilot's failure to maintain a stabilized approach with a tailwind and his subsequent failure to maintain yaw control during an attempted go-around.Feb 20, 2019 · N381DE · Substantial damageNTSB GAA19CA141Accident · No injuriesData collectionFinal reportRobinson R22 · Clearwater, FLThe flight instructor's failure to maintain sufficient altitude over uneven terrain during a hover taxi, which resulted in ground contact and a subsequent dynamic rollover.Feb 19, 2019 · N512GS · Substantial damageNTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.Feb 18, 2019 · N350ST · Substantial damageNTSB WPR19LA094Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Montague, CAThe pilot’s failure to maintain directional control while landing on a wet/icy runway.Feb 15, 2019 · N5849C · Substantial damageNTSB GAA19CA137Accident · No injuriesData collectionFinal reportCessna 172 · Sanford, FLThe student pilot's failure maintain the proper pitch attitude during landing, which resulted in the airplane porpoising.Feb 15, 2019 · N572ND · Substantial damageNTSB CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.Feb 15, 2019 · N737MC · Substantial damageNTSB CEN19FA082Accident · 2 fatalClass 2 · FieldFinal reportCessna 421 · Canadian, TXThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions with icing conditions present, which resulted in an aerodynamic stall and spin into terrain.Feb 15, 2019 · N421NS · DestroyedNTSB GAA19CA145Accident · No injuriesData collectionFinal reportPiper PA32 · Lacon, ILThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a subsequent impact with a snowbank.Feb 14, 2019 · N3708W · Substantial damageNTSB GAA19CA138Accident · No injuriesData collectionFinal reportCessna 172RG · Atlanta, GAThe pilot's failure to extend the landing gear before landing. Contributing to the accident were the pilot’s inability to see the landing gear position light because his iPad was blocking his view of it and his feeling of being rushed during the approach and…Feb 13, 2019 · N5223V · Substantial damageNTSB GAA19CA140Accident · No injuriesData collectionFinal reportPiper PA24 · Slaton, TXThe student pilot's complacency, which led to his improper crosswind correction and subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground collision.Feb 12, 2019 · N9184P · Substantial damageNTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.Feb 11, 2019 · N750TA · Substantial damageNTSB WPR19LA088Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Laramie, WYAn environmental stress cracking failure of the acrylic windshield, which resulted in a rapid decompression during cruise flight.Feb 10, 2019 · N549CJ · Substantial damageNTSB GAA19CA143Accident · No injuriesData collectionFinal reportCessna 421 · Woodruff, WIThe pilot's failure to maintain to directional control during takeoff from a snow-covered runway with a right, quartering tailwind, which resulted in a runway excursion and impact with a snowbank.Feb 10, 2019 · N581CJ · Substantial damageNTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.Feb 10, 2019 · N9101X · Substantial damageNTSB ERA19TA098Accident · Minor injuriesClass 3Final reportCessna 172 · Lignum, VAA total loss of engine power for undetermined reasons.Feb 10, 2019 · N7414N · Substantial damageNTSB GAA19CA133Accident · No injuriesData collectionFinal reportDenney Kitfox IV Speedster · Page, AZThe pilot's failure to maintain lateral control during the landing flare, which resulted in the left wing striking a tree.Feb 8, 2019 · N995BW · Substantial damageNTSB ERA19LA096Accident · 1 fatalLimited investigationFinal reportConvair C131 · Atlantic Ocean (Atlantic Ocean)The captain's decision to continue with the flight with a malfunctioning left engine propeller control and the subsequent loss of engine power on both engines for undetermined reasons, which resulted in ditching into the ocean. Contributing to the accident…Feb 8, 2019 · N145GT · DestroyedNTSB WPR19TA085Accident · Serious injuriesClass 3Final reportPiper PA46 · Aurora, ORThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing during a simulated power-off approach and landing, which resulted in an aerodynamic stall and loss of control and the flight instructor’s failure to adequately…Feb 6, 2019 · N997MA · Substantial damageNTSB WPR19FA080Accident · 2 fatalClass 2 · FieldFinal reportCessna 172 · Desert Hot Springs, CAThe pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.Feb 6, 2019 · N20556 · DestroyedNTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.Feb 4, 2019 · N9525V · Substantial damageNTSB WPR19FA079Accident · 5 fatalClass 3 · FieldFinal reportCessna 414 · Yorba Linda, CAThe pilot’s failure to maintain airplane control after entering instrument meteorological conditions (IMC) while climbing due to spatial disorientation, which resulted in the exceedance of the airplane’s design stress limits and subsequent in-flight break-up.…Feb 3, 2019 · N414RS · DestroyedNTSB ERA19LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Knotts Island, NCA total loss of engine power due to fuel exhaustion, which resulted from the pilot's improper fuel planning.Feb 2, 2019 · N6789F · Substantial damageNTSB ERA19LA094Accident · 1 fatalLimited investigationFinal reportAirborne Windsports Edge X · Ocala, FLThe noncertificated pilot's exceedance of the aircraft's critical angle of attack, which resulted in an aerodynamic stall.Feb 2, 2019 · N123NY · Substantial damageNTSB GAA19CA125Accident · No injuriesData collectionFinal reportPiper PA 12 · Cedar City, UTThe pilot's failure to maintain pitch control while conducting a touch-and-go landing on an unimproved, snow-covered airstrip, which resulted in a nose-over.Feb 1, 2019 · N2333M · Substantial damageNTSB CEN19FA078Accident · 1 fatalClass 3 · FieldFinal reportMooney M20K · Katy, TXThe noninstrument-rated pilot's decision to continue visual flight into an area of instrument meteorological conditions (IMC), which resulted in a loss of control due to spatial disorientation.Jan 31, 2019 · N56359 · DestroyedNTSB WPR19LA076Accident · Serious injuriesClass 3 · LimitedFinal reportWhittman 8-W Modified · Prospect, ORThe non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.Jan 29, 2019 · N12037 · Substantial damageNTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.Jan 29, 2019 · N680DG · Substantial damageNTSB GAA19CA120Accident · No injuriesData collectionFinal reportEmmet Smith Roadrunner · Truckee, CAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot’s improper decision to allow the airplane to exit the runway onto a snow-covered field, which resulted in a nose-over.Jan 29, 2019 · N949TS · Substantial damageNTSB GAA19CA113Accident · No injuriesData collectionFinal reportCessna 172 · Reno, NVThe student pilot's failure to maintain directional control during a rejected takeoff, which resulted in a runway excursion and impact with a ditch.Jan 29, 2019 · N670CS · Substantial damageNTSB DCA19LA070Accident · No injuriesLimited investigationFinal reportBoeing 727 200 · Tuscaloosa, ALthe captain's decision to continue the landing with an unsafe gear indication.Jan 29, 2019 · N720CK · Substantial damageNTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…Jan 29, 2019 · N191SF · DestroyedNTSB DCA19CA079Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A320 · Denver, COloss of control of the tug by the driver during pushback operations as a result of the contaminated ramp, angle of the towbar, and the airplane engines being at idle thrust.Jan 28, 2019 · N220FR · Substantial damageNTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.Jan 27, 2019 · N4087V · Substantial damageNTSB GAA19CA114Accident · No injuriesData collectionFinal reportPiper PA22 · Anchorage, AKThe student pilot's overcorrection with rudder during the landing and her subsequent failure to maintain directional control, which resulted in a runway excursion, impact with a snowbank, and a nose-over.Jan 27, 2019 · N6716B · Substantial damageNTSB CEN19TA073Accident · Serious injuriesFinal reportBeech A36 · Fort Worth, TXThe pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.Jan 27, 2019 · N36PS · Substantial damageNTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.Jan 27, 2019 · N39650 · Substantial damageNTSB GAA19CA134Accident · No injuriesData collectionFinal reportCessna R172 · Troutdale, ORThe student pilot's failure to maintain the proper pitch attitude during touchdown, which resulted in a bounced landing and subsequent propeller strike.Jan 26, 2019 · N736QV · Substantial damageNTSB GAA19CA131Accident · No injuriesData collectionFinal reportPiper PA28 · Williamsburg, VAThe pilot's excessive brake application during the landing roll, which resulted in a runway excursion and collision with a drainage culvert.Jan 26, 2019 · N6166W · Substantial damageNTSB GAA19CA109Accident · No injuriesData collectionFinal reportBeech B19 · Los Angeles, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a fence.Jan 26, 2019 · N24682 · Substantial damageNTSB ERA19LA083Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Lexington, KYThe pilot's improper slip maneuver on final approach, which resulted in a total loss of engine power.Jan 26, 2019 · N6136V · Substantial damageNTSB WPR19CA072Accident · No injuriesData collectionFinal reportCessna R172 · Ogden, UTThe student pilot's failure to maintain the runway heading during a touch-and-go landing and the flight instructor's delayed remedial action, which resulted in the airplane departing the left side of the runway, impacting snow, and nosing over.Jan 24, 2019 · N736TB · Substantial damageNTSB ANC19LA011Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Anchorage, AKA loss of engine power due to oil starvation as the result of a loose B-nut fitting on the engine oil cooler, resulting in a forced landing to a soft, snow-covered surface, and a subsequent nose over.Jan 22, 2019 · N7640D · Substantial damageNTSB CEN19LA056Accident · 2 fatalLimited investigationFinal reportDouglas DC3C · Kidron, OHThe loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.Jan 21, 2019 · N467KS · Substantial damageNTSB ANC19CA010Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA31 · Chignik Lagoon, AKThe pilot’s selection of an unsuitable runway for landing, which resulted in a loss of control and runway excursion.Jan 21, 2019 · N995AK · Substantial damageNTSB CEN19LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aguilares, TXThe loss of engine power due to fuel starvation.Jan 20, 2019 · N99308 · Substantial damageNTSB WPR19LA070Accident · No injuriesClass 3 · LimitedFinal reportHill Group CCX-2000 · Roll, AZThe loss of engine power due to a fatigue failure of the crankshaft for reasons that could not be determined based on the available information.Jan 19, 2019 · N57FX · Substantial damageNTSB WPR19CA067Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Chino, CAThe pilot's loss of directional control while landing, which resulted in a ground loop.Jan 19, 2019 · N11852 · Substantial damageNTSB GAA19CA122Accident · No injuriesData collectionFinal reportCessna 172 · Miami, FLThe student pilot's failure to control the airplane's speed and direction during the approach, which resulted in landing long, a runway excursion, and impact with a windsock.Jan 19, 2019 · N734AY · Substantial damageNTSB GAA19CA105Accident · Minor injuriesData collectionFinal reportRobert R. Reiland Rans · Reidsville, NCThe pilot's improper pitch control during a go-around, which resulted in a hard landing.Jan 18, 2019 · N3075E · Substantial damage