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 CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Aug 20, 2019 · N3631Z · DestroyedNTSB WPR19LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Spokane, WAA loss of directional control during landing for undetermined reasons.Aug 19, 2019 · N43793 · Substantial damageNTSB GAA19CA501Accident · No injuriesData collectionFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's overapplication of brakes during landing on unimproved terrain, which resulted in a nose-over.Aug 19, 2019 · N87010 · Substantial damageNTSB GAA19CA499Accident · Minor injuriesData collectionFinal reportVans RV7 · Ocracoke, NCThe pilot's failure to maintain lateral control during an attempted aborted landing, which resulted in impact with trees.Aug 19, 2019 · N566WV · Substantial damageNTSB CEN19FA276Accident · 1 fatalClass 2 · FieldFinal reportShirley Carl Sportcopter Vortex · Viroqua, WIThe noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…Aug 19, 2019 · N634SC · DestroyedNTSB ERA19FA250Accident · 2 fatalClass 3 · FieldFinal reportBeech 95B55 · Wilmington, DEThe pilots’ failure to place the left fuel selector into the proper position, which resulted in a total loss of the left engine’s power due to fuel starvation. Contributing was their failure to properly secure the left engine and their failure to maintain…Aug 18, 2019 · N678DM · Substantial damageNTSB ANC19LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Lahaina, HIThe pilots’ failure to maintain a proper approach speed and their decision to continue the approach for landing, which resulted in the airplane landing long and a subsequent runway overrun.Aug 18, 2019 · N879MA · Substantial damageNTSB WPR19LA223Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Ruidoso, NMThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance as a result of high-density altitude conditions at the time of takeoff. Contributing to the accident were the pilot’s inadequate…Aug 17, 2019 · N5410D · Substantial damageNTSB ERA19TA254Accident · Minor injuriesClass 3Final reportGIger Frank R Nieuport II · Talladega, ALA total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees.Aug 17, 2019 · N112GV · Substantial damageNTSB GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.Aug 16, 2019 · N500KA · Substantial damageNTSB GAA19CA495Accident · Minor injuriesData collectionFinal reportFlight Design CT2K · Hooper, WAThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over.Aug 16, 2019 · N433CT · Substantial damageNTSB WPR19LA222Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 601XLB · Jamul, CALoss of engine power due to an undetermined loss of electrical power to the engine control system. Contributing factors were the lack of a redundant system to provide for engine control should the engine control system be deprived of electrical power or fail.Aug 15, 2019 · N662WB · Substantial damageNTSB WPR19LA221Accident · Minor injuriesClass 3 · LimitedFinal reportAutoGyro Cavalon · Shelton, WAThe pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground.Aug 15, 2019 · N477AG · Substantial damageNTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…Aug 15, 2019 · N525SG · DestroyedNTSB GAA19CA497Accident · No injuriesData collectionFinal reportPiper PA 12 · McCarthy, AKThe pilot's overapplication of brakes during landing, which resulted in a nose-over.Aug 15, 2019 · N2534M · Substantial damageNTSB ERA19FA248Accident · Minor injuriesField investigationFinal reportTextron 680A · Elizabethton, TNThe pilot's continuation of an unstabilized approach despite recognizing associated cues and the flight crew's decision not to initiate a go-around before touchdown, which resulted in a bounced landing, a loss of airplane control, a landing gear collapse, and…Aug 15, 2019 · N8JR · DestroyedNTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.Aug 15, 2019 · N150CR · Substantial damageNTSB CEN19LA267Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC6 · San Marcos, TXThe pilot's delayed go-around attempt and the flight instructor's delayed remedial action that resulted in a nose-down impact with terrain during an attempted go-around.Aug 15, 2019 · N322AV · Substantial damageNTSB WPR19LA218Accident · No injuriesClass 3 · LimitedFinal reportExtra EA300 · Mesa, AZThe flight instructor’s operation of the airplane outside of the manufacturer’s limitations, which resulted in fuel starvation and a partial loss of engine power. Contributing to the accident was an inoperative electric fuel boost pump.Aug 14, 2019 · N19AM · Substantial damageNTSB GAA19CA494Accident · No injuriesData collectionFinal reportRockwell 690 · Stockton, CAThe pilot's delay in extending the landing gear and his improper movement of the landing gear lever, which led to a gear-up landing.Aug 14, 2019 · N52PY · Substantial damageNTSB ERA19LA246Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jay, FLThe pilot's improper decision to fly over a river at a very low altitude, which resulted in a collision with power lines.Aug 13, 2019 · N84287 · Substantial damageNTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.Aug 12, 2019 · N5600U · Substantial damageNTSB ANC19TA044Accident · Minor injuriesClass 3Final reportCessna 180 · Anchorage, AKThe pilot’s failure to maintain takeoff heading due to sun glare, which resulted in his inability to see an island adjacent to the water lane and subequent impact with the island.Aug 12, 2019 · N91402 · Substantial damageNTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.Aug 11, 2019 · N350CL · Substantial damageNTSB ERA19LA245Accident · Serious injuriesClass 3 · LimitedFinal reportSchweizer 269C · Allentown, PAInadequate maintenance of the helicopter’s magnetos, which resulted in a partial loss of engine power during the initial climb due to a failure of the left magneto and malfunction of the right magneto.Aug 11, 2019 · N1831A · Substantial damageNTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.Aug 11, 2019 · N43032 · Substantial damageNTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.Aug 11, 2019 · N8928B · Substantial damageNTSB WPR19LA217Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · Prospect, ORThe failure of the counterweight retainer pin plate which resulted in a total loss of engine power.Aug 10, 2019 · N5152U · Substantial damageNTSB GAA19CA493Accident · No injuriesData collectionFinal reportNorth American AT 6D · Chino, CAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Aug 10, 2019 · N6432D · Substantial damageNTSB GAA19CA491Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Franklin, PAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and the left main landing gear collapsing.Aug 10, 2019 · N62644 · Substantial damageNTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.Aug 9, 2019 · N2027S · Minor damageNTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.Aug 9, 2019 · N9862C · Substantial damageNTSB GAA19CA558Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe pilot's improper landing flare, which resulted in a hard, porpoised landing.Aug 9, 2019 · N9837L · Substantial damageNTSB CEN19LA264Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Cordell, OKThe pilot's improper landing flare, which resulted in a hard bounced landing.Aug 9, 2019 · N8374J · Substantial damageNTSB WPR19LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Phoenix, AZThe failure of the landing gear due to the nose gear being positioned to the far right during retraction, which caused the nose gear to jam upon retraction.Aug 8, 2019 · N10KC · Substantial damageNTSB GAA19CA488Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper decision to turn off the runway while the airplane was moving too fast after landing, which resulted in a runway excursion and impact with a taxiway sign.Aug 8, 2019 · N65401 · Substantial damageNTSB ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.Aug 8, 2019 · N4082S · DestroyedNTSB CEN19LA260Accident · Minor injuriesClass 3 · LimitedFinal reportMoth DH60GM · Cortez, COA partial loss of engine power due to carburetor ice accumulation, which resulted in a loss of altitude and impact with trees.Aug 8, 2019 · N919DH · Substantial damageNTSB CEN19LA258Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172 · North Garden, VAA total loss of engine power due to the failure of the oil pump drive gear.Aug 8, 2019 · N1609V · Substantial damageNTSB WPR19FA212Accident · 2 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Camarillo, CAThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic stall at an altitude that precluded recovery.Aug 7, 2019 · N43FD · Substantial damageNTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.Aug 7, 2019 · N979DA · Substantial damageNTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.Aug 7, 2019 · N213DT · DestroyedNTSB WPR19FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Wolf Point, MTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.Aug 5, 2019 · N3469R · DestroyedNTSB CEN19LA252Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Miami, FLThe flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing.Aug 5, 2019 · N5915U · Substantial damageNTSB GAA19CA504Accident · No injuriesData collectionFinal reportCessna 182 · Oakland, CAThe pilot's premature full retraction of the flaps during a go-around and his subsequent improper decision to turn with a minimal climb gradient, which resulted in an off-airport landing and a landing gear collapse.Aug 4, 2019 · N58628 · Substantial damageNTSB GAA19CA503Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe student pilot's improper landing flare with a tailwind, which resulted in a hard, bounced landing.Aug 4, 2019 · N197ME · Substantial damageNTSB GAA19CA486Accident · No injuriesData collectionFinal reportCessna 172 · Bayse, VAThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall.Aug 4, 2019 · N424BC · Substantial damageNTSB GAA19CA483Accident · Serious injuriesData collectionFinal reportSchleicher ASW 24 · Paulden, AZThe pilot's distraction due to the environment, his failure to lower the landing gear, and his subsequent failure to maintain directional control while landing the glider, which resulted in impact with a utility box.Aug 4, 2019 · N37T · Substantial damageNTSB CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.Aug 4, 2019 · N310QA · Substantial damageNTSB CEN19LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Jacksonville, FLThe pilot's failure to select a fuel tank with adequate fuel, which resulted in fuel starvation and a total loss of engine power.Aug 3, 2019 · N951TS · Substantial damage