NTSB investigations
739 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 WPR12CA387Accident · No injuriesData collectionFinal reportCroman SH-3H · Covelo, CAThe pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.NTSB ANC12CA100Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 · Talkeetna, AKThe entanglement of a plastic tarp in the helicopter’s tail rotor after becoming dislodged from its securement.NTSB WPR12FA385Accident · Serious injuriesField investigationFinal reportEaston Searey · Friday Harbor, WAThe pilot’s inadequate glidepath and failure to maintain clearance from the transmission wire during a landing approach.NTSB WPR12CA376Accident · Serious injuriesData collectionFinal reportChampion 7FC · Terrebonne, ORThe pilot's physical impairment, which adversely affected his ability to properly operate the airplane.NTSB CEN12CA631Accident · No injuriesData collectionFinal reportPowrachute Pegasus · Luling, TXCollision with a powerline resulting from the pilot's not maintaining adequate clearance while on a day VFR approach to land.NTSB ANC12CA092Accident · Minor injuriesData collectionFinal reportDehavilland Beaver U-6 · Kenai, AKThe pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.NTSB ERA12WA534Accident · 1 fatalForeign investigationGulfstream G-164B · Calabozo, VenezuelaOn August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…NTSB DCA12WA133Accident · No injuriesForeign investigationDouglas DC9 · Santo Domingo, VenezuelaThe Venezuela Dirección General para la Prevención e Investigación de Accidentes Aéreos (PIAA) has notified the NTSB of an accident involving a Douglas DC-9-82 that occurred on August 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB CEN12LA545Accident · Serious injuriesLimited investigationFinal reportDykas Kitfox Series 7 · Monroe, MIThe inadequate descent angle flown by the pilot during a final approach for landing, which resulted in an in-flight collision with a power line.NTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.NTSB DCA12CA122Accident · No injuriesData collectionFinal reportAirbus A330 · Dulles, VAthe A330 flightcrew's failure to maintain a safe clearance between his wing and the tail of the DHC-8-400 that was stopped on the lead in line of the gate.NTSB CEN12CA548Accident · No injuriesData collectionFinal reportSchleicher ASW22 · Uvalde, TXThe pilot did not fully stow the glider’s airbrakes, which prevented the glider from obtaining adequate airspeed during the takeoff roll.NTSB CEN12CA533Accident · No injuriesData collectionFinal reportThrush S-2R · Newkirk, OKThe pilot’s failure to maintain clearance from power lines.NTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.NTSB ERA12LA493Accident · No injuriesLimited investigationFinal reportSikorsky S-58JT · Middletown, DEThe pilot's failure to recognize that the helicopter was experiencing tail rotor dynamic instability and to take immediate corrective actions during an external load lift, which resulted in the failure of a tail rotor blade.NTSB CEN12LA549Accident · No injuriesLimited investigationFinal reportCessna 182D · Rose Hill, KSThe inadvertent deployment of a skydiver's parachute, which struck the right horizontal stabilizer.NTSB CEN12CA474Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Houston, TXThe pilot’s inadequate preflight inspection, which failed to detect the unsecured cowling latches and resulted in the in-flight opening of an engine cowling.NTSB ANC12CA070Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Cantwell, AKThe right seat passenger’s inadvertent contact with the emergency fuel shutoff valve, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to provide a thorough preflight briefing to the…NTSB DCA12WA105Incident · No injuriesForeign investigationAirbus A319 · Okinawa, JapanOn July 5, 2012, about 1324 Japan Standard Time (0424 UTC), an Airbus A319-112, (B2332), operated by China Eastern Airlines Co., Ltd., was instruction to hold short of the runway at the Naha Airport (OKA), Okinawa, Japan; however, the flight crew taxied onto…NTSB ERA12LA429Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Tallahassee, FLThe pilot’s failure to maintain awareness of the helicopter’s altitude while attempting to troubleshoot the clutch actuator warning light, which resulted in an inadvertent descent and impact with water. Contributing to the accident was the pilot's possible…NTSB DCA12WA102Incident · No injuriesForeign investigationBoeing 767-323 · Sao Paulo, BrazilThe Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 767 that occurred on July 3, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…NTSB WPR12CA284Accident · Minor injuriesData collectionFinal reportCessna 210-5 · West Glacier, MTThe pilot elected to abort the takeoff without sufficient runway available to land and stop the airplane. Contributing to the accident was the illusion created by the rising terrain, which influenced the pilot's decision to abort the takeoff.NTSB ERA12CA443Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe pilot's attempt to secure an open canopy during takeoff, which resulted in a loss of control and subsequent hard landing.NTSB CEN12CA416Accident · Minor injuriesData collectionFinal reportMichael A Howard Dominator · Omaha, NEA nosewheel shimmy on takeoff, which resulted in the failure of the nosewheel landing gear and a loss of control.NTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…NTSB WPR12CA270Accident · No injuriesData collectionFinal reportFisher Harold R 320 · Adelanto, CAThe pilot's failure to maintain clearance from a fence during takeoff initial climb. Contributing to the accident was the pilot's decision to not use all of the runway distance available for takeoff and the high density altitude.NTSB DCA12WA089Accident · 14 fatalForeign investigationSikorsky S58 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación of Peru (CIAA) has notified the NTSB of an accident involving a Sikorsky S58 helicopter that occurred on June 06, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ERA12LA362Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Asheville, NCThe use of an aftermarket skid shoe, which resulted in the skid shoe becoming caught on a runway centerline light during the run-on landing.NTSB WPR12LA220Accident · 1 fatalLimited investigationFinal reportGrumman G 164D · Nicolaus, CAThe pilot’s failure to maintain airplane control during a low-altitude maneuver.NTSB CEN12LA314Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKThe student pilot's improper configuration of the airplane flaps during an aborted landing, which resulted in an inadequate climb rate and subsequent collision with trees.NTSB CEN12LA335Accident · No injuriesLimited investigationFinal reportShort Bros Shorts SD3-60 · Houston, TXThe pilots’ improper decision to burn fuel during the taxi by operating the engines at a higher-than-normal power setting and using the wheel brakes to control taxi speed, which resulted in a wheel fire.NTSB CEN12CA328Accident · No injuriesData collectionFinal reportShiver Tailwind W-10 · Pipe Creek, TXAn inadvertent collision with a deer during takeoff and the airplane’s subsequent departure from the runway and impact with a tree.NTSB ERA12WA354Accident · 2 fatalForeign investigationCessna T210M · Manabi Province, EcuadorOn May 13, 2012, about 2030 local time (May 14, 2012, about 0030 coordinated universal time), a Cessna T210M, Mexican registration XB-MPL, was substantially damaged when it impacted terrain in Manabí Province, Ecuador. The pilot and passenger, both of unknown…NTSB CEN12FA290Accident · 4 fatalField investigationFinal reportCessna 401 · Chanute, KSThe malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…NTSB ERA12CA323Accident · No injuriesData collectionFinal reportBeech A36 · Paducah, KYThe pilot’s failure to properly secure the airplane before turning the propeller by hand.NTSB DCA12WA070Accident · No injuriesForeign investigationBoeing 737 · Gothenburg, SwedenThe Swedish Accident Investigation Authority (SHK) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 8, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the SHK investigation under the provisions of ICAO…NTSB ERA12LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Mountain, NCThe pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the airplane’s reduced takeoff performance.NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA12CA244Accident · No injuriesData collectionFinal reportMooney M20M · Clearwater, FLThe pilot’s failure to extend the landing gear before landing due to his distraction regarding another airplane in the traffic pattern.NTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…NTSB ERA12CA179Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · N. Charleston, SCThe flight instructor’s failure to apply power during a practice autorotation in order to arrest a high rate of descent, which resulted in an in-flight collision with terrain.NTSB DCA12WA028Accident · No injuriesForeign investigationMcdonnell Douglas MD80 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving an MD-80 that occurred on January 24, 2012. The ACAA delegated the investigation to the Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación…NTSB DCA12WA027Incident · No injuriesForeign investigationBoeing 777 · Rio de Janeiro, BrazilThe Brazilian Centro de Investigação e Prevenção deAcidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 777 that occurred on January, 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…NTSB CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.NTSB CEN12IA123Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Denver, COThe snowplow operator’s incapacitation due to fatigue, which resulted in the snowplow contacting a parked airplane. Contributing to the incident was the company’s lack of a policy regarding employee fatigue.NTSB CEN12WA105Accident · 2 fatalForeign investigationCessna 177A · Ottawa, CanadaOn December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…NTSB ERA12CA095Accident · No injuriesData collectionFinal reportBell 206L-3 · Wingate, NCThe certified flight instructor did not select an adequate landing site for the practice autorotation.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB ERA12CA082Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brooksville, FLThe pilot's incorrect identification of the runway, which resulted in an off-airport landing and subsequent collision with objects.