NTSB investigations, NJ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA' 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."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' 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 ERA22FA315Accident · 1 fatalClass 3 · FieldFinal reportPiper PA12 · Middle Township, NJThe pilot’s exceedance of the airplane’s critical angle of attack during a missed banner pickup, which resulted in an aerodynamic stall/spin and loss of control at an altitude too low to recover.NTSB ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.NTSB ERA22LA297Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G-164A · Hopewell Township, NJA partial loss of engine power while maneuvering at low altitude due to a failure of the airplane’s supercharger.NTSB ERA22FA257Accident · Serious injuriesClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Fairfield, NJThe failure of maintenance personnel to properly secure the tail rotor crosshead drive plate and the failure of maintenance personnel, the maintenance pilot, and the accident pilot to detect the error, which led to the helicopter’s loss of tail rotor…NTSB ERA22LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Pemberton Township, NJThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of control.NTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.NTSB ERA22LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Toms River, NJLoss of engine power due to the throttle linkage becoming disconnected in flight due to improper maintenance.NTSB ERA22LA190Accident · No injuriesClass 4 · LimitedFinal reportTextron 525B · Caldwell, NJThe flight crew’s failure to attain a proper touchdown point during landing, which resulted in an overrun of the runway and collision with terrain.NTSB ERA22LA179Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Manville, NJThe pilot’s delayed go-around decision following an encounter with a tailwind during landing, which resulted in an inability to climb and subsequent impact with trees.NTSB ERA22LA175Accident · Minor injuriesClass 3 · LimitedFinal reportLearjet 45 · Morristown, NJThe captain’s inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB DCA22LA053Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330 · Newark, NJTurkish Airlines flightcrew’ s misperception of the distance to safely pass the stopped Republic Airways airplane.NTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.NTSB ERA22LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ringwood, NJA loss of engine power in flight due to fuel exhaustion as a result of the pilot’s failure to secure the left wing’s fuel cap.NTSB ERA22LA040Accident · No injuriesClass 4 · LimitedFinal reportJack A Frohbieter Questair Venture · Robbinsville, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in substantial damage to the lower fuselage. Contributing to the accident was the pilot’s failure to utilize the aircraft checklist.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB DCA22LA002Accident · No injuriesClass 4 · LimitedFinal reportBoeing 757-224 · Newark, NJThe nose high attitude on landing resulted in a tailstrike.NTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.NTSB ERA21LA389Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Fairfield, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA21LA337Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV7 · Mount Holly, NJThe pilot’s improper recovery from a bounced landing, resulting in a touchdown on the nose gear first, resulting in damage to the nose gear and a runway excursion.NTSB ERA21LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 210N · Somerville, NJThe pilot’s failure to extend the landing gear, which resulted in a gear up landing and substantial damage to the fuselage.NTSB ERA21LA312Accident · No injuriesClass 4 · LimitedFinal reportBeech K35 · Readington, NJThe failure of the forward end of the landing gear actuator rod.NTSB ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.NTSB ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.NTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB ERA21LA102Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Vineland, NJA steep descent and impact with terrain during final approach for reasons that could not be determined.NTSB ERA21LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot’s failure to maintain a proper glidepath while on approach to the runway, and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with a tree on final approach.NTSB ERA21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and noseover.NTSB ERA21LA043Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS355 · Hammonton, NJThe pilot's decision to continue the takeoff with a perceived mechanical deficiency.NTSB ERA20CA252Accident · Minor injuriesClass 4 · Data collectionFinal reportFurlong CA-6 · Manville, NJA loss of directional control on takeoff for undetermined reasons.NTSB ERA20CA113Accident · No injuriesData collectionFinal reportLearjet 55 · Farmingdale, NJThe flight crew's failure to stop the airplane on the available runway, which was wet and resulted in the airplane impacting a ditch.NTSB ERA20CA139Accident · No injuriesData collectionFinal reportBeech 200 · Morristown, NJThe airplane hydroplaning while landing on a wet runway, which degraded its braking capability and resulted in a runway overrun onto grass and mud and the nose landing gear collapsing. Contributing to the accident was the pilot's improper decision to land the…NTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…NTSB ERA20FA020Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Colonia, NJThe pilot’s failure to maintain airspeed during a circling instrument approach procedure, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall and spin.NTSB ERA19LA280Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Manville, NJA total loss of engine power due to the ingestion of sealant material that had loosened inside the carburetor airbox.NTSB GAA19CA399Accident · Serious injuriesData collectionFinal reportSchweizer SGS233 · Blairstown, NJThe student pilot's improper landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing and the instructor sustaining a serious injury.NTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.NTSB ERA19LA199Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 · Readington, NJThe pilot's failure to land on the mowed turf runway, which resulted in the airplane landing in tall grass and subsequently nosing over.NTSB DCA19CA167Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Newark, NJan improper landing flare, which resulted in a bounced landing and substantial damage.NTSB GAA19CA322Accident · No injuriesData collectionFinal reportCirrus SR22 · Trenton, NJThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a runway excursion and subsequent substantial damage.NTSB ERA19FA184Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Cape May, NJThe pilot's intentional flight into water as an act of suicide.NTSB GAA19CA264Accident · No injuriesData collectionFinal reportAero Commander 695 · Mount Holly, NJThe airplane’s impact with a deer on the runway during takeoff.NTSB WPR19TA131Accident · No injuriesClass 3Final reportRobinson R22 · Lincoln Park, NJThe flight instructor's failure to maintain control of the helicopter while transitioning from a hover to forward flight, which resulted in a loss of control.NTSB ERA19LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Mount Holly, NJFailure of the pilot's seat back due to a sheared bolt during the landing roll, which resulted in a loss of directional control and runway excursion.NTSB GAA19CA153Accident · No injuriesData collectionFinal reportCessna 172 · Princeton, NJA collision with deer on the runway while landing at night and the airport's lack of a complete perimeter fence.NTSB GAA19CA151Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe student pilot's improper rudder input and the flight instructor's delayed remedial action during takeoff, which resulted in a loss of directional control, a runway excursion, and the landing gear collapsing.NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB ERA19LA062Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Paramus, NJMaintenance personnel's improper assembly of the engine during overhaul, which resulted in lubrication restriction due to a bearing shift and the subsequent engine failure.NTSB ERA19TA042Accident · Serious injuriesClass 3Final reportMooney M20C · Wildwood, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation during the initial climb. Contributing to the accident was the pilot’s decision to initiate a 180° turn following the loss of power.