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 WPR17LA012Accident · Minor injuriesLimited investigationFinal reportNorthland IVP · Lovelock, NVA total loss of engine power due to the failure of the intake valve in the No. 3 cylinder for reasons that could not be determined based on the available information.Oct 20, 2016 · N4YB · Substantial damageNTSB GAA17CA041Accident · No injuriesData collectionFinal reportCessna A185 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll.Oct 20, 2016 · N7565H · Substantial damageNTSB GAA17CA039Accident · No injuriesData collectionFinal reportEvolution Revo · Carson City, NVThe pilot receiving instruction's inadvertent application of throttle during the engine start, which led to an inadvertent acceleration and a roll-over.Oct 20, 2016 · N31PH · Substantial damageNTSB GAA17CA036Accident · No injuriesData collectionFinal reportCessna 172 · Carrabassett, METhe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.Oct 20, 2016 · N1706F · Substantial damageNTSB GAA17CA032Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Carrollton, GAThe pilot's failure to verify the usable fuel in the fuel tanks, which resulted in an inaccurate fuel totalizer setting during preflight, fuel exhaustion, and a total loss of engine power.Oct 20, 2016 · N601UK · Substantial damageNTSB CEN17LA021Accident · Serious injuriesLimited investigationFinal reportZenith CH-750 · Morristown, MNA total loss of engine power due to fuel vapor lock. Contributing to the loss of engine power were the corrosion of the spark plugs and the spacing of the electrode gaps.Oct 20, 2016 · N8681 · Substantial damageNTSB WPR17LA009Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec 90 · Caldwell, IDThe pilot's failure to properly tighten the tension bolts during the installation of the alternator belt, which resulted in inadequate voltage to sustain ignition and the subsequent partial loss of engine power.Oct 19, 2016 · N716JB · Substantial damageNTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.Oct 19, 2016 · N5541F · Substantial damageNTSB GAA17CA033Accident · Minor injuriesData collectionFinal reportStinson 108 3 · Boulder City, NVThe pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.Oct 19, 2016 · N818C · Substantial damageNTSB ERA17LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLA partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…Oct 19, 2016 · N1827Y · Substantial damageNTSB GAA17CA030Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Paragould, ARThe pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.Oct 18, 2016 · N4218E · Substantial damageNTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.Oct 18, 2016 · N210LC · Substantial damageNTSB GAA17CA042Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.Oct 17, 2016 · N46953 · Substantial damageNTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.Oct 16, 2016 · N8277P · Substantial damageNTSB GAA17CA024Accident · Minor injuriesData collectionFinal reportCessna 182 · Leesburg, VAThe pilot's improper landing flare, which resulted in a hard landing and subsequent runway excursion.Oct 16, 2016 · N5446N · Substantial damageNTSB ERA17LA015Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stockbridge, GAA partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Oct 16, 2016 · N7948F · Substantial damageNTSB ERA17FA017Accident · 3 fatalField investigationFinal reportPiper PA28 · Austin, PAThe pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…Oct 16, 2016 · C-GYSN · DestroyedNTSB CEN17LA019Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Mc Alester, OKA total loss of engine power during initial climb due to fuel starvation.Oct 16, 2016 · N93668 · Substantial damageNTSB CEN17FA016Accident · 2 fatalField investigationFinal reportMakela RV-4 · Oregonia, OHThe pilot's decision to fly at a low altitude, which resulted in the collision with a zipline.Oct 16, 2016 · N2626C · DestroyedNTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…Oct 15, 2016 · N8718X · DestroyedNTSB GAA17CA047Accident · No injuriesData collectionFinal reportPiper PA 34 · Springfield, OHThe pilot’s inadequate compensation for gusting wind during the landing flare, which resulted in a hard landing.Oct 15, 2016 · N55378 · Substantial damageNTSB GAA17CA038Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Wilmington, OHThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion.Oct 15, 2016 · N1750K · Substantial damageNTSB GAA17CA031Accident · No injuriesData collectionFinal reportBellanca 17 30 · Burnet, TXThe pilot’s decision to continue the unstabilized approach and his failure to extend the landing gear before landing.Oct 15, 2016 · N8790V · Substantial damageNTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.Oct 15, 2016 · N9473D · Substantial damageNTSB GAA17CA027Accident · Minor injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe airplane's encounter with a depression while the pilot applied excessive braking during the landing roll on a grass airstrip, which resulted in a nose-over.Oct 14, 2016 · N2791P · Substantial damageNTSB GAA17CA026Accident · Serious injuriesData collectionFinal reportPiper PA 28 · Latrobe, PAThe pilot’s unstabilized approach, which resulted in the airplane’s wing striking the ground while the pilot was maneuvering to realign with the runway.Oct 14, 2016 · N9097U · Substantial damageNTSB WPR17IA007Incident · No injuriesIncident investigationFinal reportShort Bros SD3 60 Sherpa · Missoula, MTThe failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…Oct 13, 2016 · N148Z · Minor damageNTSB ERA17LA014Accident · No injuriesLimited investigationFinal reportCessna 525 · Pawtucket, RIThe flight crew's failure to maintain an appropriate approach speed and obtain an appropriate touchdown point on the runway, which resulted in a runway overrun.Oct 13, 2016 · N518AR · Substantial damageNTSB WPR17LA004Accident · Serious injuriesClass 3 · LimitedFinal reportRockwell International 112A · Phoenix, AZA catastrophic engine failure due to lack of lubrication due to the absence of 2 piston cooling nozzles that backed out of their respective threaded bores, which resulted in a forced landing on unsuitable terrain.Oct 12, 2016 · N509CA · Substantial damageNTSB GAA17CA028Accident · Minor injuriesData collectionFinal reportNewkirk Thomas Ray Vans RV 6 · Garland, NCThe pilot's improper landing flare, which resulted in a bounced landing on the grass runway.Oct 12, 2016 · N164N · Substantial damageNTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.Oct 12, 2016 · N39083 · Substantial damageNTSB ERA17CA013Accident · Serious injuriesData collectionFinal reportMickler Larry J RV6 A · Bell, FLThe pilot's inadequate compensation for gusting crosswinds, which resulted in a bounced landing and nose-over.Oct 11, 2016 · N686RM · Substantial damageNTSB ERA17CA012Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Knoxville, TNThe pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires.Oct 11, 2016 · N2504Z · Substantial damageNTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.Oct 10, 2016 · N399DC · Substantial damageNTSB ERA17LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Toone, TNA stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation.Oct 9, 2016 · N65903 · Substantial damageNTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.Oct 8, 2016 · N3943F · Substantial damageNTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.Oct 8, 2016 · N3379E · Substantial damageNTSB CEN17LA014Accident · No injuriesLimited investigationFinal reportCessna 150M · Beasley, TXThe No. 2 cylinder exhaust valve being stuck in the “full open” position due to carbon deposits, which resulted in a total loss of engine power.Oct 8, 2016 · N704LE · Substantial damageNTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.Oct 7, 2016 · N507SR · Substantial damageNTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.Oct 7, 2016 · N4924E · Substantial damageNTSB CEN17LA015Accident · No injuriesLimited investigationFinal reportMilholland Kelly D · Livingston, TXA total loss of engine power for reasons that could not be determined based on the available information.Oct 7, 2016 · N522LM · Substantial damageNTSB GAA17CA019Accident · No injuriesData collectionFinal reportPiper PA18 · Hanna, WYThe pilot's failure to maintain directional control during the landing roll in shifting wind conditions.Oct 6, 2016 · N4457Z · Substantial damageNTSB GAA17CA017Accident · No injuriesData collectionFinal reportPiper PA 17 · Keene Valley, NYThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane and an impact with trees.Oct 6, 2016 · N4584H · Substantial damageNTSB GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Oct 6, 2016 · N4210C · Substantial damageNTSB GAA17CA014Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.Oct 6, 2016 · N602ND · Substantial damageNTSB ERA17LA006Accident · No injuriesLimited investigationFinal reportPiper PA24 · Hollywood, ALA failure of the fuel tank selector valve in a partially closed position, which resulted in fuel starvation to the engine and a total loss of engine power.Oct 6, 2016 · N8560P · Substantial damageNTSB CEN17FA012Accident · 2 fatalField investigationFinal reportFairchild Hiller FH 1100 · Lino Lakes, MNThe separation of the main rotor assembly due to mast bumping.Oct 6, 2016 · N4035G · DestroyedNTSB WPR17LA002Accident · Minor injuriesLimited investigationFinal reportTamarack Helicopters UH-1H · Gila Bend, AZThe separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.Oct 5, 2016 · N175SF · Substantial damageNTSB GAA17CA025Accident · No injuriesData collectionFinal reportCessna 172 · Kapolei, HIThe pilot’s use of an excessive pitch attitude during the landing flare, which resulted in a bounced landing.Oct 5, 2016 · N429ES · Substantial damageNTSB GAA17CA023Accident · No injuriesData collectionFinal reportNorth American Navion · Palmer, AKThe pilot's failure to extend the landing gear for landing.Oct 5, 2016 · N8895H · Substantial damage