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 IAD99LA061Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Bedminster, NJthe pilot's medical incapacitation after suffering a massive stroke.NTSB NYC99LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, NJA loss of engine power for undetermined reason(s).NTSB NYC99LA186Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Pittstown, NJThe pilot's failure to obtain the proper touchdown point.NTSB NYC99LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Manville, NJThe pilot's failure to follow the checklist and improper use of the carburetor heat. A factor in the accident was determined to be the density altitude.NTSB NYC99LA182Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Newton, NJThe pilot's failure to secure the oil cap after adding oil; the flight instructor's failure to insure the preflight was completed properly; and oil on the windshield obstructing forward vision.NTSB NYC99IA175Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Belmar, NJThe failure of the turbocharger clamp, resulting from improper welding settings during manufacture.NTSB NYC99FA169Accident · Minor injuriesField investigationFinal reportBell 206L-3 · Woodbridge, NJThe pilot's improper takeoff procedure, which resulted in a loss of tailrotor effectiveness.NTSB NYC99FA150Accident · 1 fatalField investigationFinal reportCanadair F-86E · Mount Holly, NJA failure in the fuel transfer system which resulted in fuel starvation and subsequent loss of engine power.NTSB NYC99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructors failure to maintain climb airspeed during the go-around, which degraded climb performance, resulting in an in-flight collision with terrain. Factors in the accident were, delay in executing a go-around, retracting the flaps to 10…NTSB NYC99FA130Accident · Serious injuriesField investigationFinal reportCessna P206B · Piscataway, NJwas a power loss for undetermined reason(s) while operating over unsuitable terrain.NTSB NYC99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Hillsborough, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of experience in the accident airplane's make and model.NTSB NYC99LA122Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Newark, NJIn flight encounter with turbulence which caused a flight attendant to fall and break two bones in his right leg.NTSB NYC99LA154Accident · No injuriesLimited investigationFinal reportCessna 172RG · Morristown, NJThe right main landing gear collapsed for undetermined reasons.NTSB NYC99LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Cross Keys, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the gusty wind conditions.NTSB NYC99LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, NJThe pilot in command's improper preflight preparation, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB IAD99LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairfield, NJwas the pilot's inadequate compensation for winds and his improper recovery from a bounced landing.NTSB NYC99LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Lumberton, NJThe pilot's misjudgment of altitude and distance which resulted in a runway overrun.NTSB NYC99FA078Accident · 1 fatalField investigationFinal reportDeleeuw Sprint 1000 · Lakewood, NJThe pilot's loss of control, which resulted in an unintentional stall/spin after an engine failure. A factor in the accident was the engine failure, which occurred when the magneto piston seized within the cylinder sleeve during an overtemp event.NTSB NYC99LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Newark, NJThe flight attendant's failure to follow cabin door opening procedures.NTSB NYC99LA069Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Atlantic City, NJUnanticipated in-flight turbulence.NTSB NYC99LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Berlin, NJThe pilot in command's failure to obtain the proper touch down point on the runway, and failure to perform a go-around. A factor relating to the accident was a sudden wind shift.NTSB IAD99LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Fairfield, NJThe flight instructor's failure to maintain rotor rpm and his failure to complete the autorotational descent. A factor in the accident was the flight instructor's failure to fully deploy carburetor heat as directed in the Pilot's Operating Handbook.NTSB NYC99FA047Accident · 1 fatalField investigationFinal reportCessna 310R · Kearny, NJa loss of elevator control for undetermined reasons.NTSB NYC99FA032Accident · Minor injuriesField investigationFinal reportEurocopter EC-135-P1 · Newark, NJthe pilot's failure to maintain proper rotor rpm and his improper in flight decision to enter autorotation due to his lack of knowledge of the power plant controls. Factors in the accident were the night conditions and the pilot's improper decision to fly…NTSB IAD99LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJthe student's pilot's inadequate climb and his failure to maintain adequate altitude and clearance. A related factor was the wind gusts.NTSB NYC99IA024Incident · No injuriesIncident investigationFinal reportBoeing 737-3TO · Newark, NJA loss of torque on the apex nut of the shimmy damper for undetermined reason(s), which resulted in a failure of the shimmy damper, and the subsequent failure of the lower torsion link of the right main landing gear.NTSB IAD99LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-C · Caldwell, NJThe pilot-in-command's failure to maintain directional control resulting in a ground-loop.NTSB NYC99LA018Accident · No injuriesLimited investigationFinal reportAero Commander AC-100 · Bridgeton, NJThe pilot's failure to properly flare the airplane at touchdown.NTSB NYC99FA015Accident · 1 fatalField investigationFinal reportCessna 172N · Linden, NJThe pilot's failure to maintain clearance from the power lines. A factor was sunglare.NTSB IAD99LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Pittstown, NJThe pilot's failure to obtain the proper touchdown point and his delay in executing a go-around. A factor in the accident was the tailwind.NTSB NYC99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-R200 · Caldwell, NJThe failure of both the normal and emergency brake systems.NTSB IAD99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Teteboro, NJthe collapse of the landing gear due to a bent gear locking mechanism for undetermined reasons.NTSB NYC98LA189Accident · No injuriesLimited investigationFinal reportCessna 172M · Teterboro, NJThe pilot's failure to maintain control of the airplane. Factors in this accident were the night light conditions, and pilot's lack of recent night flight experience.NTSB IAD98LA105Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Freehold, NJThe passenger's failure to secure himself during landing.NTSB NYC98LA169Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Jackson Twnshp, NJThe flight (check pilot) instructor's excessive pull-up maneuver and his inadvertent entry into a low altitude stall/spin.NTSB NYC98LA168Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-1A · Erial, NJCatastrophic failure of the number 2 engine cylinder, emanating from a corrosion pit on the outside cylinder wall. A factor was the pilot's diminished forward visibility due to oil on the windshield.NTSB NYC98LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172P · West Milford, NJThe student pilot's improper recovery from a bounced landing and the instructor's inadequate supervision of the flight.NTSB NYC98LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Hackettstown, NJThe pilot's failure to use the airplane's takeoff performance data, and his failure to obtain the proper climb airspeed.NTSB IAD98LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Salem, NJThe pilot's failure to maintain adequate altitude/clearance from the reeds. A related factor was the wind gusts.NTSB IAD98LA079Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · West Milford, NJLoss of engine power for undetermined reasons.NTSB IAD98LA100Accident · No injuriesLimited investigationFinal reportCessna 172L · Lincoln Park, NJInadequate visual lookout by the pilot, which resulted in his failure to see and avoid the fuel truck. Related factors were the truck and the pilot was unfamiliar with that area.NTSB IAD98LA114Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hammonton, NJImproper maintenance, which resulted in an over-pressurized landing gear.NTSB IAD98LA063Accident · No injuriesLimited investigationFinal reportCessna 175 · Pemberton, NJThe pilot's inadequate fuel consumption calculations and his improper in-flight decision to continue flying with an inadequate fuel supply.NTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.NTSB NYC98FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 195 · Cape May, NJUndetermined.NTSB NYC98LA084Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, NJThe pilot in commands improper recovery from a bounced landing.NTSB NYC98FA073Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Somerville, NJin-flight separation of the empennage for undetermined reasons. "This case was modified August 2, 2006."NTSB NYC98FA047Accident · 1 fatalField investigationFinal reportCady LONG-EZ · West Milford, NJFailure of the pilot to use carburetor heat, which resulted in carburetor ice. Carburetor icing conditions and terrain conditions were contributing factors.NTSB NYC98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mount Holly, NJThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pittstown, NJthe pilot's misjudgment of distance and speed during the approach, and her failure to perform a go-around.