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 WPR18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Phoenix, AZA total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.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 ANC18LA049Accident · No injuriesClass 3 · LimitedFinal reportLearjet 60 · Salt Lake City, UTThe flight crew’s failure to fully disengage the parking brake before taxi, which resulted in a brake fire.NTSB GAA18CA375Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Goose Bay, AKThe pilot’s failure to maintain a proper approach path during landing in dusky, flat light conditions, which resulted in a tree strike.NTSB ERA18TA179Accident · Minor injuriesFinal reportStearman B75 · Lexington, NCThe pilot’s overapplication of the wheel brakes during landing, which resulted in a nose-over.NTSB GAA18CA377Accident · No injuriesData collectionFinal reportJonker Sailplanes JS1-C · Panguitch, UTThe pilot’s inability to maintain altitude and his delayed decision to deploy the powered-glider’s engine, which necessitated an off-airport landing.NTSB CEN18FA236Accident · 2 fatalField investigationFinal reportCessna P210N · Detroit, MIA total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…NTSB WPR18FA178Accident · 1 fatalClass 2 · FieldFinal reportSchempp-Hirth Standard Cirrus · Aguila, AZThe pilot's exceedance of the glider's critical angle of attack while attempting a thermal climb at low altitude, which resulted in an aerodynamic stall/spin at an altitude that precluded recovery.NTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB GAA18CA381Accident · No injuriesData collectionFinal reportPiper PA 30 · Goodyear, AZThe pilot receiving instruction’s failure to maintain directional control during the landing roll.NTSB ANC18LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe failure of the brake line tube due to an improper flare.NTSB ANC18LA047Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-2 · Dillingham, AKThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB GAA18CA372Accident · Minor injuriesData collectionFinal reportBeech D17 · Hamilton, MTThe pilot’s failure to maintain directional control during the landing roll and his subsequent inability to recover due to his foot being stuck.NTSB ERA18FA174Accident · 1 fatalField investigationFinal reportCessna 172 · Diamondhead, MSThe student pilot's failure to retract the flaps following landing and the stall/mush that resulted during the subsequent full-flap takeoff and initial climb.NTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…NTSB GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB GAA18CA370Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.NTSB GAA18CA371Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Hutchinson, MNThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA18CA369Accident · No injuriesData collectionFinal reportCessna 172 · Bruington, VAThe pilot’s improper decision to abort the takeoff with insufficient runway remaining to safely stop the airplane.NTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.NTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.NTSB GAA18CA363Accident · No injuriesData collectionFinal reportPiper PA22 · Yakutat, AKThe pilot’s failure to maintain directional control during landing.NTSB ERA18LA170Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Raleigh, NCThe pilot's inadequate preflight inspection, during which he failed to detach ground handling equipment from the helicopter before initiating the takeoff, which resulted in the subsequent dynamic rollover.NTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.NTSB GAA18CA380Accident · No injuriesData collectionFinal reportJabiru J250 · Ferndale, WAThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident were the pilot’s lack of experience and training in the accident airplane make and model.NTSB GAA18CA368Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Columbia, SCThe pilot's failure to maintain directional control during landing.NTSB GAA18CA356Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 · Winnsboro, SCThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s improper decision to provide instruction in an airplane with only one control stick.NTSB CEN18LA230Accident · No injuriesLimited investigationFinal reportCessna TR182 · Beloit, KSThe mechanic’s failure to properly torque one of the left brake caliper’s back plate attachment bolts while re-installing it during the annual inspection, which resulted in the left main landing gear not extending before landing.NTSB GAA18CA441Accident · No injuriesData collectionFinal reportPiper PA · East Sound, WAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control in a gusting, left quartering headwind.NTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB GAA18CA361Accident · No injuriesData collectionFinal reportRaytheon A36 · Lakeview, ARThe pilot’s failure to extend the landing gear before landing, which resulted in a propeller strike, followed by an aborted landing and a subsequent hard, precautionary landing.NTSB GAA18CA355Accident · No injuriesData collectionFinal reportPiper PA18 · Salcha, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.NTSB CEN18LA229Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Desdemona, TXThe total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.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 WPR18LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Page, AZThe failure of the airplane’s nose wheel steering/centering mechanism, which resulted in a loss of directional control and subsequent runway excursion.NTSB GAA18CA358Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Spanish Fork, UTThe pilot receiving instruction’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB CEN18LA228Accident · Minor injuriesLimited investigationFinal reportRGJ Johnson AIR CAM · Greenwood, ILThe pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR18FA171Accident · 2 fatalClass 2 · FieldFinal reportBeech A35 · Hesperia, CAThe pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…NTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA354Accident · No injuriesData collectionFinal reportBoeing B75 · Waukegan, ILThe flight instructor’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB GAA18CA351Accident · No injuriesData collectionFinal reportCessna 185 · Big Lake, AKThe pilot’s inability to maintain directional control during the landing roll due to a flat tire.NTSB ANC18LA046Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Ambler, AKThe pilot's selection of an unsuitable takeoff area with unfavorable wind conditions, which resulted in the airplane’s inability to maintain a climb.NTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.NTSB WPR18CA172Accident · No injuriesData collectionFinal reportDornier Alpha JET · Sacramento, CAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.NTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.NTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…NTSB ERA18LA168Accident · No injuriesClass 3 · LimitedFinal reportStinson L 5 · Thomson, GAFailure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…NTSB CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.