NTSB investigations
902 cases where the first occurrence 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 LAX02LA016Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 600N · Laughlin, NVthe manufacturer's failure to provide warning information and ground training about the possibilities of boom strikes by the rotor blades in windy conditions and low rotor rpm situations.NTSB NYC02LA011Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ashland, VAThe line technician's inadvertent contact with the propeller during a hand-propped engine start.NTSB MIA02LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe failure of the pilot to use the checklist resulting in a gear-up landing. Contributing factors in the accident were: 1) The inoperative landing gear warning system, 2) Inadequate preflight of the airplane by the pilot for his failure to assure that the…NTSB MIA02LA009Accident · No injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's inattentive preflight inspection, non-compliance with the prestart checklist, decision to leave the cockpit unattended with engine running, and his inadvertent deactivation of the parking brake as he exited to remove a wheel chock, resulting in…NTSB LAX02LA007Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahoolawe Isle, HIInadequate visual surveillance by the pilot before takeoff resulting in liftoff with a deplaning passenger still partially aboard the helicopter. A factor in the accident was the operator's inadequate procedures.NTSB NYC02LA027Accident · No injuriesLimited investigationFinal reportLet Blanik L 33 Solo · Windsor, VAThe pilot's inadequate preflight inspection, which resulted in a loose battery charger becoming entangled in the rudder pedals during a spin recovery, and a subsequent overstress of the glider. Factors included the loose battery charger, and the non-standard…NTSB CHI01LA332Accident · Serious injuriesLimited investigationFinal reportAviaStrottel AC 4C · Marshfield, MIThe pilot's decision to release from the tow plane during the takeoff. A factor associated with the accident was the pilot's vision was restricted by his hat during the takeoff.NTSB CHI01LA331Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Indianapolis, INthe inadequate crew/group coordination and the parking brakes not set by the pilot in command.NTSB LAX01LA305Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAA hard landing due to the dual student's failure to maintain main rotor speed, his improper landing flare, and the flight control interference by the flight instructor.NTSB CHI01LA296Accident · No injuriesLimited investigationFinal reportDassault/SUD Fan Jet Falcon · Detroit, MIThe wheels up landing performed by the flightcrew during the emergency landing and improper aircraft preflight by the pilot in command. Factors were the unsecured cargo door, the cemetery fence, and the lack of crew coordination during the flight.NTSB ATL01LA098Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Eagleville, TNThe loss of thermals during the glider flight that resulted in the collision with high vegetation while maneuvering for an emergency landing. A factor was high vegetation.NTSB SEA01LA153Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe premature release of the towline and the pilot's improper selection of a landing area following the release. Factors include improper preflight planning.NTSB MIA01LA215Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Savannah, GAThe delay of the pilot to perform a go-around following a bounced landing and porpoise, and failure of the pilot to maintain directional control resulting in the airplane departing the runway and colliding with a berm.NTSB MIA01LA212Accident · 2 fatalLimited investigationFinal reportPiper PA-32-260 · Key West, FLThe inadvertent disabling of the throttle in the idle position during a cockpit disturbance created when an armed hijacker forcibly attempted to cause the aircraft to fly to Cuba, resulting in a loss of controllability of power for sustainable flight and an…NTSB CHI01LA262Accident · No injuriesLimited investigationFinal reportGrice Avid Flyer · Belle Fourche, SDThe pilot failed to maintain aircraft control during the forced landing. A factor associated with the accident was the excessive adjustment that the pilot made to the propeller's pitch prior to the flight.NTSB CHI01LA245Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Detroit, MIThe passenger (an off duty flight attendant) disregarded the flight crews warning regarding turbulence along with the seat belt sign which had been turned on.NTSB CHI01LA239Accident · Minor injuriesLimited investigationFinal reportAnderson Revelation · Wautoma, WIThe pilot's failure to maintain airspeed, resulting in a stall. An inadequate pitch setting of the propeller is a contributing factor.NTSB CHI01LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Gladwin, MIThe pilot's poor decision to exit the airplane onto the wing while the propeller was running.NTSB MIA01LA178Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Leesburg, FLThe pilot's failure to maintain a visual lookout while deploying the grappling hook in preparation for a banner pick up resulting in the cable wrapping around the stabilizer, subsequent loss of control during the banner drop (due to the cable moving forward…NTSB LAX01LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · San Diego, CAthe flight crew's excessive descent rate, which resulted in an injury to a flight attendant.NTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…NTSB MIA01FA163Accident · 1 fatalField investigationFinal reportCessna 172RG · Waveland, MSThe incapacitation of the pilot (cardiovascular) resulting in his inability to fly the airplane and subsequent in-flight collision with trees then a house.NTSB NYC01LA150Accident · Serious injuriesLimited investigationFinal reportRaven S60A · Mumford, NYThe ground handler's failure to follow instructions to release her line during the balloon's unintended ascent, due to panic.NTSB LAX01LA182Accident · No injuriesLimited investigationFinal reportCessna 182E · Fallon, NVThe pilot's failure to maintain clearance with a road sign during an emergency landing to a road. Contributing factors were the smoke created from a bird nest in the engine compartment, and the pilot's diverted attention due to an approaching car on the road.NTSB MIA01FA126Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilot's exceeding the forward center of gravity (CG) ) limits at the time of engine start, the inability of the pilot to control the airplane due to the exceeded CG limits, the failure of the pilot to abort the takeoff with sufficient runway remaining,…NTSB NYC01LA125Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Cleveland, OHAn overload force being exerted on the nosewheel gear assembly for undetermined reason.NTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.NTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.NTSB FTW01LA090Accident · No injuriesLimited investigationFinal reportMooney M20J · Pecos, TXthe pilot's failure to obtain a proper glide path during landing, which resulted in the airplane's impact with terrain short of the runway. Contributory factors were the open baggage door and the pilot's diverted attention to the open door.NTSB FTW01LA086Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain rotor rpm, which resuted in the main rotor contacting the tail during landing.NTSB LAX01LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anza, CAThe pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.NTSB LAX01TA092Accident · No injuriesFinal reportMcDonnell Douglas 600N · San Diego, CAThe student pilot's improper use of the rotorcraft flight controls, and the instructor pilot's inadequate supervision of the maneuver.NTSB DEN01LA050Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Pinedale, WY**This report was modified on 2/18/2016. Refer to the public docket for this accident for an explanation of the changes.** loss of directional control after touchdown for undetermined reasons.NTSB LAX01LA086Accident · Minor injuriesLimited investigationFinal reportStorey MK 7 · Marana, AZThe pilot's inadequate preflight preparation with regards to runway choice, terrain, and performance capabilities of the airplane.NTSB FTW01LA067Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS.125-700A · New Orleans, LAthe pilot-in-command's inadequate preflight inspection, which resulted in a flight with a blocked fuel tank vent. A contributing factor was maintenance personnel's failure to remove the tape covering the fuel tank vent following a pressure test.NTSB MIA01LA055Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cleveland, TNThe PIC's failure to follow safe operating procedures for the maintenance of the rotorcraft's external aerial application equipment, resulting in inadvertent activation of collective as he egressed the rotorcraft, causing unmanned flight, in-flight break-up,…NTSB LAX01FA059Accident · 1 fatalField investigationFinal reportDehavilland DHC-6 · Sacramento, CAThe passenger committed suicide.NTSB NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB NYC01FA007Accident · 1 fatalField investigationFinal reportBeech E18S · Wash. Ct. House, OHAn undetermined event, which resulted in an off airport landing. A factor in this accident was the night light condition.NTSB NYC00LA269Accident · No injuriesLimited investigationFinal reportSaab 340B · Boston, MAThe operator's loss of control of the belt-loader, due to his improper decision to depress the vehicle's accelerator in the proximity of the airplane.NTSB SEA00LA177Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, WADamage to aircraft under unknown circumstances.NTSB CHI00LA268Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Baraboo, WIthe unexpected turbulence encountered by the airplane.NTSB NYC00IA231Incident · No injuriesIncident investigationFinal reportFokker F-100 · Norfolk, VAThe failure of the airplane's ground/flight switch and a malfunction of the thrust reverser deploy switch, which resulted in an in-flight thrust reverser deployment.NTSB MIA00LA232Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Alabaster, ALa loss of engine power for undetermined reasons resulting in a forced landing and subsequent impact with the ground. A factor in this accident was that the pilot did not obtain the proper touchdown point upon landing and landed long.NTSB SEA00TA149Accident · No injuriesFinal reportShort SD3-30 200 · Elk City, IDEntanglement of air-dropped cargo parachute with the aircraft's horizontal stabilizer, resulting in damage to the horizontal stabilizer.NTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.NTSB LAX00LA223Accident · No injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the mechanic to refasten the cowling door prior to returning the aircraft to service.