NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 CEN10CA375Accident · No injuriesData collectionFinal reportPiper PA32 · Albuquerque, NMThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB WPR10TA335Accident · No injuriesFinal reportPiper PA-18-150 · Dillon, MTThe pilot's failure to maintain directional control during landing.NTSB WPR10LA331Accident · No injuriesLimited investigationFinal reportCessna 210 · Coeur d'Alene, IDThe loss of engine power during cruise flight for undetermined reasons.NTSB ERA10LA348Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Marion, KYThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB ERA10FA347Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Fairfield, NJThe pilot's failure to maintain aircraft control during the go-around following a hard landing. Contributing to the accident was the pilot's continuance of an unstabilized final approach and the improper use of flaps during the go-around.NTSB ERA10FA346Accident · 1 fatalField investigationFinal reportCessna 172P · Chesapeake, VAThe airplane's impact with terrain for undetermined reasons following the pilot's report of a flight control malfunction.NTSB ERA10CA355Accident · No injuriesData collectionFinal reportPiper J3C-65 · Warrenton, VAThe pilot's improper flare during a precautionary landing, which resulted in a hard landing.NTSB CEN10LA383Accident · No injuriesLimited investigationFinal reportCessna 182M · Alamagordo, NMThe pilot's loss of airplane control during landing, which resulted in a hard/bounced landing.NTSB WPR10CA334Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Tillamook, ORThe certified flight instructor’s selection of an inappropriate landing surface and the loss of engine power as a result of the improper use carburetor heat. Contributing to the accident was the flight instructor's inadequate supervision.NTSB CEN10MA367Accident · 5 fatalMajor investigationFinal reportCessna 421B · Alpine, TXThe degraded performance of the airplane due to the pilot not properly setting the flaps and retracting the landing gear after takeoff. Contributing to the accident was the pilot’s fatigue.NTSB CEN10LA368Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Pocahontas, ILThe pilot's failure to maintain a wings-level attitude prior to impacting high vegetation and terrain during the off-field landing.NTSB CEN10IA372Incident · No injuriesIncident investigationFinal reportEurocopter AS365N3 · Dayton, OHThe unintentional movement of the jettison handle in-flight due to the pilot’s dropping of a manual that impacted the handle and released the door window, which then impacted the horizontal stabilizer. Contributing to the accident was the jettison handle…NTSB CEN10CA371Accident · No injuriesData collectionFinal reportBrantly B-2B · East Troy, WIThe pilot's failure to maintain control during landing.NTSB CEN10CA369Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Austin, TXThe pilot's failure to maintain directional control of the helicopter, resulting in impact with trees. Contributing to the accident was the pilot's failure to ensure the door was properly secured prior to flight.NTSB WPR10LA347Accident · No injuriesLimited investigationFinal reportBeech E-55 · Las Vegas, NVThe landing gear collapse for undetermined reasons.NTSB WPR10CA338Accident · No injuriesData collectionFinal reportAdams John R JR Piel Diamant · Montezuma, UTThe pilot's failure to maintain clearance from road signs during landing.NTSB WPR10CA337Accident · Minor injuriesData collectionFinal reportCessna 150M · Neola, UTA partial loss of engine power for undetermined reasons and the pilot's failure to maintain clearance from a power line.NTSB ERA10LA345Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fairfield, PAThe pilot's improper touchdown point which resulted in an overrun.NTSB ENG10RA063Accident · No injuriesForeign investigationAgustadWestland AW139 · Hong Kong, Hong Kong SAR ChinaOn July 3, 2010, a Sky-Shuttle Helicopter AugustaWestland AW139 helicopter, operated as East Asia Airlines, registration number B-MHJ, experienced a tail rotor and tailrotor gearbox separation over Victoria Harbor, Hong Kong shortly after departure from the…NTSB CEN10WA413Accident · Minor injuriesForeign investigationBell 206 · La Tuna, MexicoThe government of Mexico has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 03, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN10CA377Accident · No injuriesData collectionFinal reportAero Commander 100 · Jacksonville, ARThe pilot's failure to maintain an appropriate approach speed and his delayed decision not to initiate a go-around. Contributing to the accident was the pilot's lack of experience in the airplane type.NTSB CEN10CA376Accident · No injuriesData collectionFinal reportWells Terry Hula Girl · Wellington, COA partial loss of engine power due to the inadequate design of the engine cowling.NTSB WPR10LA340Accident · No injuriesLimited investigationFinal reportMooney M20F · Cottonwood, AZThe pilot’s failure to lower the landing gear prior to landing.NTSB WPR10FA325Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, CAThe pilot's failure to maintain adequate airspeed and airplane control during initial climb, which resulted in an aerodynamic stall/spin and subsequent impact with the ground.NTSB ERA10FA342Accident · 2 fatalField investigationFinal reportNorth American AT-6 · Destin, FLThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's improper decision to perform the maneuvers at a low altitude and over water.NTSB ERA10CA343Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Burnsville, NCThe pilot's failure to maintain a proper visual glideslope during final approach.NTSB CEN10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Centerville, MOA loss of engine power due to carburetor icing as a result of the pilot not using carburetor heat.NTSB CEN10CA366Accident · No injuriesData collectionFinal reportAviat A-1B · Centennial, COThe student pilot's failure to maintain directional control and the certified flight instructor's delay in remedial action.NTSB WPR10FA324Accident · 1 fatalField investigationFinal reportCessna 182P · Avalon, CAThe pilot's incapacitation due to a heart attack, which resulted in a loss of airplane control.NTSB WPR10CA333Accident · No injuriesData collectionFinal reportCessna 180 · Missoula, MTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during the landing roll.NTSB WPR10CA323Accident · No injuriesData collectionFinal reportCessna 172M · Twin Falls, IDThe student pilot's improper landing flare.NTSB ENG11WA010Incident · No injuriesForeign investigationFokker F28 · Warsaw, PolandOn July 1, 2010, Swiss International Airlines flight 343T, operated by Contact Air, a Fokker F100, registration D-AGPH, suffered a collapsed radome during departure from Warszawa-Okecie airport, Warsaw, Poland. The crew reported a sound of an impact on the…NTSB CEN10FA364Accident · 2 fatalField investigationFinal reportBeech F33A · Perry, KSThe failure of the engine driven fuel pump causing a loss of engine power and the pilot's failure to maintain aircraft control resulting in an inadvertent stall. Contributing to the accident was the pilot’s failure to follow the emergency procedures checklist…NTSB CEN10CA398Accident · No injuriesData collectionFinal reportBradshaw Quicksilver MX II · Newark, ILA total loss of engine power during cruise when the ignition switch vibrated into the "off" position, leading to the airplane's impact with a ditch during the off-field landing.NTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.NTSB WPR10CA320Accident · No injuriesData collectionFinal reportCessna 175 · Huntsville, UTThe pilot's failure to maintain adequate clearance from terrain during climb.NTSB ERA10CA363Accident · No injuriesData collectionFinal reportCessna 172S · Chesapeake, VAA hard landing by person(s)unknown.NTSB ERA10CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Farmingdale, NYThe student pilot's failure to maintain directional control during a crosswind landing.NTSB CEN10CA373Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe pilot's failure to maintain adequate airspeed during landing, which resulted in a stall.NTSB ANC10LA056Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe total loss of engine power during cruise flight due to a fractured crankshaft.NTSB ERA11WA157Incident · No injuriesForeign investigationBeech 300 · Jundiai, BrazilOn June 29, 2010, about 1910 UTC, a Beech 300, Brazilian registration PP-EPD, operated by The Government of the State of Amazonas, Brazil had a blown tire during the landing roll following a forced landing shortly after takeoff from Jundiai Airport (SBJD),…NTSB ERA10CA353Accident · No injuriesData collectionFinal reportLawwill Ted Zodiac 601XL · Waddy, KYA loss of engine power due to fuel starvation for undetermined reasons.NTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.NTSB WPR10LA319Accident · No injuriesLimited investigationFinal reportPridmore Lancair IV · Caldwell, IDThe failure of maintenance personnel to ensure that a hydraulic line fitting was adequately secured during a conditional inspection, which resulted in a leak and subsequent on-ground fire.NTSB WPR10LA317Accident · Serious injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZThe in-flight separation of the exhaust clamps for an undetermined reason, which resulted in the exhaust system striking the wooden propeller.NTSB ERA10CA339Accident · No injuriesData collectionFinal reportPiper J3C-65 · Thomaston, GAThe pilot’s failure to maintain directional control during landing.NTSB ERA10CA337Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.NTSB CEN10LA363Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Pioneer, LAThe inadvertent encounter with convective weather during cruise flight. Contributing to the accident was the flight crew's failure to detect and avoid the thunderstorm cell earlier in the flight, and the failure of air traffic controllers to provide the…NTSB CEN10CA365Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Rogers, ARThe pilot's failure to maintain a proper descent rate during the approach to land.NTSB ANC10CA054Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Igiugig, AKThe pilot's decision to use only a portion of the available takeoff area, which resulted in a collision with terrain during takeoff.