NTSB investigations, NJ
20 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1985 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 NYC07IA015Incident · No injuriesIncident investigationFinal reportBoeing 757-224 · Newark, NJThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Contributing was the night lighting conditions.NTSB NYC06CA225Accident · No injuriesData collectionFinal reportPiper PA-25-180 · Mount Holly, NJThe pilot's improper starting procedure, which resulted in an uncontrolled taxi, and collision with a parked airplane.NTSB NYC06LA191Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Newark, NJThe captain's failure to follow company procedures, which resulted in pushback with the parking brake set. A factor was the larger than preferred tug.NTSB NYC06CA022Accident · Serious injuriesData collectionFinal reportCameron Balloons O-90 · Bethlehem Twp., NJThe ground crewmember's inadvertent entanglement in the balloon's vent lines.NTSB IAD05LA112Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Mount Holly, NJThe flight instructor's delayed remedial action. A factor was the flight instructor's failure to ensure that both pilots knew who was performing the maneuver.NTSB NYC05FA026Accident · No injuriesField investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe flightcrew's inadvertent engagement of the autothrottle system, and their failure to recognize the engagement during landing, which resulted in a runway excursion. Factors were the lack of autothrottle switch guards, lack of an autothrottle engagement…NTSB NYC04LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Pittstown, NJThe pilot's failure to obtain a proper climb rate during a go-around, which resulted in a forced landing and subsequent impact with a tree.NTSB NYC03LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Berlin, NJThe pilot's inadequate preflight inspection which led to an unsecured cowling and loss of aircraft control. Factors were the pilot's diverted attention and the unsecured cowling.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 NYC99LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Newark, NJThe flight attendant's failure to follow cabin door opening procedures.NTSB IAD98LA105Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Freehold, NJThe passenger's failure to secure himself during landing.NTSB NYC97LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-44-180T · Caldwell, NJThe pilot's incapacitation due to a heart attack.NTSB NYC93IA064Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Newark, NJThe pilot's disorientation while taxiing, resulting in a runway incursion. Factors contributing to the incident were: the failure of the flight crew to communicate with the ATC ground controller to verify their position; the inadequate crew coordination; and…NTSB BFO90LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ocean City, NJFailure of the pilot to obtain proper assistance or properly secure (tie down/chock) the aircraft.NTSB NYC89LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJImproper decision and planning by the check pilot (f/e) which resulted in loss of proper alignment and collision with a snowbank at the edge of the runway. Contributing factors were: inadequate preflight by the f/e, f/e's unsecured shoulder harness, premature…NTSB NYC88LA224Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Wall Township, NJIncapacitation of the pilot due to a heart attack and an emergency landing in trees by a non-pilot passenger.NTSB NYC88LA168Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJDuring a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…NTSB NYC88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Groucester Twsp, NJThe student pilot was on a cross country training flight. He stated that the VOR was inoperative but he recognized the VOR by a road that passed near it. The pilot became disoriented and was not able to locate a checkpoint. He descended to 1500 feet, spotted…NTSB NYC87LA090Accident · No injuriesLimited investigationFinal reportCessna 150C · Manville, NJAfter making a rest stop, the plt attempted to restart the eng, using a normal start procedure, but the starter would not engage. He tried to turn off the ignition switch, but said that 'possibly due to the fact that I was wearing heavy gloves, I failed to…NTSB NYC85FA162Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Cape May, NJThe tow plane came in for a banner pickup. The ground handler holding the tail of the double banner had his left foot caught by the banner as it went airborne. The ground handler was carried 50 to 100 ft in the air prior to falling to the ground. The ground…