NTSB investigations

19,008 cases where NTSB found Personnel issues.

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\", '02'))
  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 CEN14FA051Accident · 2 fatalField investigationFinal reportCessna T310R · Junction, TXThe noninstrument-rated private pilot's decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in the loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a weather…Nov 12, 2013 · N38LH · DestroyedNTSB ANC14CA005Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.Nov 12, 2013 · N709SB · Substantial damageNTSB WPR14CA048Accident · No injuriesData collectionFinal reportMaule MX 7-235 · San Ynez, CAThe pilot's failure to maintain terrain clearance while maneuvering at low altitude in hilly terrain.Nov 11, 2013 · N88CR · Substantial damageNTSB ERA14LA042Accident · No injuriesLimited investigationFinal reportPiper PA28 · Homestead, FLA total loss of engine power due to the in-flight separation of the No. 3 cylinder because of the fatigue cracking of its respective mounting studs and through bolts, which resulted from inadequate maintenance by unknown personnel.Nov 11, 2013 · N1830T · Substantial damageNTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.Nov 11, 2013 · N9236L · Substantial damageNTSB CEN14FA047Accident · 3 fatalField investigationFinal reportBeechcraft B36TC · Amarillo, TXThe noninstrument-rated pilot’s improper decision to fly a night instrument approach in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane during an attempted missed approach.Nov 11, 2013 · N4245D · DestroyedNTSB CEN14FA046Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-25 · Owasso, OKThe pilot's loss of airplane control during a known one-engine-inoperative condition. The reasons for the loss of control and engine shutdown could not be determined because the airplane was not equipped with a crash-resistant recorder and postaccident…Nov 10, 2013 · N856JT · DestroyedNTSB CEN14CA059Accident · No injuriesData collectionFinal reportGroen Sparrowhawk II · Lubbock, TXThe pilot's failure to attain a proper glidepath for landing which resulted in a hard landing.Nov 10, 2013 · N130SW · Substantial damageNTSB WPR14LA049Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Firefly 10 · Temecula, CAThe pilot's failure to follow the Landing checklist and his inadvertent contact with the blast valve after landing, which released propane that was then ignited by an undetermined source.Nov 9, 2013 · N1623L · No damageNTSB WPR14CA047Accident · Minor injuriesData collectionFinal reportAviat A 1B · LaGrange, WYThe pilot's decision to land on a rough surface with hidden obstructions (holes).Nov 9, 2013 · N510MA · Substantial damageNTSB CEN14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 28-150 · Concordia, KSThe flight instructor’s improper decision to attempt a climb with an excessive pitch attitude for the tailwind condition and flap setting, which resulted in an approach to stall and subsequent off-field landing.Nov 9, 2013 · N5790W · Substantial damageNTSB CEN14LA048Accident · Minor injuriesLimited investigationFinal reportEurocopter Deutschland EC135P1 · Shreveport, LAThe mechanic's improper installation of the antitorque pedals, which resulted in an in-flight loss of helicopter control.Nov 9, 2013 · N911KB · Substantial damageNTSB CEN14CA049Accident · No injuriesData collectionFinal reportMooney M20R · Fort Collins, COThe pilot did not maintain control of the airplane during the go around.Nov 7, 2013 · N1006A · Substantial damageNTSB WPR14FA044Accident · 3 fatalField investigationFinal reportCessna U206F · Donnelly, IDThe pilot's failure to maintain clearance from terrain while maneuvering in likely low-ceiling and low-visibility conditions in mountainous terrain.Nov 6, 2013 · N206KL · DestroyedNTSB CEN14FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kirksville, MOA loss of control due to spatial disorientation. Contributing to the accident were the private pilot's impairment due to a sedating antihistamine and both pilots' fatigue.Nov 6, 2013 · N408DM · DestroyedNTSB ERA14CA040Accident · No injuriesData collectionFinal reportBeech E 55 · Blountville, TNThe pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.Nov 5, 2013 · N1908L · Substantial damageNTSB ERA14CA039Accident · No injuriesData collectionFinal reportTaylorcraft BC 65 · Fallston, MDThe pilot's failure to maintain directional control during landing resulting in collision with equipment off the side of the runway. Contributing to the accident was the pilot's intentional landing on a closed runway with a tailwind.Nov 4, 2013 · N52CW · Substantial damageNTSB WPR14LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Johns, AZA total loss of engine power while on final approach due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning.Nov 3, 2013 · N3148C · Substantial damageNTSB WPR14CA043Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA 5B · Avalon, CAThe pilot's failure to maintain aircraft control while landing with a tailwind.Nov 3, 2013 · N1550R · Substantial damageNTSB CEN14CA037Accident · No injuriesData collectionFinal reportRaytheon A36 · Hayden, COThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control and runway excursion.Nov 3, 2013 · N981PA · Substantial damageNTSB WPR14CA041Accident · No injuriesData collectionFinal reportBell 206B · Superior, MTThe pilot's failure to maintain aircraft control while maneuvering during a long-line operation.Nov 2, 2013 · N888DR · Substantial damageNTSB CEN14LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Superior, WIThe failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.Nov 2, 2013 · N70520 · 2 aircraft · DestroyedNTSB WPR14CA039Accident · No injuriesData collectionFinal reportYuneec Yuneec · Upland, CAThe pilot's improper flare, which resulted in a loss of aircraft control and hard landing.Nov 1, 2013 · N400XW · Substantial damageNTSB CEN14FA035Accident · 2 fatalField investigationFinal reportBeech C90 · Springdale, ARA total loss of power to both engines due to fuel exhaustion. Also causal were the pilot’s reliance on the fuel totalizer rather than the fuel quantity gauges to determine the fuel on board and his improper fuel planning.Nov 1, 2013 · N269JG · DestroyedNTSB CEN14CA040Accident · No injuriesData collectionFinal reportCessna 182Q · Braggadocio, MOThe pilot's failure to maintain directional control during landing rollout, which resulted in a runway excursion and the airplane nosing over.Nov 1, 2013 · N94371 · Substantial damageNTSB CEN14LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 - B · Lubbock, TXThe pilot's failure to complete a landing checklist and extend the landing gear, which resulted in a gear-up landing. Contributing to the accident was the pilot's diverted attention to the weather during approach.Oct 31, 2013 · N917GT · Substantial damageNTSB WPR14LA038Accident · Minor injuriesLimited investigationFinal reportEurocopter France AS 350 · Kailua Kona, HIThe pilot receiving instruction’s failure to maintain main rotor rpm while practicing manual throttle control and the flight instructor’s delayed remedial action, which resulted in a hard landing.Oct 30, 2013 · N985EW · Substantial damageNTSB ERA14FA027Accident · 1 fatalField investigationFinal reportCessna 172R · Nashville, TNThe noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…Oct 29, 2013 · C-GRJH · DestroyedNTSB ERA14CA033Accident · No injuriesData collectionFinal reportStinson SR 5A · Manassas, VAThe pilot's inadvertent application of only one brake during landing roll, resulting in a ground loop and runway excursion.Oct 29, 2013 · N14163 · Substantial damageNTSB CEN14FA032Accident · Serious injuriesField investigationFinal reportGlasair Aviation USA Sportsman GS-2 · Castle Rock, COThe pilot’s improper decision to continue flight into known icing conditions, which adversely affected the airplane’s performance and resulted in a loss of airplane control.Oct 29, 2013 · N535SP · Substantial damageNTSB WPR14FA037Accident · 1 fatalField investigationFinal reportMusick Lancair 235 · McMinnville, ORThe pilot's failure to maintain airplane control while intentionally performing maneuvers in an effort to troubleshoot a landing gear malfunction.Oct 28, 2013 · N25DM · Substantial damageNTSB WPR14CA052Accident · Serious injuriesData collectionFinal reportBell 206B · Milo, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.Oct 28, 2013 · N16673 · Substantial damageNTSB CEN14LA028Accident · 1 fatalLimited investigationFinal reportPiper PA 22-150 · Princeton, MNThe pilot's loss of airplane control during takeoff.Oct 28, 2013 · N4803A · DestroyedNTSB ERA14LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-201T · Everglades City, FLThe pilot’s failure to maintain airplane control and airspeed during a go-around, which resulted in a stall and impact with terrain. Contributing to the accident were the pilot’s inadvertent use of an outdated GPS navigation database, which provided an…Oct 27, 2013 · N2702M · Substantial damageNTSB ERA14CA023Accident · No injuriesData collectionFinal reportCessna 182Q · Wauchula, FLThe pilot's improper landing flare which resulted in a hard landing.Oct 27, 2013 · N725AS · Substantial damageNTSB CEN14FA024Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Boerne, TXA defective exhaust system that allowed carbon monoxide to enter the cabin and impair the pilot, rendering him unable to control the airplane.Oct 27, 2013 · N11RC · DestroyedNTSB WPR14CA035Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Twin Falls, IDThe pilot's loss of aircraft control during the rejected takeoff.Oct 26, 2013 · N83417 · Substantial damageNTSB ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…Oct 26, 2013 · N684RA · Substantial damageNTSB ERA14CA025Accident · No injuriesData collectionFinal reportMooney M20TN · Tylertown, MSThe pilot's misjudgment of speed and distance on final approach resulting in touchdown prior to the runway, a runway excursion down the right side of the runway, and a collision with an embankment.Oct 26, 2013 · N812PT · Substantial damageNTSB ERA14CA028Accident · No injuriesData collectionFinal reportBeech 95 B55 (T42A) · Newnan, GAThe flight instructor's inadvertent movement of the landing gear switch, which resulted in a landing gear collapse and substantial damage to the fuselage.Oct 25, 2013 · N711H · Substantial damageNTSB CEN14CA027Accident · Serious injuriesData collectionFinal reportCessna 172M · Raymondville, TXThe operation of an airplane by a non-certificated pilot. Contributing to the accident was his failure to maintain airspeed following a total loss of engine power at low altitude, which resulted in an aerodynamic stall. Also contributing was the pilot's…Oct 25, 2013 · N20587 · Substantial damageNTSB WPR14LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · Big Creek, CAThe loss of engine power due to the improper installation of an oil pressure sending unit by the pilot, who was not a certificated mechanic, which resulted in a forced landing in mountainous terrain.Oct 24, 2013 · N30865 · Substantial damageNTSB CEN14CA025Accident · No injuriesData collectionFinal reportAviat A 1B · El Paso, TXThe pilot did not maintain directional control of the airplane while landing with a crosswind.Oct 24, 2013 · N68PM · Substantial damageNTSB WPR14LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Tucson, AZThe pilot’s failure to maintain airplane control during takeoff following the loss of left engine power due to the failure of the left engine-driven fuel pump’s diaphragm. Contributing to the accident was the pilot’s failure to use the electric fuel boost…Oct 23, 2013 · N3162P · Substantial damageNTSB WPR14CA026Accident · No injuriesData collectionFinal reportCessna T210 - H · Lodi, CAThe student pilot's inadequate flare and failure to maintain directional control during landing.Oct 23, 2013 · N6942R · Substantial damageNTSB ERA14CA017Accident · Serious injuriesData collectionFinal reportBeech A36 · Burnsville, NCThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway excursion.Oct 23, 2013 · N7257W · Substantial damageNTSB DCA14FA002Accident · No injuriesField investigationFinal reportBeech 1900C · Homer, AKThe first officer inadvertently selecting the landing gear handle up after touchdown during the landing rollout. Contributing to the accident was the first officer's decision to reconfigure the airplane while still on the active runway.Oct 23, 2013 · N575U · Substantial damageNTSB CEN14LA022Accident · No injuriesLimited investigationFinal reportBell OH-58C · Omaha, TXThe pilot’s failure to assess and compensate for the landing surface, which included high grass and loose dirt.Oct 23, 2013 · N911CC · Substantial damageNTSB CEN14LA015Accident · 2 fatalLimited investigationFinal reportNorth American P 51D · Galveston, TXThe pilot's loss of situational awareness while instructing the passenger, which resulted in the controlled flight of the airplane into the water.Oct 23, 2013 · N4151D · Substantial damageNTSB WPR14FA024Accident · No injuriesField investigationFinal reportCessna 208 · Wailea, HIImproper maintenance that resulted in contamination of the engine's compressor turbine disc and blade assembly by glass bead remnants, which resulted in a blade failure.Oct 22, 2013 · N861MA · Substantial damage