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 GAA19CA103Accident · No injuriesData collectionFinal reportRobinson R44 · Strykersville, NYThe structural failure of the home-built landing platform during landing, which resulted in the helicopter rolling over.NTSB ENG19RA007Incident · No injuriesForeign investigationAirbus A330 · Brussels, BelgiumThe Air Accident Investigation Unit of Belgium has notified the NTSB of a serious incident involving an Airbus A330-223 that occurred on December 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation Unit…NTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.NTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.NTSB GAA19CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Lihue, HIThe passenger’s improper decision to hold her cell phone outside the helicopter, which resulted in it departing the helicopter and striking the tail rotor.NTSB GAA19CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Waynesburg, PAThe student pilot's improper decision to maneuver the airplane through an area of construction and his subsequent failure to maintain clearance from a concrete pole barrier while taxiing.NTSB GAA19CA024Accident · No injuriesData collectionFinal reportCessna 172 · Vergennes, VTThe pilot's failure to maintain clearance from trees while taxiing.NTSB GAA19CA030Accident · Serious injuriesData collectionFinal reportUltramagic N 250 · Rio Rancho, NMThe balloon tipping over during deflation, which resulted in a passenger injury.NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.NTSB GAA18CA567Accident · No injuriesData collectionFinal reportPiper PA18 · St. Mary's, AKThe pilot’s selection of an unsuitable off-airport landing area, which resulted in a ground loop.NTSB GAA18CA533Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Cut Bank, MTThe pilot’s failure to see and avoid power wires while maneuvering at low altitude. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.NTSB CEN18LA346Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Shreveport, LAThe student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.NTSB WPR18WA225Accident · 1 fatalForeign investigationRobinson R22 · Queenstown, South AfricaOn August 15, 2018, at 0830 Universal Coordinated Time, a Robinson R22 Beta helicopter, ZS-HBP, impacted power lines while conducting a game capturing flight near Queenstown, South Africa. The pilot sustained serious injuries and the passenger was fatally…NTSB GAA18CA486Accident · No injuriesData collectionFinal reportBushby Mustang II · Akron, COThe pilot’s improper preflight planning that did not identify the unserviceable runway; his subsequent decision to attempt to takeoff from the rough, grassy runway; and his selection of an abort point with insufficient runway remaining, which resulted in a…NTSB GAA18CA483Accident · No injuriesData collectionFinal reportRobinson R22 · Ocean City, NJThe flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.NTSB WPR18WA235Accident · 1 fatalForeign investigationAyres S2R · Diatar, MauritaniaOn August 8, 2018, at an unknown time, an Ayres S2R T34 airplane, F-GOKZ, impacted terrain during an agricultural operation near Diatar, Mauritania. The pilot was fatally injured. The airplane was being operated under the pertinent civil regulations of the…NTSB GAA18CA521Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Fairbanks, AKThe pilot’s premature liftoff and subsequent settling of the airplane to the gravel airstrip.NTSB WPR18LA205Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · San Diego/El Cajon, CAThe pilot’s inadequate preflight planning, which resulted in his exceedance of the airplane's maximum gross weight, which lead to the airplane's poor climb performance, and a subsequent loss of control and impact with terrain.NTSB ERA18LA202Accident · No injuriesLimited investigationFinal reportCessna 150 · Matthews, NCThe student pilot's improper decision to conduct a solo flight without an endorsement to do so and to perform an off-airport landing based on a perceived performance issue with the airplane. Contributing to the accident was the pilot's lack of training and…NTSB DCA18WA297Incident · No injuriesForeign investigationAirbus A330 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on July 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…NTSB GAA18CA400Accident · No injuriesData collectionFinal reportChampion 8GCBC · Waunakee, WIThe pilot’s failure to maintain clearance from tall corn along the edge of the airstrip during takeoff.NTSB GAA18CA401Accident · No injuriesData collectionFinal reportGrumman G164 · Rochelle, ILThe pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall.NTSB CEN18CA240Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Encino, TXThe gunner's failure to ensure that the net would not ensnare the helicopter's skids once deployed, which resulted in the pilot being unable to maintain helicopter control as the bull pulled on the net and subsequent impact with terrain.NTSB OPS18IA015Incident · No injuriesClass 3 · IncidentFinal reportBoeing 747 · Chicago, ILInterference with the localizer signal resulting in a Multipath condition experienced by CAL5148 while conducting an ILS CAT III (autoland) approach. This condition resulted in a runway excursion and subsequent go-around. The interference was most likely…NTSB GAA18CA366Accident · No injuriesData collectionFinal reportRobinson R66 · Cordova, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in impact with brush and a loss of helicopter control.NTSB CEN18CA294Accident · No injuriesData collectionFinal reportRobinson R22 · Sterling City, TXThe pilot’s improper decision to exit the helicopter without shutting down the engine, which allowed the collective/throttle to increase and resulted in a loss of control of the unattended helicopter.NTSB DCA18WA207Incident · No injuriesForeign investigationBoeing 737 · Otopeni, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB DCA21WA027IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsNTSB GAA18CA329Accident · No injuriesData collectionFinal reportDobbs George Coot · Malone, WIThe pilot’s improper decision to take off with a known structural issue, which resulted in hull damage.NTSB GAA18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Fuquay Varina, NCThe flight instructor’s failure to maintain adequate clearance from overgrown brush during taxi, which resulted in entanglement with the brush and a subsequent impact with a tree.NTSB GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.NTSB GAA18CA289Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Yakutat, AKThe helicopter’s movement during startup in gusting wind conditions, which resulted in the main rotor striking the tailboom.NTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…NTSB GAA18CA273Accident · Minor injuriesData collectionFinal reportChristopher Lord ELA Eclipse 10 · Calhoun, GAThe student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.NTSB GAA18CA265Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Truman, ARThe pilot’s failure to see and avoid a pole during an agricultural application flight.NTSB WPR18WA138Accident · 2 fatalForeign investigationTaylorcraft BC12 · Vryheid, South AfricaOn April 29, 2018, at 1110 coordinated universal time, a Taylorcraft BC 12-D airplane, registration ZS-BLD, sustained substantial damage under unknown circumstances following a departure from Vryheid Aerodrome (FAVY), Kwa-Zulu Natal, South Africa. Both…NTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.NTSB DCA18WA153Incident · No injuriesForeign investigationAirbus A319 115 · MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A319 115 airplane that occurred on April 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB GAA18CA189Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Gila Bend, AZThe pilot’s failure to properly set the parking brake, which resulted in an impact with a pole.NTSB WPR18LA107Accident · Serious injuriesLimited investigationFinal reportCubcrafters CC11-160 · Browns Valley, CAThe pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.NTSB ERA18MA099Accident · 5 fatalClass 1 · MajorFinal reportAmerican Eurocopter AS350B2 · New York, NYLiberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…NTSB GAA18CA153Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Many, LAThe pilot’s improper application of the brakes during landing, which resulted in a nose-over.NTSB CEN18LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Blair, WIThe pilot’s failure to recognize and compensate for hazards during the external load operation, which led to a collision between a lineman (external load) and a powerline.NTSB WPR18WA240Accident · No injuriesForeign investigationCessna 206 · Southport, AustraliaOn March 4, 2018, about 1040 local time, a Cessna U206G airplane, VH-LHQ, was substantially damaged when it impacted water during takeoff near Southport, Queensland, Australia. The pilot and two passengers were not injured. The investigation is under the…NTSB GAA18CA136Accident · No injuriesData collectionFinal reportCessna 180 · Big Lake, AKThe pilot’s selection of unsuitable terrain for landing, which led to both skis breaking through the ice while positioning the airplane after landing.NTSB GAA18CA129Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wadsworth, TXThe passenger’s gun becoming lodged in the flight controls during takeoff and his failure to remove it, which resulted in impact with terrain.NTSB GAA18CA127Accident · No injuriesData collectionFinal reportHughes 369 · Heber City, UTThe pilot’s failure to maintain clearance from an elk while maneuvering at a low altitude.NTSB ENG18RA015Incident · No injuriesForeign investigationBoeing 757 · Auckland, New ZealandThe Australian Transport Safety Bureau has notified the NTSB of an incident involving a Boeing 757-236, which occurred on February 5,2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau investigation…