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 GAA17CA438Accident · No injuriesData collectionFinal reportPiper PA28 · New Market, VAThe airplane’s collision with a deer during the landing roll.NTSB CEN17LA284Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Reyno, ARThe pilot’s inadvertent use of the propeller control, which caused the propeller to feather while in flight with the engine still operating, resulting in a loss of thrust and a subsequent forced landing.NTSB CEN17LA274Accident · No injuriesLimited investigationFinal reportEndler Glasair/Glasair 1-Td SH2 · Colorado Springs, COThe pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…NTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…NTSB GAA17CA390Accident · Minor injuriesData collectionFinal reportBell 407 · Topeka, KSThe pilot’s failure to maintain clearance from a building during landing.NTSB GAA17CA386Accident · Minor injuriesData collectionFinal reportAlexander Schleicher ASH 31 MI · Ely, NVThe pilot’s failure to maintain the proper airspeed and his exceedance of the glider’s critical angle of attack, which resulted in a stall/spin.NTSB CEN17LA257Accident · No injuriesLimited investigationFinal reportCessna 182T · Jackson, MIThe pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.NTSB ERA17LA229Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · Dillwyn, VAThe pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.NTSB CEN17FA252Accident · Minor injuriesField investigationFinal reportAirbus Helicopters Deutschland MBB-BK 117 B-2 · Perryville, MOFuel starvation due to the pilot’s failure to turn on the fuel transfer pump switches during takeoff, which led to a total loss of engine power. Contributing to the accident was the pilot's improper decision to activate the annunciator panel’s dimming…NTSB WPR17LA133Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVA loss of engine power due to the failure of the manufacturer to reinstall the oil filter after it was removed for inspection, which led to coke pollution that obstructed the oil jet and resulted in the subsequent oil starvation of the axial compressor rear…NTSB GAA17CA369Accident · No injuriesData collectionFinal reportBell 206B · Entiat, WAThe pilot’s failure to secure a loose item inside the cockpit that interfered with antitorque pedal control and led to a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB GAA17CA355Accident · No injuriesData collectionFinal reportBell UH1B · Williams, CAThe pilot’s failure to maintain clearance from transmission wires while maneuvering at a low altitude during an agricultural application flight.NTSB CEN17LA234Accident · 1 fatalLimited investigationFinal reportAeronca 65 CA · Mount Vernon, OHThe pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.NTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.NTSB GAA17CA340Accident · Minor injuriesData collectionFinal reportSportine Aviacija LAK 12 · Reno, NVThe glider pilot’s failure to maintain proper pitch during an aerotow takeoff.NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB ERA17LA201Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Gordonville, FLThe pilot's failure to properly configure the mixture control for landing due to disorientation because he had the airport diagram upside down, which resulted in a total loss of engine power.NTSB CEN17LA223Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7 77B · Chatsworth, ILThe balloon’s encounter with unexpected wind gusts during inflation, which resulted in the balloon becoming prematurely airborne and subsequently the pilot being ejected from the basket and one passenger receiving serious injuries while attempting to egress…NTSB GAA17CA381Accident · No injuriesData collectionFinal reportAeronca 7AC · Soldotna, AKThe pilot’s abrupt maneuver to avoid a moose cow and calf during taxi, which resulted in an impact with a tree.NTSB GAA17CA326Accident · No injuriesData collectionFinal reportCessna 150 · Newburyport, MAThe student pilot's decision to attempt to close the cockpit window during takeoff and his subsequent failure to maintain directional control.NTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.NTSB DCA17WA138Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB CEN17LA198Accident · No injuriesLimited investigationFinal reportMooney M20J · Lakeway, TXThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway excursion. Contributing to the accident was the pilot’s impaired vision due to his broken eyeglasses.NTSB ERA17LA194Accident · No injuriesLimited investigationFinal reportAvions Mudry Cie CAP 231 · Lebanon, PAThe partial separation of one counterweight and the subsequent seizure of the engine due to mechanical interference. Contributing to the partial separation of the counterweight was the overstress fracture of a retaining ring and the fatigue fracture of the…NTSB GAA17CA344Accident · No injuriesData collectionFinal reportEurocopter EC130 · Peach Springs, AZThe ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.NTSB ERA17LA182Accident · Minor injuriesLimited investigationFinal reportStinson 108 · West Creek, NJA total loss of engine power due to the No. 4 cylinder’s exhaust valve getting stuck and the subsequent fracturing of the valve face stem.NTSB WPR17LA104Accident · Minor injuriesClass 3 · LimitedFinal reportEvolution Air Lancair Evolution · Firebaugh, CAA failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB CEN17LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Beech Grove, ARA tire failure for reasons that could not be determined, which resulted in a loss of directional control during takeoff.NTSB GAA17CA265Accident · No injuriesData collectionFinal reportRotorcraft Development OH-58A+ · Waterloo, ILThe pilot’s failure to see and avoid transmission wires while maneuvering at a low altitude.NTSB ERA17FA172Accident · 1 fatalField investigationFinal reportPiper PA31 · Colton, NYThe pilot's incapacitation for unknown reasons, which resulted in an overflight of his destination, a subsequent loss of engine power due to fuel starvation, and collision with terrain.NTSB CEN17FA164Accident · 2 fatalField investigationFinal reportBellanca 17 31ATC · Boonville, MOThe pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.NTSB GAA17CA262Accident · No injuriesData collectionFinal reportBalony Kubicek Spol Sro BB70Z · Park City, UTThe pilot’s failure to see and avoid power lines during landing.NTSB ERA17LA163Accident · No injuriesLimited investigationFinal reportRobinson R44 · Orlando, FLA partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight…NTSB GAA17CA236Accident · Minor injuriesData collectionFinal reportZeiler Bakeng Duce 1976 CZ · Oliver Springs, TNThe pilot’s unstabilized approach and failure to go around, which resulted in impact with trees.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB GAA17CA204Accident · Minor injuriesData collectionFinal reportCessna 170 · Death Valley, CAThe pilot’s improper compensation for crosswind conditions during the landing flare and his subsequent failure to maintain directional control during the landing.NTSB CEN17IA155Incident · No injuriesIncident investigationFinal reportCessna 172RG · Greeley, COFailure of the left main landing gear actuator assembly, which resulted in an inability to extend the left main landing gear.NTSB GAA17CA197Accident · No injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.NTSB GAA17CA185Accident · No injuriesData collectionFinal reportPipistrel Doo Ajdovscina Virus · Okmulgee, OKThe pilot’s failure to review the Federal Aviation Administration chart supplement before landing, which resulted in his landing on a closed runway and collision with a fence. Contributing to the accident was the airport’s failure to adequately mark the…NTSB GAA17CA184Accident · No injuriesData collectionFinal reportCSP Leasing Cavalon · Santa Maria, CAThe student pilot’s improper landing flare and subsequent failure to maintain crosswind correction during landing in crosswind conditions.NTSB DCA17WA121Incident · No injuriesForeign investigationBoeing 737 · Sint Maarten, NTThe government of Netherlands Antilles has notified the NTSB of an accident involving a BOEING 737 that occurred on March 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands Antilles's investigation under…NTSB ERA17LA122Accident · No injuriesLimited investigationFinal reportXtremeair XA42 · West Palm Beach, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical failures or malfunctions that would have precluded normal operation.NTSB GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.NTSB ERA17LA130Accident · No injuriesLimited investigationFinal reportSocata TB20 · Melbourne, FLImproper installation of the circlip within the nose gear strut, which resulted in the strut overextending in the wheel well and preventing the nose landing gear from extending during landing.NTSB GAA17CA162Accident · No injuriesData collectionFinal reportCessna T337 · Linden, NJThe pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.NTSB WPR17LA064Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Stevensville, MTThe pilot's decision to conduct a takeoff with a tailwind on an upsloping runway in an overweight airplane, which resulted in the airplane having insufficient energy to climb out of ground effect.NTSB ERA17LA126Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 · San Juan, PRThe flight instructor's incorrect manipulations of the twist grip throttle control during a practice autorotation, which resulted in an engine overspeed and subsequent fire.NTSB ERA17LA109Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Dawsonville, GAA decrease in oil pressure due to the pilot's unintentional overfilling of the engine oil sump, and the pilot's subsequent decision to perform an off-airport precautionary landing, which resulted in impact with a tree.