NTSB investigations

1,091 cases where NTSB found Experience/knowledge.

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\", '0203'))
  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 CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…Feb 28, 2019 · N428CD · Substantial damageNTSB DCA19MA086Accident · 3 fatalClass 1 · MajorFinal reportBoeing 767 · Trinity Bay, TXThe inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…Feb 23, 2019 · N1217A · DestroyedNTSB 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 CEN19LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Adrian, MIThe airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.Jan 13, 2019 · N8892E · Substantial damageNTSB ERA19FA070Accident · 3 fatalField investigationFinal reportPiper PA28 · Blairsville, GAThe pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.Dec 20, 2018 · N6143J · Substantial damageNTSB DCA19IA036Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737 · Burbank, CA(1) The flight crewmembers’ decision, due to plan continuation bias, to continue the approach despite indications of windshear and a higher-than-expected tailwind and (2) the flight crew’s misperception of the airplane’s touchdown point, which was farther…Dec 6, 2018 · N752SW · Minor damageNTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…Nov 30, 2018 · N941JM · Substantial damageNTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.Nov 13, 2018 · N5023G · Substantial damageNTSB ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.Nov 4, 2018 · N3515J · Substantial damageNTSB GAA19CA044Accident · No injuriesData collectionFinal reportStoddard Hamilton Glasair II · Laramie, WYThe pilot's failure to maintain a proper pitch attitude during landing at night, which resulted in a porpoised landing.Oct 27, 2018 · N505YR · Substantial damageNTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…Oct 13, 2018 · N593MS · DestroyedNTSB ANC19LA004Accident · Serious injuriesLimited investigationFinal reportAirborne X-Series · North Pole, AKThe student pilot's decision to fly the weight-shift-controlled airplane with no training in the airplane type, which resulted in a loss of control and impact with terrain shortly after takeoff.Oct 7, 2018 · UNREG · Substantial damageNTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.Oct 5, 2018 · N78239 · Substantial damageNTSB GAA18CA571Accident · No injuriesData collectionFinal reportEurocopter AS350 · Ruidoso, NMThe pilot's failure to maintain the proper descent rate during landing. Contributing to the accident were the pilot’s failure to conduct preflight performance calculations, which resulted in his operating the helicopter in high-density altitude conditions,…Sep 29, 2018 · N894NA · Substantial damageNTSB CEN18FA389Accident · 1 fatalClass 2 · FieldFinal reportVans RV 4 · Austin, ARThe pilot's failure to maintain airplane control while maneuvering which resulted in the airplane exceeding its critical angle of attack and an accelerated stall.Sep 26, 2018 · N534MM · Substantial damageNTSB WPR18FA260Accident · 1 fatalField investigationFinal reportRobert L Coons RotorWay RW 1 · Billings, MTThe pilot's failure to maintain clearance with a hangar while maneuvering to his hangar. Contributing to the accident was the pilot's limited experience in helicopters.Sep 12, 2018 · N166LC · Substantial damageNTSB ERA18FA244Accident · 2 fatalField investigationFinal reportCessna 335 · Lake Worth, FLThe pilot's loss of control during approach for landing following a total loss of left engine power for undetermined reasons.Sep 9, 2018 · N2707J · DestroyedNTSB GAA18CA517Accident · No injuriesData collectionFinal reportChampion 7GCBC · Ocklawaha, FLThe pilot’s failure to maintain directional control during landing.Aug 25, 2018 · N7618S · Substantial damageNTSB WPR18LA217Accident · 1 fatalLimited investigationFinal reportSmith Hornet · St. George, UTThe pilot's loss of airplane control during takeoff due to an unexpected gust of wind.Aug 11, 2018 · N218B · Substantial damageNTSB WPR18FA218Accident · 2 fatalField investigationFinal reportMooney M20K · Baker City, ORThe pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…Aug 11, 2018 · N231EC · Substantial damageNTSB DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.Aug 10, 2018 · N1410C · 2 aircraft · No damageNTSB ERA18LA202Accident · No injuriesLimited investigationFinal reportCessna 150 · Matthews, NCThe student pilot's improper decision to conduct a solo flight without an endorsement to do so and to perform an off-airport landing based on a perceived performance issue with the airplane. Contributing to the accident was the pilot's lack of training and…Jul 26, 2018 · N1193Y · Substantial damageNTSB GAA18CA438Accident · No injuriesData collectionFinal reportMooney M20E · Great Falls, MTThe flight instructor’s incorrect use of the landing gear system and his and the pilot’s failure to ensure that the landing gear was extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s unfamiliarity with the…Jul 22, 2018 · N7845V · Substantial damageNTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…Jul 19, 2018 · N9878R · DestroyedNTSB ERA18TA193Accident · Serious injuriesFinal reportQuicksilver MXL II · Arecibo, PRThe noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 14, 2018 · N594TC · Substantial damageNTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…Jul 12, 2018 · N619NT · Substantial damageNTSB ERA18LA188Accident · 1 fatalLimited investigationFinal reportNorthwing 17 · Section, ALThe noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during an aborted landing. Contributing to the accident was the pilot's lack of flight experience in the aircraft.Jul 9, 2018 · N959RR · Substantial damageNTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…Jul 8, 2018 · N312SA · Substantial damageNTSB GAA18CA410Accident · No injuriesData collectionFinal reportAyres S2R · Pantego, NCThe pilot's failure to maintain the proper approach path during landing, which resulted in landing short of the runway.Jul 1, 2018 · N3098L · Substantial damageNTSB ANC18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Chugiak, AKThe pilot's mismanagement of the engine controls due to distraction in the traffic pattern, which resulted in a hard landing short of the runway.Jul 1, 2018 · N5020D · Substantial damageNTSB CEN18LA239Accident · Serious injuriesLimited investigationFinal reportSibila MH-1 · Beach City, OHThe total loss of engine power for reasons that could not be determined based on the available evidence.Jun 25, 2018 · N32KS · Substantial damageNTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…Jun 21, 2018 · N1979P · Substantial damageNTSB GAA18CA380Accident · No injuriesData collectionFinal reportJabiru J250 · Ferndale, WAThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident were the pilot’s lack of experience and training in the accident airplane make and model.Jun 18, 2018 · N722BL · Substantial damageNTSB WPR18LA170Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Las Vegas, NVThe pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.Jun 13, 2018 · N557DC · Substantial damageNTSB ERA18FA167Accident · 2 fatalField investigationFinal reportRaytheon 58 · Springfield Township, NJA loss of control due to spatial disorientation while climbing after departure in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument experience.Jun 13, 2018 · N218BL · DestroyedNTSB ANC18FA041Accident · 1 fatalField investigationFinal reportMason Hal J Kitfox Model 1 · Salem, ORThe student pilot's improper decision to operate an airplane for which he was not endorsed to fly solo and in which he had limited experience or training, and his subsequent loss of airplane control after takeoff.Jun 4, 2018 · N375KF · Substantial damageNTSB CEN18FA204Accident · 2 fatalField investigationFinal reportCirrus SR22 · Midland, TXAn inadvertent stall, resulting in an uncontrollable descent and impact with terrain. Contributing to the accident was the high density altitude.Jun 1, 2018 · N670SR · DestroyedNTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.May 19, 2018 · N38ES · DestroyedNTSB CEN18LA173Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Hamilton, OHThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.May 15, 2018 · N6550L · Substantial damageNTSB WPR18FA141Accident · 1 fatalField investigationFinal reportCessna 182G · Cascade, IDThe non-instrument-rated pilot's improper decision to initiate a visual flight rules flight into an area with low ceilings due to mountain obscuration, which resulted in controlled flight into terrain.May 13, 2018 · N2377R · DestroyedNTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.May 11, 2018 · N9216E · Substantial damageNTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.May 5, 2018 · N701XS · Substantial damageNTSB CEN18LA156Accident · No injuriesLimited investigationFinal reportLaminar Lancair 360 · Woodward, OKThe pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…May 2, 2018 · N92WL · Substantial damageNTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.Apr 25, 2018 · N922PA · Substantial damageNTSB ERA18LA134Accident · 1 fatalLimited investigationFinal reportStanley Ernie Sigurd Kolb Mark · Collegedale, TNThe pilot's loss of airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to take off in the nonairworthy airplane in which he had no training and his lack of flight experience in the 17…Apr 20, 2018 · N9123R · DestroyedNTSB GAA18CA213Accident · Minor injuriesData collectionFinal reportHawley Richard A1B · Lincoln, CAThe pilot’s failure to maintain directional control during takeoff.Apr 13, 2018 · N5249H · Substantial damageNTSB GAA18CA212Accident · No injuriesData collectionFinal reportSasser Allen L Searey · Welaka, FLThe pilot’s incorrect pitch input during a water landing, which resulted in a nose-over. Contributing to the accident were the pilot’s inadequate training and experience in the make and model airplane.Apr 6, 2018 · N124AL · Substantial damageNTSB CEN18LA137Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Maxwell, IAThe noncertificated pilot's unfamiliarity with the airplane, which resulted in a loss of airplane control when the pilot encounter a wind gust.Apr 5, 2018 · N2433Z · Substantial damageNTSB CEN18FA266Accident · 1 fatalField investigationFinal reportCessna 210 · Alma, COThe noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.…Apr 2, 2018 · N68640 · Substantial damageNTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…Mar 26, 2018 · N7019N · Destroyed