NTSB investigations
78 cases where NTSB found Miscellaneous.
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\", '0205')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0205')) 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 WPR13LA203Accident · 1 fatalLimited investigationFinal reportHoffman RV-4 · Bullhead City, AZThe pilot’s suicidal act.NTSB ERA13FA101Accident · 3 fatalField investigationFinal reportPiper PA-30 · Jasper, ALThe student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.NTSB ERA12LA578Accident · 1 fatalLimited investigationFinal reportCessna 172B · Atlantic Ocean (Atlantic Ocean)The pilot’s suicidal act.NTSB ERA12LA307Accident · No injuriesLimited investigationFinal reportRice Leo B Kitfox Series 5 · Port Canaveral, FLImpingement of the elevator control by foreign objects (clamp, glove) left in the flight control path by the pilot/owner or maintenance personnel.NTSB ERA12CA198Accident · No injuriesData collectionFinal reportLester Robert E KR-2 · Boca Raton, FLThe failure of the airplane’s engine air inlet system resulting in a total loss of engine power.NTSB DCA12CA045Accident · Serious injuriesData collectionFinal reportBoeing 767 · Angers, Francethe flight attendant inadvertently tripping over a passenger's luggage strap that was protruding into the isle.NTSB ANC12CA018Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Beluga, AKGround personnel's movement of cargo in windy conditions, which allowed a previously secured cargo sack to blow into the main rotor blades.NTSB ERA12CA291Accident · Serious injuriesData collectionFinal reportNorth American SNJ-6 · Kissimmee, FLThe passenger’s fall from the airplane during a normal egress.NTSB ERA11LA457Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Graham, NCThe individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.NTSB CEN11LA404Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Athleimer, ARFailure of the first stage planetary gearset in the propeller reduction gearbox, which resulted in catastrophic engine failure. Contributing to the failure was the misrepresentation of the gearset being zero-timed by the company that sold the gearset to the…NTSB CEN11FA263Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Fredricktown, MOThe pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.NTSB WPR11FA490Accident · 1 fatalField investigationFinal reportRadford RV-6 · Grand Canyon, AZThe pilot's intentional flight into terrain.NTSB CEN11FA130Accident · 1 fatalField investigationFinal reportCessna 210B · Loveland, COThe pilot's intentional flight into terrain.NTSB ERA11LA033Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Waynesboro, GAThe pilot’s deliberate exiting of the airplane by parachute while in flight following a reported flight control malfunction that could not be verified.NTSB CEN10LA420Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Toulin, ILA partial loss of engine power as a result of a cracked cylinder and the reduced visibility due to the oil-covered windshield.NTSB CEN10LA220Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82(MD-82) · Chicago, ILThe flight attendant's loss of balance resulting in a fall and a broken wrist.NTSB WPR10CA177Accident · No injuriesData collectionFinal reportCessna 170 · Kingman, AZThe pilot’s failure to maintain directional control during landing rollout. Contributing to the accident was flight control interference by the passenger.NTSB CEN10FA124Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Austin, TXThe pilot’s intentional flight into a building.NTSB DCA10CA018Accident · Minor injuriesData collectionFinal reportBombardier CL600 2C10 · Dallas, TXThe fueler's falling asleep in the fueling truck with the truck in neutral and without the parking brake set, which allowed the truck to roll until it impacted the airplane.NTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.NTSB CEN09CA421Accident · No injuriesData collectionFinal reportPitts S-2A · Springfield, ILThe pilot's inability to maintain directional control while landing due to the unintentional obstruction of the rudder by the passenger.NTSB CEN09CA186Accident · Minor injuriesData collectionFinal reportBeech A36 · Athens, TXThe non-certificated pilot's failure to maintain control during his unauthorized use of the airplane.NTSB ERA09CA177Accident · Serious injuriesData collectionFinal reportHI-Max 1700R · Windham, NHThe non-certificated pilot's failure to maintain clearance from houses while flying an unregistered experimental, amateur-built airplane.NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.NTSB WPR09CA037Accident · No injuriesData collectionFinal reportCessna 182S · White Swan, WACollision with terrain while maneuvering for undetermined reasons.NTSB DEN08CA161AccidentData collectionFinal reportQuicksilver MX II Sprint · Killeen, TXThe operator's failure to maintain clearance from objects during the landing roll. Contributing to the accident was the operator's decision to operate a vehicle for which he/she was not certified.