NTSB investigations
1,558 cases where the sequence of events included Miscellaneous/other.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.NTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.NTSB GAA19CA125Accident · No injuriesData collectionFinal reportPiper PA 12 · Cedar City, UTThe pilot's failure to maintain pitch control while conducting a touch-and-go landing on an unimproved, snow-covered airstrip, which resulted in a nose-over.NTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.NTSB GAA19CA113Accident · No injuriesData collectionFinal reportCessna 172 · Reno, NVThe student pilot's failure to maintain directional control during a rejected takeoff, which resulted in a runway excursion and impact with a ditch.NTSB WPR19CA072Accident · No injuriesData collectionFinal reportCessna R172 · Ogden, UTThe student pilot's failure to maintain the runway heading during a touch-and-go landing and the flight instructor's delayed remedial action, which resulted in the airplane departing the left side of the runway, impacting snow, and nosing over.NTSB GAA19CA105Accident · Minor injuriesData collectionFinal reportRobert R. Reiland Rans · Reidsville, NCThe pilot's improper pitch control during a go-around, which resulted in a hard landing.NTSB GAA19CA129Accident · No injuriesData collectionFinal reportCessna 182 · Marshall, TXThe pilot's failure to maintain directional control during landing.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB GAA19CA103Accident · No injuriesData collectionFinal reportRobinson R44 · Strykersville, NYThe structural failure of the home-built landing platform during landing, which resulted in the helicopter rolling over.NTSB CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.NTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.NTSB ENG19RA007Incident · No injuriesForeign investigationAirbus A330 · Brussels, BelgiumThe Air Accident Investigation Unit of Belgium has notified the NTSB of a serious incident involving an Airbus A330-223 that occurred on December 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation Unit…NTSB GAA19CA091Accident · No injuriesData collectionFinal reportZlin Z143 · Chester, CTThe pilot's loss of airplane control during the engine start.NTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.NTSB ERA19LA057Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Kennesaw, GAThe total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.NTSB GAA19CA085Accident · Minor injuriesData collectionFinal reportCessna 172 · St. Petersburg, FLThe pilot's failure to remove the gust lock before flight, which resulted in the airplane’s inability to rotate and a subsequent runway overrun. Contributing to the accident was the pilot’s failure to follow the preflight checklist.NTSB GAA19CA083Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Rock Hill, SCThe pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.NTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.NTSB GAA19CA074Accident · No injuriesData collectionFinal reportCirrus SR22 · Sand Creek, WIThe mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.NTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.NTSB GAA19CA060Accident · Minor injuriesData collectionFinal reportBeech 36 · Williams, AZThe pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.NTSB ERA19LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Lake City, FLThe pilot's failure to attain adequate airspeed before attempting the takeoff with a tailwind, which resulted in the airplane being unable to sustain flight.NTSB GAA19CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Lihue, HIThe passenger’s improper decision to hold her cell phone outside the helicopter, which resulted in it departing the helicopter and striking the tail rotor.NTSB GAA19CA057Accident · No injuriesData collectionFinal reportAviat A1 · Red Creek, AZThe pilot's improper brake application during landing on a soft, dirt airstrip, which resulted in a nose-over.NTSB ERA19LA028Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Murfreesboro, TNThe pilot's failure to maintain airplane control while maneuvering at low altitude in gusting wind conditions.NTSB GAA19CA038Accident · No injuriesData collectionFinal reportDiamond DA 40 · Marana, AZThe student pilot's excessive taxi speed during a turn from the runway to a taxiway, which resulted in a runway excursion and collision with a taxiway sign.NTSB GAA19CA042Accident · No injuriesData collectionFinal reportCessna 172 · Salina, KSThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA19CA037Accident · No injuriesData collectionFinal reportZenith CH601 · Junction City, KSThe pilot's failure to secure the canopy latch before takeoff, which resulted in the canopy opening in flight and the subsequent loss of airplane control.NTSB GAA19CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Waynesburg, PAThe student pilot's improper decision to maneuver the airplane through an area of construction and his subsequent failure to maintain clearance from a concrete pole barrier while taxiing.NTSB GAA19CA028Accident · No injuriesData collectionFinal reportPiper PA28 · Hastings, MIThe student pilot's improper landing flare, which resulted in the airplane landing sideways and a subsequent runway excursion.NTSB GAA19CA024Accident · No injuriesData collectionFinal reportCessna 172 · Vergennes, VTThe pilot's failure to maintain clearance from trees while taxiing.NTSB GAA19CA013Accident · No injuriesData collectionFinal reportCessna 140 · Marina, CAThe pilot’s inadvertent application of the brakes, which resulted in a nose-over.NTSB GAA19CA030Accident · Serious injuriesData collectionFinal reportUltramagic N 250 · Rio Rancho, NMThe balloon tipping over during deflation, which resulted in a passenger injury.NTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.NTSB ANC19CA002Accident · No injuriesData collectionFinal reportBeech 1900 · Gambell, AKThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard landing.NTSB ERA18LA269Accident · No injuriesLimited investigationFinal reportRobinson R44 · Westminster, MDThe pilot's attempt to move the helicopter from a sloped surface after an overspeed event, which resulted in a loss of helicopter control and impact with a car. The overspeed event resulted from misrouted and damaged wiring in the magneto, which subsequently…NTSB GAA18CA575Accident · Serious injuriesData collectionFinal reportPiper PA28 · Spokane, WAThe pilot’s improper retraction of the flaps during a go-around, which resulted in the airplane’s failure to climb and its subsequent collision with trees.NTSB 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,…NTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.NTSB GAA18CA567Accident · No injuriesData collectionFinal reportPiper PA18 · St. Mary's, AKThe pilot’s selection of an unsuitable off-airport landing area, which resulted in a ground loop.NTSB GAA18CA548Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Carson, NVThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control in gusting, right quartering tailwind conditions.NTSB GAA18CA544Accident · No injuriesData collectionFinal reportHalladay Roy Lockheed · Denver, COThe pilot's failure to verify that the emergency canopy release was in the correct position when opening the canopy during landing, which resulted in the canopy separating from the airplane and subsequently impacting the empennage.NTSB GAA18CA546Accident · No injuriesData collectionFinal reportPiper PA28 · De Pere, WIThe pilot's improper decision not to abort the takeoff after the airplane encountered standing water on the runway, which decreased its speed and led to its subsequent inability to climb and resulted in a runway overrun.NTSB GAA18CA584Accident · No injuriesData collectionFinal reportCessna 305 · Groveland, CAThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and subsequent ground-loop.NTSB GAA18CA533Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Cut Bank, MTThe pilot’s failure to see and avoid power wires while maneuvering at low altitude. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.NTSB GAA18CA539Accident · No injuriesData collectionFinal reportSchweizer 269C · Delaware, OHThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN18LA365Accident · Serious injuriesLimited investigationFinal reportMD Helicopters MD-369 · Orchard Lake, MIThe pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.