NTSB investigations
19,222 cases where NTSB found Aircraft.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 CEN24LA063Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Sapulpa, OKThe total loss of engine power due to the failure of the left magneto and subsequent damage to a lead for the right magneto.NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.NTSB CEN24LA066Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Searcy, ARThe pilot-rated passenger’s reported failure to maintain control during the landing.NTSB CEN24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · New Orleans, LAThe improper maintenance of the main landing gear, which resulted in a collapse and overstress failure of the left main landing gear during landing.NTSB CEN24LA060Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Anthony, KSA failure of the airplane’s alternator, which resulted in a loss of electrical power, and the pilot’s failure to use the emergency gear extension procedure during the initial landing approach, which led to a gear-up landing.NTSB ANC24LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kapolei, HIThe first pilot’s failure to maintain a stabilized approach, in gusty crosswind conditions, in an environment favoring wake turbulence.NTSB WPR24FA054Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Topock, AZThe failure of the No. 4 connecting rod due to oil starvation, which resulted in a loss of engine power, inflight fire, and a subsequent off-airport emergency landing on rough desert terrain. Contributing to the accident was the pilot’s decision to attempt a…NTSB CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.NTSB CEN24LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Ann Arbor, MIThe airplane’s encounter with unexpected wind shear during final approach, which resulted in a hard landing short of the runway.NTSB CEN24FA057Accident · 2 fatalClass 3 · FieldFinal reportBeech A23-24 · Oklahoma City, OKA total loss of engine power due to multiple connecting rod failures from oil starvation associated with an extensive before takeoff oil system leak, the source of which could not be identified due to postaccident fire damage.NTSB WPR24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeauchamp Norm Kitfox · Eloy, AZThe separation of a propeller blade during the initial climb due to insufficient blade retention forces. Contributing to the accident was the propeller blade retention design, manufacturing defects that prevented the propeller from achieving adequate grip…NTSB ERA24LA060Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Mount Vernon, ALThe pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.NTSB CEN24LA103Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Bremen, INThe collapse of the nose landing gear after it contacted soft terrain during the landing roll.NTSB CEN24LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · McGregor, TXThe failure of the spring pin in the right propeller governor, which precluded the pilot from controlling the propeller pitch to maintain engine rpm, resulting in a loss of engine thrust, excessive drag, and the subsequent forced landing to a field.NTSB ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable.NTSB ERA24LA059Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Zephyrhills, FLAn aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.NTSB ERA24FA058Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-C33 · Pulaski, TNThe pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.NTSB WPR24FA052Accident · Serious injuriesClass 3 · FieldFinal reportRemos Remos GX · Taylor, AZThe pilot’s decision to attempt takeoff with frost covering the airplane’s wings, which led to an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.NTSB WPR24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Mesa, AZA failure of the engine cowling right side latch pin and fasteners, which resulted in the partial separation of the engine cowling during flight.NTSB CEN24LA056Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Fordyce, ARThe pilot’s failure to attain a proper touchdown point following an unidentified electrical system failure and subsequent partial loss of engine power, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s…NTSB ERA24LA054Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Millington, TNThe pilots’ fuel mismanagement during the cross-country flight and incorrect fuel tank selection for the landing approach, which resulted in fuel starvation, a momentary loss of engine power, and collision with terrain short of the runway.NTSB ERA24FA055Accident · 2 fatalClass 3 · FieldFinal reportBeech E95 · Elkmont, ALThe flight instructor’s failure to maintain control of the airplane during slow flight, which resulted in an aerodynamic stall and spin from which he was unable to recover.NTSB ANC24LA005Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Kapolei, HIA partial loss of engine power due to lose baffling from the muffler, which resulted in an obstruction of the exhaust system.NTSB ERA24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Midland, VAThe pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…NTSB WPR24LA046Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210N · Big Bear, CAA loss of engine power during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.NTSB ERA24LA056Accident · No injuriesClass 3 · LimitedFinal reportRaytheon 400A · Atlanta, GAThe collapse of the airplane’s left main landing gear during the landing roll for undetermined reasons.NTSB ERA24LA052Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Martinsville, VAThe pilot’s failure to maintain directional control during a wheel landing in crosswind conditions and the flight instructor’s delayed remedial action, which resulted in a ground loop on the runway.NTSB CEN24LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Manitowoc, WIMaintenance personnel’s improper servicing of the magnetos, which resulted in their accelerated wear, failure, and the total loss of engine power.NTSB WPR24LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Modesto, CAThe failure of the pilot to maintain directional control of the airplane during landing, which resulted in a nose over.NTSB CEN24FA049Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 600 · Sterling City, TXThe pilot’s failure to maintain clearance from a power line pole’s static arm during forecasted gusting wind conditions, un-forecasted light turbulence, and un-forecasted low-level wind shear conditions, resulting in main rotor blade contact with the static…NTSB ERA24LA051Accident · No injuriesClass 3 · LimitedFinal reportLancair 235 · Stuart, FLA landing gear collapse due to a hydraulic fluid leak in the landing gear system.NTSB CEN24LA050Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Minneapolis, MNLoss of engine power due to fuel starvation that was the result of a leaking fuel drain.NTSB WPR24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Las Cruces, NMAn encounter with a downdraft during an approach to land, which resulted in a hard landing.NTSB WPR24LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170B · Cameron Park, CAA failure of the right brake master cylinder piston due to a faulty return spring, which resulted in a seized right main landing gear brake and a runway excursionNTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…NTSB WPR24LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182G · Casa Grande, AZThe loss of engine power during landing for undetermined reasons.NTSB ERA24LA049Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Valdosta, GAThe pilot’s failure to extend the landing gear before landing.NTSB CEN24FA046Accident · 2 fatalClass 3 · FieldFinal reportSocata TBM 700 · Ludington, MIThe pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA24LA047Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20F · Meridianville, ALThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land, which resulted in an aerodynamic stall, a loss of airplane control, and impact with terrain.NTSB CEN24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · DeWitt, ARThe pilot’s loss of airplane directional control while landing.NTSB CEN24FA045Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22T · Fairland, INBoth pilots’ failure to maintain adequate airspeed during departure from the airport, which led to the airplane exceeding its critical angle of attack, entering an aerodynamic stall, and impacting terrain.NTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.NTSB CEN24LA043Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Four · Eau Claire, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN24FA042Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Plano, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a climbing turn during a go-around, which resulted in an aerodynamic stall and loss of control.NTSB ANC24LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · McCarthy, AKThe pilot’s loss of directional control after touchdown which resulted in substantial damage to the right wing.NTSB ERA24LA048Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Blairstown, NJThe student pilot’s improper control inputs and the flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.NTSB ERA24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 112 · Saluda, SCThe pilot’s failure to maintain directional control of the airplane during an aborted landing in crosswind conditions. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR24LA048Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Hungry Horse, MTThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Woodland, WAThe flight instructor’s inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.