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 IAD02FA091Accident · 2 fatalField investigationFinal reportPiper PA 32R-301T · Byram Township, NJthe improper manufacturing of the crankshaft gear bolt, which resulted in the failure of the bolt due to hydrogen embrittlement, and the subsequent loss of engine power. Also causal was the engine manufacturer's failure to remove the affected bolts from fixed…NTSB NYC02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Belmar, NJThe improper use of an fuel additive which resulted in a power loss. A factor was the lack of suitable terrain.NTSB NYC02FA171Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Andover, NJThe flight instructor's delayed remedial action to correct the low rotor condition. A factor was the student pilot's improper use of the collective, which created the low rotor condition.NTSB IAD02LA084Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · West Milford, NJThe private pilot's excessive rotation and the flight instructor's delayed remedial action.NTSB NYC02LA157Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Atlantic City, NJThe pilot's improper flare during approach.NTSB IAD02FA074Accident · 1 fatalField investigationFinal reportWehrlen Glassair II RG · Jackson, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with terrain.NTSB NYC02FA138Accident · Serious injuriesField investigationFinal reportYakovlev YAK 52 · Matawan, NJThe pilot's excessive maneuvering and failure to maintain aircraft control, following a partial power loss during the initial climb, which resulted in an inadvertent stall/spin. A factor in the accident was an inadequate annual condition inspection performed…NTSB NYC02LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructor's improper recovery from a bounced landing.NTSB NYC02LA136Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Lincoln Park, NJThe pilot's failure to abort the takeoff when diminished performance was noted. A factor was carburetor icing, accumulated before the takeoff attempt.NTSB NYC02LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Andover, NJThe flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.NTSB NYC02LA137Accident · No injuriesLimited investigationFinal reportCessna 177 · Millville, NJThe pilot's improper bounced landing recovery. A factor was the dark night conditions.NTSB IAD02LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Ocean City, NJThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind. A factor was a wind gust.NTSB NYC02FA126Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Farmingdale, NJThe pilot's failure to maintain directional control during takeoff.NTSB NYC02LA107Accident · No injuriesLimited investigationFinal reportKarl & Dot Comp Air 7SL · Cross Keys, NJFatigue fracture of the tail wheel spring, which resulted in a loss of control and impact with a ditch.NTSB IAD02LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Trenton, NJThe separation of the engine induction alternate air door, which resulted in a loss of engine power. A factor was the non-compliance with the manufacturer's service letter.NTSB IAD02LA054Accident · Minor injuriesLimited investigationFinal reportMiller Barnet J4B-2 · Manville, NJThe pilot's improper flare prior to touchdown. A factor was the pilot's lack of experience in aircraft type, make, and model.NTSB NYC02LA093Accident · No injuriesLimited investigationFinal reportD'Apuzzo D-260 · Andover, NJThe pilot's failure to obtain proper runway alignment while landing, which resulted in a gear collapse.NTSB IAD02IA046Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · Atlantic City, NJThe partial loss of flight display information for undetermined reasons.NTSB NYC02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Teterboro, NJThe pilot's improper flare and his improper recovery from a bounced landing, which resulted in a hard landing. A factor in this accident was the crosswind condition.NTSB NYC02LA090Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Blairstown, NJThe pilot's improper flare, and his failure to maintain obstacle clearance which resulted in a tail strike.NTSB IAD02LA045Accident · No injuriesLimited investigationFinal reportCessna P210N · Linden, NJThe pilot's failure to lower the landing gear prior to landing.NTSB NYC02LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Matawan, NJThe pilot's inadequate weather evaluation, and excessive airspeed while landing. A factor was a tailwind.NTSB IAD02LA040Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Mount Holly, NJThe pilot's misjudgment of distance, his subsequent improper recovery from a bounced landing, and the failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC02LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Belmar, NJThe student pilot's failure to maintain runway alignment during landing. A factor in the accident was the winds.NTSB IAD02LA038Accident · No injuriesLimited investigationFinal reportCessna 172P · Ocean City, NJThe pilot's inadequate compensation for wind and his failure to maintain directional control.NTSB NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…NTSB NYC02LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Atlantic City, NJThe pilot's failure to lower the landing gear prior to landing.NTSB NYC02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point.NTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.NTSB NYC02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Cross Keys, NJThe pilot's delayed decision to abort the landing.NTSB NYC02LA017Accident · Minor injuriesLimited investigationFinal reportBeech B95A · Pittstown, NJThe pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.NTSB IAD02LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Farmingdale, NJthe flight instructor's delayed remedial action to correct the pilot's lack of directional control during landing. A factor was the crosswind.NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.NTSB NYC01FA217Accident · 2 fatalField investigationFinal reportCessna 172SP · Matawan, NJThe pilot's failure to maintain runway alignment during the initial climb. Factors were the pilot's failure to perform a go-around, the pilot's lack of flight experience in nighttime conditions, the nighttime conditions, and a tailwind.NTSB NYC01LA196Accident · Minor injuriesLimited investigationFinal reportAir & Space 18A · Blairstown, NJAn encounter with ground resonance for undetermined reasons.NTSB NYC01LA191Accident · No injuriesLimited investigationFinal reportMooney M20J · East Greenwich, NJThe pilot's premature liftoff which resulted in an inadvertent stall.NTSB NYC01LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · West Milford, NJThe student pilot's failure to maintain directional control while landing. Factor’s in this accident were a wind gust and the rocks located off the left side of the runway.NTSB NYC01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Sandy Hook, NJA total loss of engine power for undetermined reasons.NTSB NYC01IA199Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Teterboro, NJThe right aft rudder cable being installed over a cable guide by maintenance personnel.NTSB IAD01LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Millville, NJThe student pilot's failure to compensate for wind conditions and his failure to maintain directional control during landing. A factor was the crosswind.NTSB IAD01LA080Accident · Serious injuriesLimited investigationFinal reportAerostar International RXS-8 · Flemington, NJpilot's continued flight into known adverse weather conditions, which resulted in a hard landing. A factor was the downdrafts.NTSB IAD01LA079Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Matawan, NJThe inadequate maintenance inspection of the airplane by its owner, which resulted in a locked brake and a nose-over during the takeoff roll.NTSB NYC01LA168Accident · No injuriesLimited investigationFinal reportBell 206B · Secaucus, NJUnder torque of a Thomas coupling self-locking nut for undetermined reasons, which resulted in the loss of the corresponding retaining bolt, and subsequent separation of tail rotor drive shaft segments. A factor was the unsuitable terrain beneath the pilot…NTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.NTSB IAD01LA067Accident · No injuriesLimited investigationFinal reportde Havilland DH-82 Tiger Moth · Allamuchy, NJThe loss of engine power over unsuitable terrain due to an exhaust valve stuck in the open position.NTSB NYC01LA144Accident · Minor injuriesLimited investigationFinal reportEurocopter France AS-350-BA · Hopewell, NJthe pilot's improper decision to continue flight in instrument meteorological conditions, and which resulted in an in-flight collision with trees. Factors were the fog, and dark night conditions.NTSB NYC01LA135Accident · No injuriesLimited investigationFinal reportMusso Nieuport 24 · Evesham Twp., NJAn in-flight propeller failure, which resulted in a forced landing.NTSB IAD01LA045Accident · No injuriesLimited investigationFinal reportCessna 182N · Cedarville, NJThe pilot's failure to maintain directional control during the landing flare. A factor was the wind gusts.NTSB IAD01LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJpilot's failure to maintain directional control during the landing roll-out. A factor was the crosswind.NTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.