NTSB investigations, NJ
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.NTSB NYC94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lumberton, NJThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain directional control during an aborted landing. A factor is the pilot's improper landing flare.NTSB NYC94LA133Accident · No injuriesLimited investigationFinal reportHoopes RV-6 · Farmingdale, NJThe pilot's improper decision to fly after donating blood which resulted in his incapacitation.NTSB NYC94FA123Accident · No injuriesField investigationFinal reportGates Learjet 35 · Atlantic City, NJUnder-inflation of the tires, due to improper maintenance, which resulted in overheating and subsequent tire failure; the incorrect checklist that was provided to the aircrew; and failure of the pilot-in-command to deploy the drag chute, when the thrust…NTSB NYC94LA116Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Blairstown, NJThe pilot's failure to maintain directional control during takeoff, resulting in a loss of control and collision with the terrain.NTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.NTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.NTSB BFO94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sandy Hook, NJThe loss of engine power for reasons undetermined and the inability of the pilot to feather the propeller.NTSB BFO94FA104Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Warren Grove, NJThe pilot disregarded weather evaluations, attempted VFR flight into IMC and failed to maintain altitude and clearance from the terrain.NTSB BFO94FA092Accident · 2 fatalField investigationFinal reportCessna 172H · Millville, NJThe failure of the Cessna's pilot-in-command to perform an adequate visual lookout.NTSB NYC94LA089Accident · 1 fatalLimited investigationFinal reportTownsend, H.L. Briegled BG-12A · Readington, NJThe pilot failed to maintain airspeed while maneuvering which resulted in an inadvertent stall/spin. A factor was the lack of experience in the make and model of glider.NTSB NYC94FA078Accident · 2 fatalField investigationFinal reportRobinson R22A · North Bergen, NJThe pilot's failure to maintain adequate visual lookout and adequate obstacle clearance, which resulted in an inflight collision with a static wire.NTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.NTSB BFO94LA079Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Williamstown, NJthe pilot's failure to accurately determine the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing.NTSB BFO94LA075Accident · No injuriesLimited investigationFinal reportCessna 150M · Washington Cros, NJthe pilot-in-command's inadequate in-flight planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB NYC94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Fairfield, NJThe failure of the pilot to attain a proper touchdown, at the proper speed which resulted in an overrun and contact with a fence. A factor was the failure of the pilot to follow his initial air traffic instructions.NTSB BFO94LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Berlin, NJThe pilot not maintaining clearance from obstacles (trees) during final approach which resulted in a collision with a tree and a subsequent uncontrolled descent until colliding with the ground.NTSB BFO94LA028Accident · No injuriesLimited investigationFinal reportMitsubishi MU-3 · Teterboro, NJThe pilot selected unsuitable terrain for landing. The runway conditions were factors.NTSB NYC94LA044Accident · No injuriesLimited investigationFinal reportMooney 20E · Linden, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel and resulted in the loss of engine power.NTSB NYC94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lumberton, NJThe pilot's failure to maintain a proper glidepath due to improper compensation for the wind conditions. A factor was a crosswind.NTSB NYC94IA035Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Newark, NJThe separation of the right outboard translating cowl on the #2 engine thrust reverser as a result of inadequate bonding material.NTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.NTSB NYC94FA027Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Kinnelon, NJThe loss of engine power for undetermined reasons.NTSB BFO94LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150M · West Milford, NJThe loss of engine power due to an undetermined reason. A factor in this accident was the lack of suitable terrain to complete a forced landing.NTSB BFO94LA002Accident · 1 fatalLimited investigationFinal reportFairchild SA 227-AC · Newark, NJ1) The failure of the ramp agent to follow proper procedures during the servicing of the airplane, and 2) her lack of attention to the hazards surrounding her. Factors related to the accident are 1) the pressure placed on the ramp agent to rush the servicing…NTSB NYC94LA018Accident · No injuriesLimited investigationFinal reportCessna 170 · Williamstown, NJFatigue failure of the gear axle which resulted in the collapse of the left main gear.NTSB NYC94LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Millville, NJthe pilot's inadvertent actuation of the landing gear lever during the landing roll, resulting in the retraction of the landing gear on the runway.NTSB NYC94LA012Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Vernon, NJThe pilot's inadequate preflight inspection, which failed to detect an unsecured dipstick, resulting in oil starvation and the loss of engine power.NTSB NYC94LA005Accident · No injuriesLimited investigationFinal reportSwift S-1 · Blairstown, NJThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall. A factor is wind gust and the pilot's inexperience in type aircraft.NTSB NYC93FA169Accident · 2 fatalField investigationFinal reportBeech F35 · Medford, NJThe pilot's failure to select a fuel tank that contained fuel, and perform the emergency procedure to restart the engine, which resulted in fuel starvation and the loss of engine power. Factors are the pilot's lack of total experience and his inadequate…NTSB NYC93LA157Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Beach Haven, NJFailure of the banner release system to function for an undetermined reason, which resulted in an inability of the aircraft to sustain flight once the banner began dragging in the water. A factor related to the accident was: lack of coordination between the…NTSB NYC93FA158Accident · 1 fatalField investigationFinal reportCessna 172N · Lincoln Park, NJThe failure of both pilots to maintain adequate visual lookout while in the airport traffic pattern, which resulted in an in-flight collision.NTSB NYC93FA145Accident · 2 fatalField investigationFinal reportCurtiss-Wright Travel AIR 4000 · Marlboro, NJThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and inflight collision with the terrain.NTSB NYC93LA141Accident · Minor injuriesLimited investigationFinal reportGera Nieuport II · Somerville, NJThe loss of engine power for undetermined reasons.NTSB BFO93LA142Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Matawan, NJThe water collection in the ignition harness which rendered the lower cylinder spark plugs inoperative resulting in partial power loss.NTSB BFO93LA140Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Woodbine, NJThe pilot maintaining too steep of an angle of climb and an inadequate airspeed which resulted in an inadvertent stall/mush and subsequent loss of control in flight resulting in a collision with the runway. The pilot's lack of experience in the type of…NTSB BFO93LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belmar, NJThe pilot's inadequate compensation for wind and failure to maintain directional control during landing. Other related factors were the crosswind and the ravine.NTSB BFO93LA133Accident · Serious injuriesLimited investigationFinal reportBeatty Glasair SH-2 · Cape May, NJInadequate preflight by the pilot by not assuring the fuel selector was in the proper position for takeoff, which resulted in fuel starvation and subsequent loss of engine power; and failure of the pilot to maintain sufficient airspeed, which resulted in a…NTSB BFO93LA118Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Flemington, NJThe passenger's inadvertent activation of the burner after the landing, causing the terrain to burn and subsequently igniting the Balloon envelope.NTSB BFO93LA110Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lincoln Park, NJThe pilot's failure to maintain directional control of the airplane during landing rollout, and his delay is performing the proper remedial action of bringing back the left throttle to idle during landing rollout.NTSB BFO93LA106Accident · 1 fatalLimited investigationFinal reportWernega Benson KB-2 · Mount Holly, NJThe pilot's improper use of the gyroplane's flight controls.NTSB NYC93LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · West Milford, NJA manufacturer's defect which resulted in fatigue failure of the magneto impluse coupling spring and the loss of engine power. A factor was unsuitable terrain.NTSB NYC93LA122Accident · 1 fatalLimited investigationFinal reportSmitrvich Starduster SA-300A · Millville, NJThe pilot's inflight planning which resulted in fuel exhaustion. A factor was inadequate preflight planning.NTSB NYC93IA113Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60-200 · Atlantic City, NJA malfunction of the cargo fire warning system which resulted in a false alarm.NTSB NYC93LA104Accident · No injuriesLimited investigationFinal reportCessna 150J · West Caldwell, NJThe complete loss of engine power as a result of carburetor icing, the subsequent forced landing and impact with the terrain.NTSB NYC93LA101Accident · No injuriesLimited investigationFinal reportCessna 172P · Lincoln Park, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees.NTSB NYC93LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Linden, NJThe pilot's misjudgement of speed and distance which resulted in an overrun of the runway. A wet runway is a contributing factor.NTSB BFO93LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape May, NJThe pilot's failure to properly flare during landing, and his failure to properly recover from a bounced landing.NTSB BFO93LA079Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittstown, NJThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve. The gusty wind and proximity of the parked airplane were related factors.NTSB BFO93LA076Accident · Minor injuriesLimited investigationFinal reportHockenbury Bowers FLY Baby · Peapack, NJThe failure of the throttle valve actuating arm which resulted in partial opening of the throttle valve. A factor related to the accident was the unsuitable terrain available for landing.