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 NYC91LA238Accident · No injuriesLimited investigationFinal reportCessna 182RG · Robbinsville, NJA detached heli coil from the number 6 cylinder, resulting in a loss of engine power and subsequent forced landing in a corn field.NTSB NYC91FA230Accident · 1 fatalField investigationFinal reportBoeing PT-17 · Tranquility, NJLoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a stall. The lack of altitude for a recovery from the stall was a related factor.NTSB NYC91LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJAn off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.NTSB NYC91FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Marlboro, NJThe pilot's improper aircraft handling which resulted in an inadvertent stall and loss of control at an altitude insufficient for recovery. Factors related to the accident were an engine failure due to fuel exhaustion and improper preflight preparation.NTSB NYC91FA199Accident · 3 fatalField investigationFinal reportBeech C23 · Pleasantville, NJA power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…NTSB NYC91LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic City, NJThe failure of the pilot of N6877M to insure the runway was clear prior to pulling onto the runway.NTSB NYC91LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJThe decision of the pilot to discontinue a go-around, from an attempted landing, resulting in the airplane striking trees. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB NYC91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Old Bridge, NJThe failure of both pilots to maintain proper visual lookout. Factor related to the accident was inadequate radio communications by the pilots.NTSB NYC91DHM01Accident · Minor injuriesFinal reportAirnew Questair · Lincoln Park, NJA failure of the nose gear fork, which caused the pilot to lose steering control of the airplane and veer off the left side of the runway.NTSB NYC91LA164Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-605R · Newark, NJThe inadvertent encounter with in-flight turbulence, resulting in serious injuries to a crewmember and a passenger.NTSB NYC91DHA02Accident · Minor injuriesFinal reportVans RV-4 · Manville, NJThe pilot's failure to maintain directional control of the airplane after an aborted landing, which resulted in the airplane colliding with a mound of dirt off the runway.NTSB NYC91DHD02Accident · 1 fatalFinal reportBeamont Skybolt · Pennington, NJThe pilot's inadvertent lift off and failure to maintain aircraft control which resulted in an inadvertent stall. The pilot's lack of recent experience and lack of experience in type of airplane were factors in the accident.NTSB NYC91LA135Accident · No injuriesLimited investigationFinal reportCessna 152 II · Newtonville, NJPilot factor in that the student pilot delayed asking for assistance, after becoming lost until insufficient fuel was available to make an airport. This resulted in engine failure to fuel exhaustion and a subsequent emergency landing in rough terrain.NTSB NYC91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Lumberton, NJThe pilot's failure to maintain airspeed and the resultant inadvertent stall. A factor in the accident was the loose oil filter.NTSB NYC91LA126Accident · No injuriesLimited investigationFinal reportHughes 269B · Lincoln Park, NJAn inflight loss of control during a hover due to improper use of the flight controls by the pilot and the failure of the pilot to completely use the minimal visual references available.NTSB NYC91LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Milleville, NJThe total loss of engine power caused by mechanical failure, which resulted in the pilot landing the airplane on unsuitable terrain.NTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.NTSB NYC91LA083Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Rancocas, NJThe pilot-in-command failed to maintain airspeed on initial take off climb resulting in a stall and in flight collision with terrain. Contributing to the accident was a loss of engine power for undetermined reason and a gusty crosswind condition.NTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.NTSB NYC91LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wildwood, NJThe pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.NTSB NYC91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJImproper recovery from a bounced landings.NTSB NYC91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe failure of the pilot to abort the takeoff in sufficient time to prevent an overrun. Factors related to the accident were a partial power loss due to a faulty ignition system.NTSB NYC91FA035Accident · 1 fatalField investigationFinal reportCessna 414A · Atlantic City, NJFailure of the pilot to follow the published ILS procedure and his continued descent below the decision height. Darkness and the adverse weather conditions were related factors.NTSB NYC91LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Caldwell, NJPremature rotation and an inadvertent stall. Factors include lack of total experience in this type of aircraft.NTSB NYC91LA012Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Wildwood, NJThe student pilot's failure to maintain control of the airplane during landing.NTSB NYC90LA230Accident · No injuriesLimited investigationFinal reportCessna 150F · Colts Neck, NJThe pilot stalling the airplane during takeoff from a closed airport. Also causal to the accident was the pilot's decision to attempt the takeoff on the runway with high grass and to use one half the available runway lenght.NTSB NYC90LA216Accident · No injuriesLimited investigationFinal reportCessna C337 · Manville, NJThe pilot's failure to secure his seat which slipped back during the take off run.NTSB NYC90LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Farmingdale, NJThe pilot's exceeding a proper touchdown point. A factor in the accident was the pilot's misreading wind information.NTSB NYC90LA210Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Mannington Twp, NJThe pilot stalled and lost control of the airplane while taking off.NTSB NYC90LA204Accident · No injuriesLimited investigationFinal reportPiper 28R · Farmingdale, NJThe failure of the pilot of N8564F to insure the runway was clear prior to crossing.NTSB NYC90DHD03Accident · Minor injuriesFinal reportHeinrichs Rand KR-2 · Barnegat, NJThe loss of engine power due to magneto failure.NTSB NYC90FA179Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Springfield, NJThe pilot's failure to maintain airspeed and the inadvertent stall of the airplane at an altitude from which recovery was not possible.NTSB NYC90FA156Accident · No injuriesField investigationFinal reportBell 206 B3 · Teterboro, NJFailed power turbine shaft. Factors in the accident were corrosion on the power turbine shaft and inadequate manufacturer's service bulletins.NTSB NYC90LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Allaire, NJThe pilot's improper flare for the landing.NTSB NYC90LA137Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · West Milford, NJThe failure of the pilot in command to attain the proper touchdown point while making a forced landing following loss of engine power due to fuel exhaustion.NTSB NYC90LA134Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJGround resonance due to inadequate servicing and maintenance of the landing gear dampers.NTSB NYC90FHD01Accident · 1 fatalFinal reportMason Hummel Bird · Lumberton, NJFailure of the rudder attach bolt, which resulted in a loss of aircraft control and an uncontrolled descent to the ground.NTSB NYC90LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJThe accident was a inflight collision with an vehicle while the airplane was on final approach for a landing.NTSB NYC90LA120Accident · Minor injuriesLimited investigationFinal reportNavion H · Readington, NJThe failure of the pilot to maintain minimum flying airspeed which led to an inadvertent stall/mush. Factors related to the accident were the pilot's decision to land with a tailwind, and his failure to monitor his airspeed on final.NTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.NTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.NTSB NYC90LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Tinton Falls, NJThe failure of the student pilot to ensure there was sufficient fuel on board for the planned flight. A factor related to the accident was the failure of the flight instructor to properly prepare his student for the flight.NTSB NYC90LA094Accident · No injuriesLimited investigationFinal reportCessna C-172 · Matawan, NJPilot factor in that the pilot landed long and was unable to stop the a/c on the remaining r/w.NTSB NYC90LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Andover, NJThe pilot failed to maintain control of the aircraft after encounter with turbulence during landing.NTSB NYC90LA066Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Teterboro, NJThe pilot of N349MA failed to see and avoid another airplane taxiing in the same direction.NTSB NYC90LA059Accident · No injuriesLimited investigationFinal reportGlobe Swift Gcib · Pittstown, NJThe pilot failed to abort the takeoff after losing directional control during the takeoff ground run. Factors related to the accident were: crosswind, hidden obstruction in high vegetation, and low time in model.NTSB NYC90FA041Accident · 3 fatalField investigationFinal reportCessna 172N · Washington Twp, NJThe failure of the pilot to properly pre-flight plan and execute the VFR flight. Factor's related to the accident were: the pilot's inexperience; no visual cues (lights) due to dark night conditions; the pilot's disregard of the weather briefing.NTSB NYC90FA040Accident · 1 fatalField investigationFinal reportPiper PA-60-602P · Frenchtown, NJThe inadequate maintenance and inspection of the turbocharger tailpipe exhaust stack on the right engine by the mechanic(s). The failure of the tailpipe permitted heat from the exhaust to weaken the main spar of the right wing resulting in a catastrophic…NTSB NYC90FA038Accident · No injuriesField investigationFinal reportBoeing 727-31 · Newark, NJThermal distress of the first stage turbine blades of the nuber one engine causing a degradation of material properties which resulted in blade fractures. The reason for the thermal distress was not determined.NTSB NYC90LA035Accident · No injuriesLimited investigationFinal reportBeech B-23 · Tinton Falls, NJPrecautionary landing in unsuitable terrain following a partial power loss due to a failed exhaust valve.