NTSB investigations, 2010
79 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 year(c.\"eventDate\") = 2010
AND 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 year(c."eventDate") = 2010 AND 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 ANC10CA050Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the airplane nosing over during taxi.NTSB CEN10CA280Accident · No injuriesData collectionFinal reportHughes 269A · Cannon Falls, MNThe pilot's failure to maintain rotor speed during the autorotation, which resulted in an excessive sink rate and a hard landing.NTSB ERA10IA285Incident · No injuriesIncident investigationFinal reportCessna 560XL · White Plains, NYThe flight crew's failure to ensure that the cabin door was secured/locked prior to takeoff.NTSB CEN10WA331Accident · No injuriesForeign investigationCirrus Design SR20 · Sirdal, NorwayOn May 28, 2010, at 1708 coordinated universal time (UTC), a Cirrus Design Corporation model SR20 airplane, s/n 1888, Norwegian registration LN-BCD, was substantially damaged when it impacted mountainous terrain near Sirdal, Norway. The flight had encountered…NTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.NTSB CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.NTSB CEN10CA246Accident · No injuriesData collectionFinal reportCarlesimo Glasair III T · Lynwood, ILA loss of engine power due to fuel starvation as a result of the pilot's failure to follow the pre-landing checklist and verifying the position of the fuel selector.NTSB ANC10CA039Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe uncertificated pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.NTSB CEN10FA233Accident · 2 fatalField investigationFinal reportJetProp DLX Piper PA46 · New Albany, INThe pilot’s failure to maintain airspeed in instrument meteorological conditions, which resulted in an aerodynamic stall.NTSB ERA10LA251Accident · Serious injuriesLimited investigationFinal reportInterstate S1A · Lakeland, FLThe pilot’s failure to maintain clearance from terrain for undetermined reasons.NTSB WPR10LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172N · TamuningThe failure of the pilot to maintain clearance with the airplane’s propeller while hand-propping.NTSB WPR10LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Tooele, UTThe complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…NTSB WPR10CA206Accident · No injuriesData collectionFinal reportCessna 150L · Princeville, ORThe pilot’s failure to ensure that the parking brake was set prior to hand-starting the engine.NTSB WPR10LA216Accident · No injuriesLimited investigationFinal reportCessna 210 · Show Low, AZInadequate clearance between a landing gear brake system line and airframe components, which precluded gear extension and resulted in an intentional gear-up landing.NTSB WPR10LA200Accident · No injuriesLimited investigationFinal reportBell 222U · Santa Maria, CAThe pilot's inadequate preflight inspection to ensure that all tie-down straps were removed prior to flight. Contributing to the accident was the pilot's improper management of sleep opportunities during the preceding rest period, which likely contributed to…NTSB CEN10CA199Accident · Serious injuriesData collectionFinal reportCessna 172 · Lawton, OKThe private pilot's failure to maintain adequate airspeed, which resulted in a stall, and the failure of both pilots to initiate a go-around. Contributing to the severity of both pilots' injuries was the lack of available shoulder harnesses.NTSB CEN10CA201Accident · No injuriesData collectionFinal reportGrumman G-164B · Forest City, MOThe pilot's failure to maintain aircraft control during landing, which resulted in an encounter with wet/muddy terrain and a subsequent nose over.NTSB ERA10LA216Accident · No injuriesLimited investigationFinal reportSmith Richard D JR Revolution Mini 500 · Middleboro, MAA loss of engine coolant, which resulted in a loss of engine power during the pilot’s attempt to cushion a precautionary landing. Contributing to the accident was a disconnected engine coolant hose and the pilot's inadequate preflight inspection.NTSB ERA10CA211Accident · Serious injuriesData collectionFinal reportFirefly AX8B · Durhamville, NYThe passenger's failure to adequately brace herself for the landing.NTSB CEN10CA213Accident · No injuriesData collectionFinal reportWaco YPF-7 · Houston, TXThe pilot's inability to maintain control during landing due to the failure of the tailwheel locking mechanism to remain engaged prior to landing.NTSB CEN10IA169Incident · No injuriesIncident investigationFinal reportSikorsky S-92A · Galliano, LAAn unsecured access door, which departed the helicopter and damaged a main rotor blade and a tail rotor blade. Contributing to the incident was the helicopter's color scheme, which made visual inspection of the door difficult.NTSB WPR10CA164Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Parker, AZThe mechanics' failure to account for all the tools following a maintenance procedure and the pilot's failure to perform a preflight check before a maintenance test flight.NTSB ERA10LA172Accident · No injuriesLimited investigationFinal reportHughes 369 · Naples, FLThe pilot's excessive aft cyclic imput during the flare following an practice autorotation, which resulted in main rotor blade contact with the tail boom.NTSB WPR10RA197Accident · Serious injuriesForeign investigationEagle 150B · Kota Bahru, MalaysiaOn March 9, 2010, about 1630 local time, an Eagle 150B, Malaysia registration 9M-BEV, crashed near Kota Bahru, Kelantan, Malaysia, subsequent to an in-flight propeller separation. The two occupants, a flight instructor and student pilot, sustained serious…NTSB CEN10LA127Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 65-B80 · Minneapolis, MNThe pilot of the other airplane not setting the parking brake adequately while holding for departure. Contributing to the accident was the pilot of the other airplane being distracted while doing his paperwork.NTSB DCA10WA040Incident · No injuriesForeign investigationBoeing 727 · Torino, ItalyOn February 21, 2010, a Thomas Cook Boeing 757-200, registration G-TCBA, experienced an uncommanded fuel dump during initial climb after takeoff from Turin International Airport (LIMF), Torino, Italy. There were no injuries to the 8 crew members and 231…NTSB CEN10CA110Accident · No injuriesData collectionFinal reportBeech J35 · Russellville, ARThe pilot's improper engine starting procedures.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB DCA10IA022Incident · No injuriesIncident investigationFinal reportBombardier CL600 · Charleston, WV(1) The flight crewmembers’ unprofessional behavior, including their nonadherence to sterile cockpit procedures by engaging in nonpertinent conversation, which distracted them from their primary flight-related duties and led to their failure to correctly set…