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 CEN18LA364Accident · Serious injuriesLimited investigationFinal reportLindstrand 77A · Brookfield, MOThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in his ejection from the basket and serious injury to the passenger during the balloon’s subsequent impact with…NTSB GAA18CA529Accident · No injuriesData collectionFinal reportPiper PA46 · Hartford, CTThe pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.NTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.NTSB ERA18FA230Accident · 1 fatalField investigationFinal reportAeronca 7AC · Hanson, MAA loss of engine power due to carburetor icing, the pilot's decision to turn back to the runway shortly after takeoff, and his failure to maintain airspeed during the turn, which resulted in an exceedance of the airplane's critical angle of attack, and…NTSB GAA18CA503Accident · Minor injuriesData collectionFinal reportChampion 8GCBC · Elberta, ALThe pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.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 GAA18CA547Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, VTThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA504Accident · No injuriesData collectionFinal reportPiper PA18 · McGrath, AKThe pilot’s failure to maintain directional control during takeoff in a crosswind.NTSB GAA18CA512Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Battle Mountain, NVThe pilot's failure to maintain the proper altitude and airspeed while flying in a canyon in gusting wind conditions.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 GAA18CA488Accident · No injuriesData collectionFinal reportCessna 185 · Brooks Range, AKThe airplane's encounter with downdraft conditions during takeoff, which resulted in a subsequent loss of altitude and collision with terrain.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 ERA18LA215Accident · No injuriesLimited investigationFinal reportCessna R182 · Florence, SCThe pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…NTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…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 GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.NTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.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 GAA18CA458Accident · No injuriesData collectionFinal reportAllen W Inks Virus SW · Clayton, GAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.NTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.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 GAA18CA452Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA450Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lantana, FLThe student pilot’s improper pitch control during landing, which resulted in a dynamic rollover.NTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.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 WPR18LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell UH 1H · Oakdale, CAThe pilot's loss of control during a precautionary landing following an abnormal noise in-flight, the source of which could not be determined.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 CEN18LA287Accident · No injuriesLimited investigationFinal reportCessna 210C · Blum, TXThe pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.NTSB WPR18FA200Accident · 1 fatalField investigationFinal reportDe Havilland DH112 Venom · Sheboygan, WIThe airplane's encounter with wake turbulence from the lead airplane in the formation flight, which resulted in a compressor stall and the airplane's subsequent inability to climb.NTSB CEN18LA290Accident · Minor injuriesLimited investigationFinal reportBell 206 · Todd Mission, TXThe passenger’s inadvertent interference with the tail rotor pedals, which resulted in a loss of helicopter control during takeoff and the subsequent impact with terrain.NTSB GAA18CA561Accident · No injuriesData collectionFinal reportApollo Fox · Chateaugay, NYThe pilot’s failure to maintain clearance from trees during a go-around.NTSB GAA18CA429Accident · No injuriesData collectionFinal reportCessna 170 · Spearfish, SDThe pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.NTSB GAA18CA428Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's improper landing flare, which resulted in a bounced landing.NTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…NTSB ANC18CA054Accident · Minor injuriesData collectionFinal reportCurtiss Wright C46 · Manley Hot Springs, AKThe pilot's failure to attain the proper touchdown speed and his decision to land with a tailwind without ensuring that there was adequate runway length for the touchdown.NTSB WPR18CA213Accident · No injuriesData collectionFinal reportCessna E162 · Burlington, WAThe student pilot’s failure to maintain pitch control during an aborted takeoff.NTSB GAA18CA425Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.NTSB GAA18CA406Accident · No injuriesData collectionFinal reportBeech 76 · Fort Lauderdale, FLThe pilot receiving instruction's failure to maintain a proper approach path and her delayed go-around during a simulated emergency landing, which resulted in landing short of the runway. Contributing to the accident was the flight instructor's failure to…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 WPR18LA190Accident · Minor injuriesLimited investigationFinal reportAutogyro Calidus · Tacoma, WAThe pilot's failure to properly configure the gyrocopter for takeoff, which resulted in it developing high speed and led to a subsequent loss of control.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 GAA18CA394Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Louisburg, NCThe student pilot's distraction due to a previous runway excursion and navigational issues during the accident flight and his failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the downwind leg, which…NTSB GAA18CA393Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · San Saba, TXThe pilot’s improper landing flare during the aborted takeoff, which resulted in a hard landing and a nose-over.NTSB CEN18LA250Accident · No injuriesLimited investigationFinal reportCessna 180 · Lago Vista, TXThe separation of the left main landing gear spring during landing due to a preexisting fatigue crack.NTSB GAA18CA388Accident · Minor injuriesData collectionFinal reportCessna A185 · Miami, FLThe pilot’s failure to retract the wheels of the amphibious airplane on takeoff, which resulted in a nose-over when the airplane landed on water with the wheels extended. Contributing to the accident was the pilot’s failure to use appropriate checklists.