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 GAA19CA485Accident · No injuriesData collectionFinal reportStinson 10 · Yuba, CAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Jun 17, 2019 · N34658 · Substantial damageNTSB GAA19CA364Accident · No injuriesData collectionFinal reportCessna 170 · Hewitt Lake, AKThe pilot's failure to maintain directional control during takeoff from a soft, grass airstrip, which resulted in impact with brush.Jun 17, 2019 · N4427B · Substantial damageNTSB GAA19CA361Accident · Minor injuriesData collectionFinal reportQuicksilver Aircraft Northeast Sport · Ledgedale, PAThe pilot's selection of unsuitable terrain for takeoff, which resulted a nose-over. Contributing to the accident was the pilot's improper in-flight fuel management, which resulted in the precautionary landing on unsuitable terrain.Jun 17, 2019 · N418RB · Substantial damageNTSB ERA19LA199Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 · Readington, NJThe pilot's failure to land on the mowed turf runway, which resulted in the airplane landing in tall grass and subsequently nosing over.Jun 17, 2019 · N43766 · Substantial damageNTSB ERA19FA196Accident · 1 fatalClass 3 · FieldFinal reportTrella T-21 · Endicott, NYA partial loss of engine power for reasons that could not be determined, and the pilot's subsequent exceedance of the airplane's critical angle of attack during an attempted return to the runway, which resulted in an aerodynamic stall/spin at an altitude that…Jun 17, 2019 · N450C · Substantial damageNTSB CEN19LA174Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Key West, FLThe failure of maintenance personnel to properly secure the right-side tail boom mounting bolts which resulted in the failure of the bolts and an inflight separation of the tail rotor.Jun 17, 2019 · N1241W · Substantial damageNTSB WPR19FA173Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-11 · Copperopolis, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s impairment from consuming alcohol before the flight.Jun 16, 2019 · N209H · DestroyedNTSB GAA19CA348Accident · No injuriesData collectionFinal reportPiper PA18 · Fairbanks, AKThe pilot receiving instruction's premature pitch control input during takeoff, which resulted in an aborted takeoff and subsequent impact with terrain. Contributing to the accident was the flight instructor's delayed remedial action.Jun 16, 2019 · N2765A · Substantial damageNTSB WPR19LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182M · Upland, CAThe total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.Jun 15, 2019 · N777RK · Substantial damageNTSB GAA19CA367Accident · Minor injuriesData collectionFinal reportCessna 172 · Lebanon, KYThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion, impact with a ditch, and subsequent nose-over.Jun 15, 2019 · N75903 · Substantial damageNTSB GAA19CA347Accident · Minor injuriesData collectionFinal reportRobinson R22 · San Antonio, TXThe pilot receiving instruction's improper cyclic control input during landing, which resulted in a dynamic rollover, and the flight instructor's improper decision to practice landings in tall grass in gusting wind conditions.Jun 15, 2019 · N511HE · Substantial damageNTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.Jun 14, 2019 · N84402 · Substantial damageNTSB GAA19CA351Accident · No injuriesData collectionFinal reportVans Vans Acft RV 6 · Culpepper, VAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a ground loop.Jun 14, 2019 · N696SH · Substantial damageNTSB CEN19FA170Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Huntsville, TXA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.Jun 14, 2019 · N9754J · DestroyedNTSB WPR19LA170Accident · Serious injuriesClass 3 · LimitedFinal reportJames Experimental Cub · Stanley, IDOverstress failure of the right-wing spar due to an encounter with turbulence.Jun 13, 2019 · N9WU · Substantial damageNTSB GAA19CA340Accident · Minor injuriesData collectionFinal reportPiper PA24 · Cambridge, OHThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent loss of directional control, which resulted in impact with a creek.Jun 13, 2019 · N8300P · Substantial damageNTSB GAA19CA339Accident · No injuriesData collectionFinal reportAir Tractor AT502 · San Benito, TXThe pilot's improper decision to take off with the airplane near its maximum allowable gross takeoff weight and his subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 13, 2019 · N103CK · Substantial damageNTSB CEN19LA176Accident · No injuriesClass 3 · LimitedFinal reportKolb Kolb Twinstar TSP 1 · Hector, MNThe pilot’s operation of the airplane outside of the center of gravity limits, which resulted in an adverse aerodynamic condition and subsequent hard landing. Contributing to the accident was the pilot’s incorrect calculations of the airplane’s CG limits.Jun 13, 2019 · N217JM · Substantial damageNTSB CEN19LA173Accident · Minor injuriesClass 3 · LimitedFinal reportJust Highlander · Quinlan, TXThe pilot's decision to depart with minimal runway available and his improper soft-field takeoff procedure, which resulted in impact with trees due to a slow airspeed and settling effect during climb out.Jun 13, 2019 · N324SB · Substantial damageNTSB WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.Jun 12, 2019 · N73053 · Substantial damageNTSB ERA19FA193Accident · 2 fatalField investigationFinal reportCessna 182 · Maitland, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.Jun 12, 2019 · N3051Y · Substantial damageNTSB CEN19LA166Accident · No injuriesClass 3 · LimitedFinal reportBeech E90 · Greenville, TXThe fatigue failure of the right main landing gear upper torque knee.Jun 12, 2019 · N176TW · Substantial damageNTSB CEN19FA164Accident · 2 fatalClass 3 · FieldFinal reportQuicksilver Sport 2S · Henderson, LAThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s diminished reaction times and flying performance…Jun 12, 2019 · N7551V · Substantial damageNTSB ANC19LA027Accident · No injuriesClass 3 · LimitedFinal reportHelio H391 · Hope, AKThe pilot’s failure to maintain directional control during a precautionary landing, which resulted in a ground loop. Contributing to the accident was a partial loss of engine power for reasons that could not be determined.Jun 12, 2019 · N10CJ · Substantial damageNTSB ANC19LA024Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Nome Creek, AKThe failure of the airplane's structural tubing due to corrosion, which resulted in a tailwheel separation and a subsequent loss of control. Also causal was the mechanic's failure to perform a detailed inspection of the aft fuselage during the most recent…Jun 12, 2019 · N83391 · Substantial damageNTSB WPR19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20V · Phoenix, AZThe partial loss of engine power during cruise flight for reasons that could not be determined with the available evidence.Jun 11, 2019 · N576CM · Substantial damageNTSB GAA19CA343Accident · No injuriesData collectionFinal reportMaule MX7 · Soldatna, AKThe pilot’s attempt to land on water in an airplane that was not equipped with floats.Jun 11, 2019 · N61339 · Substantial damageNTSB CEN19LA163Accident · Serious injuriesClass 3 · LimitedFinal reportGriff Challenger · Switz City, INA total loss of engine power due to failure of a connecting rod bearing. Contributing to the engine failure was the lack of an engine overhaul within the prescribed interval.Jun 11, 2019 · N582L · Substantial damageNTSB WPR19LA166Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Romona, CAA total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.Jun 10, 2019 · N3997Y · Substantial damageNTSB WPR19FA163Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Antioch, CAA loss of control while conducting low-altitude, high-speed maneuvers.Jun 10, 2019 · N7943C · DestroyedNTSB GAA19CA345Accident · Serious injuriesData collectionFinal reportS M & T UH · Northway, AKThe pilot's failure to maintain a proper descent rate during landing, which resulted in impact with terrain.Jun 10, 2019 · N64771 · Substantial damageNTSB GAA19CA338Accident · No injuriesData collectionFinal reportPzl-Swidnik PW-5 · Independence, WIThe separation of the canopy from the glider during an off-airport landing for reasons that could not be determined.Jun 10, 2019 · N962JH · Substantial damageNTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jun 10, 2019 · N3242D · Substantial damageNTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…Jun 10, 2019 · N197GB · Substantial damageNTSB CEN19FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 425 · Butler, MOThe pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.Jun 10, 2019 · N622MM · DestroyedNTSB GAA19CA476Accident · No injuriesData collectionFinal reportRobinson R44 · Lebanon, MOThe pilot's loss of yaw control and failure to maintain a proper descent rate and his subsequent improper use of the collective instead of the antitorque pedals to correct the yaw, which resulted in a hard landing.Jun 9, 2019 · N724H · Substantial damageNTSB GAA19CA335Accident · No injuriesData collectionFinal reportCessna 421 · Moriarty, NMThe pilot's improper landing flare in gusting wind conditions, which resulted in a hard landing.Jun 9, 2019 · N421WL · Substantial damageNTSB GAA19CA333Accident · No injuriesData collectionFinal reportPiper PA22 · Riverside, CAThe pilot's failure to the maintain the runway heading during landing with a crosswind, which resulted in impact with runway lighting and a subsequent ground loop during the landing roll.Jun 9, 2019 · N6865B · Substantial damageNTSB GAA19CA325Accident · No injuriesData collectionFinal reportAviat A1 · Pingree, IDThe pilot's improper rudder application during landing on a dirt airstrip, which resulted in a loss of directional control, runway excursion, and subsequent nose-overJun 9, 2019 · N35AH · Substantial damageNTSB GAA19CA324Accident · No injuriesData collectionFinal reportDavid Shotwell Murphy · South Lake Tahoe, CAThe pilot's failure to properly tighten his seat belt, which allowed him to slide forward in his seat and resulted in his inadvertent application of excessive brake application during the landing roll and a subsequent noseover.Jun 9, 2019 · N235DS · Substantial damageNTSB GAA19CA323Accident · No injuriesData collectionFinal reportCessna 172 · Yellow Pine, IDThe pilot's improper approach, which resulted in the airplane touching down with insufficient runway remaining to stop on the runway, a runway overrun, and subsequent collision with bushes and terrain.Jun 9, 2019 · N5344R · Substantial damageNTSB GAA19CA322Accident · No injuriesData collectionFinal reportCirrus SR22 · Trenton, NJThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a runway excursion and subsequent substantial damage.Jun 9, 2019 · N616AB · Substantial damageNTSB WPR19TA162Accident · Minor injuriesClass 3Final reportBeech 35 · Medford, ORThe pilot’s mismanagement of fuel onboard, which resulted in a total loss of engine power due to fuel starvation.Jun 8, 2019 · N602BH · Substantial damageNTSB WPR19FA161Accident · 1 fatalClass 2 · FieldFinal reportLockwood Aircam · Hemet, CAThe pilot/builder's improper installation of the left wing during the build process, which resulted in the wing failing during takeoff.Jun 8, 2019 · N123GN · Substantial damageNTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 8, 2019 · N7247B · Substantial damageNTSB GAA19CA327Accident · No injuriesData collectionFinal reportCessna 185 · Gulkana, AKThe pilot's loss of airplane control just before touchdown in gusting wind conditions, which resulted in ground loop after touchdown.Jun 8, 2019 · N4057Y · Substantial damageNTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.Jun 8, 2019 · N1589D · Substantial damageNTSB GAA19CA321Accident · Minor injuriesData collectionFinal reportCessna 180 · Moses Lake, WAThe pilot's improper landing flare and his delayed decision to go-around, which resulted in impact with rocks on a shoreline.Jun 8, 2019 · N7529K · Substantial damageNTSB ERA19FA189Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Southold, NYA total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…Jun 8, 2019 · N8014T · DestroyedNTSB CEN19LA162Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Last Chance, COThe pilot's failure to maintain adequate main rotor rpm while descending with a tailwind during an aerial application maneuver, which resulted in an uncontrolled descent into terrain.Jun 8, 2019 · N4504L · Substantial damage