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 CEN22LA115Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-201 · Olathe, KSThe total loss of engine power for undetermined reasons.NTSB ERA22LA115Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC-12/47E · Ronkonkoma, NYThe pilot’s failure to properly position the power control lever before starting the engine as required per the checklist. Contributing to the accident were the ice on the ramp and the pilot’s failure to secure the engine using the condition lever.NTSB WPR22LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Gila Bend, AZThe pilot's failure to maintain directional control during the landing rollNTSB ERA22LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 46-350P · Crystal River, FLCollapse of the nose wheel landing gear assembly due to lateral loads encountered on the turf runway during rollout.NTSB ERA22FA114Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · Danville, VAThe pilot’s impairment due to exposure to carbon monoxide as a result of undetected engine exhaust penetration into the cockpit, resulting in the pilot's failure to maintain a minimum controllable airspeed after partially securing an engine after takeoff.NTSB CEN22FA113Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Heath, OHThe pilot’s failure to maintain altitude after takeoff, which resulted in collision with trees and terrain.NTSB ERA22LA112Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195 · Palm Coast, FLThe pilot’s inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22FA111Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Hutchinson, MNThe reduction in fuel flow and subsequent partial loss of engine power after takeoff for reasons that could not be determined.NTSB CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…NTSB WPR22LA089Accident · No injuriesClass 3 · LimitedFinal reportBlake D Barrymore Just Acft Superstol · Ketchum, IDThe total loss of engine power due to carburetor ice.NTSB ERA22LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Waynesboro, VAThe student pilot’s loss of directional control while landing.NTSB ERA22LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Louisville, KYThe pilot’s failure to maintain directional control during landing in cross wind conditions.NTSB WPR22FA087Accident · 2 fatalClass 3 · FieldFinal reportBeech K35 · Salem, ORThe airplane’s excessive nose-up pitch attitude during landing for undetermined reasons.NTSB CEN22LA114Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Cook, MNThe pilot’s failure to ensure the snow-covered takeoff area was safe, which resulted in a collision with ice and subsequent landing gear damage.NTSB CEN22LA112Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Hortonville, WIThe loss of direction control while maneuvering off the plowed surface to avoid a collision with a vehicle.NTSB WPR22LA090Accident · Minor injuriesClass 3 · LimitedFinal reportTextron TTX Inc. T240 · Ravendale, CAThe inadequate maintenance and inspection of the engine induction system, which resulted in the separation of the right induction tube from the turbocharger compressor outlet and the subsequent loss of engine power during departure.NTSB WPR22LA085Accident · No injuriesClass 4 · LimitedFinal reportUniversal Stinson 108-2 · Byron, CAThe pilot’s inadequate flare and loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the instructor’s delayed remedial action.NTSB WPR22LA083Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Williams, AZThe pilot’s activation of the auxiliary fuel boost pump shortly after takeoff, which resulted in an excess amount of fuel to the engine and a total loss of engine power.NTSB CEN22LA110Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.NTSB WPR22LA084Accident · No injuriesClass 3 · LimitedFinal reportBell UH-1E · Gustine, CAFailure of the 90° gearbox due to the lack of lubricating oil, which resulted in a loss of rotational drive to the tail rotor and a subsequent loss of control of the helicopter.NTSB CEN22LA106Accident · Minor injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Lampasas, TXThe failure of a bolt in the engine valve system which resulted in malfunction of the engine exhaust valve system and a partial loss of engine power. The rough terrain encountered during the forced landing contributed to the outcome.NTSB WPR22LA082Accident · No injuriesClass 4 · LimitedFinal reportWight Albert A Kitfox Speedster · Shelton, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22LA107Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Angola, INThe pilot’s failure to ensure adequate terrain clearance during an approach. Contributing to the accident was the flight instructor’s delayed remedial action when the airplane descended too low after transitioning to a visual descent to the runway.NTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.NTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.NTSB ERA22LA110Accident · Serious injuriesClass 4 · LimitedFinal reportMiller Roger Thatcher CX4 · Angier, NCThe pilot’s encounter with a flock of birds on final approach, which resulted in a loss of control, an aerodynamic stall and spin, and impact with trees and terrain.NTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.NTSB CEN22LA103Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Sturtevant, WIThe pilot’s loss of directional control during the takeoff for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.NTSB CEN22LA101Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6C · San Antonio, TXThe pilot’s loss of directional control during landing.NTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.NTSB ANC22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Hana, HIThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…NTSB CEN22LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Carrizo Springs, TXThe pilot’s failure to maintain directional control of the airplane during landing with a gusting crosswind that resulted in a runway excursion.NTSB WPR22LA088Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Phoenix, AZThe failure of the right brake due to the separation of the brake pad from the brake assembly. Also causal was the improper maintenance of the airplane, which resulted in the use of a brake pad that was inappropriate for the airplane make and model.NTSB WPR22LA079Accident · No injuriesClass 4 · LimitedFinal report2021fx3 CCX-2000 · Redmond, ORThe pilot's failure to maintain directional control during the landing roll.NTSB ERA22LA109Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lexington, SCA loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.NTSB ERA22LA107Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Winter Haven, FLThe pilot receiving instruction’s failure to maintain airspeed during a turn, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor’s failure to…NTSB ERA22LA106Accident · No injuriesClass 4 · LimitedFinal reportCharles C Menger JR Safari 400 · Gallatin, TNA reported stuck throttle for reasons that could not be determined during postaccident examinations and subsequent loss of control during hover.NTSB ERA22LA129Accident · No injuriesClass 4 · LimitedFinal reportLindstrand Balloons 60X · Louisville, KYThe pilot applicant’s delayed reaction to the balloon's increased rate of descent, which resulted in impact with a light pole.NTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.NTSB CEN22LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Wahoo, NEThe pilot’s failure to maintain directional control during the landing.NTSB WPR22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Creswell, ORThe pilot’s excessive left brake pedal application during landing roll, which resulted a loss of directional control, runway excursion, and nose over.NTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…NTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.NTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.NTSB CEN22LA097Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1B · Matagorda Island, TXThe pilot’s loss of directional control during an intentional off-airport landing.NTSB WPR22LA072Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Upland, CAThe pilot’s loss of airplane control during a go-around as it encountered wake turbulence from a slow hover taxiing helicopter.